Quote:
Originally Posted by sapiens
I might use a larger scale and include a neutral point (neither satisfied, nor dissatisfied), but if you're just looking for the average, each person's response is a score, add up all of the responses and divide by the number of responses.
((113 x 3)+(57 x 2)+(30 x 1))/200
|
sapiens, i think you forgot the 'very satisfied' people, wouldn't you have ((100*4) + (113*3) + (57*2) + (30*1))/200 ?
Bascially
gothmund, you're just adding up all the responses, and then dividing by the total number of responses. The multiplication steps in the above just speed it up. If you're tallying these in Excel, then it has an 'average' function that will calculate it for you.