Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Maximum total score for multiple choice question with different weights

  • douglasepr
  • douglasepr's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
3 years 10 months ago #217836 by douglasepr
I have a multiple choice question that each choice has a different weight and the maximum total score for the question is 1.67.
So, in the first picture attached if the respondent select the first and second choices. His total score would be 0.42 + 0.42 = 0.84 for example.
If he selects the first, fourth, and fiveth. His total score would be 0.42 +0.83 + 0.83 = 1.67, because the maximum score for the entire question is 1.67.

How can I set this condition in detail?

Also, when I export the survey's answers to excel, they come as showed in the second picture, but I need that the answers come as showed in the third picture. 
How can I set that?
The topic has been locked.
More
3 years 9 months ago #218012 by paul.borsdorf
I think it would be easiest to do this in Excel: =a1*0.42 +a2*0.42 + a3*0.42 ...
The following user(s) said Thank You: douglasepr
The topic has been locked.
Moderators: tpartnerholch

Lime-years ahead

Online-surveys for every purse and purpose