View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
14462Bug reportsStatisticspublic2019-04-30 09:11
Reportercdorin Assigned ToMazi  
PrioritylowSeverityminor 
Status closedResolutionopen 
Product Version3.15.x 
Summary14462: Statistics - SUM not calculated correctly for Single Choice Question
Description

I am not sure what column SUM is supposed to display (see screenshot). I cannot understand how those numbers are calculated.

I have also attached a .lsa file.

TagsNo tags attached.
Attached Files
Test_single_choice.lsa (4,038 bytes)
Selection_076.png (25,799 bytes)   
Selection_076.png (25,799 bytes)   
Bug heat4
Complete LimeSurvey version number (& build)irrelevant
I will donate to the project if issue is resolvedNo
Browser
Database type & versionirrelevant
Server OS (if known)
Webserver software & version (if known)
PHP Versionirrelevant

Users monitoring this issue

There are no users monitoring this issue.

Activities

cdorin

cdorin

2019-02-11 15:25

reporter   ~50499

Will mark it with low priority since Statistics needs to be redone.

Mazi

Mazi

2019-03-04 15:26

updater   ~50755

@cdorin, I introduced that feature for the 5pt scale questions about 10 years ago. The goal is to sum up items 1+2 and 4+5 because when analyzing data of such rating questions these answers are often grouped like "X percent LIKE" and "Y percent DISlike" item ABC.

The numbers look correct to me :
1+2 = 2 of 4 answers = 50%,
3 = 1 of 4 = 25%
4+5 = 1 of 4 = 25%

cdorin

cdorin

2019-03-04 16:12

reporter   ~50757

@Mazi, that's fantastic. Now I can finally understand those numbers :D

Isn't the column name, sum, a bit misleading?

Mazi

Mazi

2019-03-04 16:20

updater   ~50760

@cdorin, I agree, I think back then it was originally named "Aggregated values". Feel free to adjust this as it makes sense.

Mazi

Mazi

2019-03-07 08:33

updater   ~50818

@cdorin, please close this one once you updated the documentation. Thanks!

cdorin

cdorin

2019-03-08 14:53

reporter   ~50852

Updated it now: https://manual.limesurvey.org/Statistics#FAQs

Issue History

Date Modified Username Field Change
2019-01-29 16:49 cdorin New Issue
2019-01-29 16:49 cdorin Status new => assigned
2019-01-29 16:49 cdorin Assigned To => LouisGac
2019-01-29 16:49 cdorin File Added: Test_single_choice.lsa
2019-01-29 16:49 cdorin File Added: Selection_076.png
2019-02-11 15:25 cdorin Priority none => low
2019-02-11 15:25 cdorin Note Added: 50499
2019-03-04 15:26 Mazi Note Added: 50755
2019-03-04 15:29 Mazi Assigned To LouisGac => Mazi
2019-03-04 16:12 cdorin Note Added: 50757
2019-03-04 16:20 Mazi Note Added: 50760
2019-03-07 08:33 Mazi Note Added: 50818
2019-03-08 14:53 cdorin Status assigned => resolved
2019-03-08 14:53 cdorin Note Added: 50852
2019-04-30 09:11 c_schmitz Status resolved => closed