We've released Groups, a new feature that enables us to connect community members of similar industries and interests in a shared, private space. You can check out all of the details here, including information about who can join, how to join, and what Groups are currently offered. Please leave your feedback through this Community Groups Feedback Survey.
Scoring and Reporting multiple choice survey questions  calculating meaningful mean
Hello, complete newbie here.
Was looking via search but unable to find answers so trying here.
What I have is a simple customer satisfaction survey with around 17 questions divided into 4 question blocks. Multichoice "agreedisagree" with scoring 1  5 and categories set for overall score and separate scoring categories for each question block.
Now when the scoring is done, the results and reports calculate a total score for the category and then give me an average based on the sum of total scores divided by a number of responses.
SC0  Overall Score:
 min = 62.00
 max = 73.00
 mean = 67.50
Is there any easy way to get the actual average per question on that group? Say I would have 17 questions on that group, the result would be:
 mean = 3.97
Or is this something better calculated with excel?
Appreciate if anyone would point me in the right direction 🙏
Best Answer

Hi @Mattijok ,
You might find a solution by using Formula Variable Creation in the Data & Analysis module, or Math Operations with Embedded Data in the Survey Flow. Set up a formula that adds up the values of the 17 items and divides the result by 17. Then the reporting module will calculate the min, max, and mean of your calculated values.
0