| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 14625 | Bug reports | Statistics | public | 2019-03-11 13:50 | 2019-04-02 16:41 |
| Reporter | f_funke | Assigned To | |||
| Priority | none | Severity | minor | ||
| Status | closed | Resolution | fixed | ||
| Fixed in Version | 3.17.x | ||||
| Summary | 14625: Summary Table (Frequencies) for 5-Point Choice is Confusing (+ Feature Request) | ||||
| Description | The current implementation of the statistics (for 5-point choice) #1: The cell where column "sum (answers)" meets "Percentage" is not correct or not positioned correctly (marked yellow in uploaded file 1). It suggests that it the sum of the preceeding rows but actually it is the sum of all percentages. So this row should be put two rows below. #2: The column "Sum" is confusing (marked red in uploaded file 1). It presents values that are in market research sometimes called "top two boxes" and "bottom two boxes" (or just "top-2" and "flop-2"/"bottom-2"). So this denotation could be used. #3 - Feature Request: Overall, the display of the summary frequency table lacks important pieces of information. Especially two separate columns for overall percent (based on all cases), valid percent (based on those who answered a question), and cumulative percent (sum of all previous percentages) are needed. See uploaded file 2 for a suggestion. This would include all numbers presented by SPSS Statistics plus additional numbers (cummulative gross percent and top-/bottom-2). | ||||
| Tags | No tags attached. | ||||
| Bug heat | 10 | ||||
| Complete LimeSurvey version number (& build) | 3.15.9 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | |||||
| Database type & version | LimeSurvey Professional | ||||
| Server OS (if known) | |||||
| Webserver software & version (if known) | |||||
| PHP Version | LimeSurvey Professional | ||||
 |
@Mazi, any thoughts on this? Maybe this can be changed in LS4. |
 |
@cdorin, I agree to the issues mentioned by @f_funke: We should a) move the "Sum" row down a little and b) rename the "Sum" column. Both should be rather simple adjustments and should be considered bug fixes for Limesurvey 3. The additional adjustments requested should be taken into account for Limesurvey 4 or 5 but I do NOT recommend adding this to the current code because the source code for the whole statistics part is a nightmare. This should only be added once stats get rwritten from scratch. I guess this will not happen for LS 4 but more likely for LS 5, Olle or Louis can tell you more. |
 |
Thanks for your ideas, @Mazi! Renaming column "Sum" is a good point to start. However, moving the row "Sum (answers)" down would look strange for the last column. Would it be possible with a reasonable amount of work to copy and adjust row "Sum (answers)" so that is presented both at the present position (as "Total (valid)") and below "not completed/displayed" (as "Total (gross)")? See the following illustration. small_update_summary_frequency_table_190312.png (13,646 bytes) |
|
|
RE "Would it be possible with a reasonable amount of work to copy and adjust row "Sum (answers)" so that is presented both at the present position (as "Total (valid)") and below "not completed/displayed" (as "Total (gross)")? See the following illustration.": I leave that to the developers to answers. Since it requires doing additional calculations and not just placing an existing data set at a different row, it could be more complex than expected. |
 |
Should proposed presentation be shown only for 5-Point Choice question type? |
|
|
No, all question types with similar reports should be affected. But even though I think the top-/flop-2 summary is nice for certain users, the middle percentage poses some problems with other rating scales (with an even number of response options). But if we would add the cumulative valid percent, users could just read out the top-2 value easily. For the bottom-2 we would need something like cumullative percent (decending). The question is, if we opt for a small fix (updated column names) or rebuild the tables from scratch. But if there should be plans to change the whole statistics module, we should just wait. What do you think? |
|
|
Statistics module is meant to be rebuilt, but it is not currently a priority. |
|
|
This issue is fixed: |
|
|
5 point: Screenshot_2019-03-29_18-30-55.png (34,663 bytes) |
|
|
List (radio): Screenshot_2019-03-29_18-31-16.png (24,689 bytes) |
|
|
Much more clear now for the users. Thanks |
|
|
That is a huge step forward. Thanks |
