Mean
The average (arithmetic mean) of the responses for all question types but Rating scaleis calculated as follows:
The row consists of the values assigned to the answers. Each value is taken as many times as there are responses to each answer. The values are summed up.
By default the values are set to the answers accordingly to their sequence number.
2. The sum is divided by the total number of responses.
Example #1
Pick one
Question | Answer choices | Values | Responses | Row | Mean |
Which kind of music do you prefer? | Pop | 1 | 2 | 1, 1, 2, 3, 3, 3, 3 | (1+1+2+3+3+3+3)/7=2.286 |
| Rock | 2 | 1 |
|
|
| Jazz | 3 | 4 |
|
|
|
|
| Total |
|
|
|
|
| 7 |
|
|
The values 1, 2, 3 are assigned to the answer choices 'Pop', 'Rock' and 'Jazz' for the Pick one question. The 'Pop' answer has 2 responses, 'Rock' - 1 response, and 'Jazz' - 4 responses. The total number of responses is 7. According to the calculation rules: Sum = 1+1+2+3+3+3+3=16 and Mean = 16/7=2.286
The average (arithmetic mean) of the responses for the Rating scalequestion type is calculated as follows:
The number of responses to the rated object is summed up.
The value obtained on step 1 is divided by the number of scales.
Example #2
Question | Rated objects | Scales (responses) | Mean |
|
|
|
|
| Always | Often | Sometimes | Rarely |
|
How often do you drink: | Tea | 8 | 3 | 5 | 2 | (8+3+5+2)/4 = 4.5 |
| Coffee | 2 | 8 | 1 | 4 | (2+8+1+4)/4 = 3.75 |
| Coca Cola | 3 | 6 | 3 | 4 | (3+6+3+4)/4 = 4 |
In the rated object 'Tea' the 'Always' scale was selected 8 times, 'Often' - 3, 'Sometimes' - 5, 'Rarely' - 2. The number of scales is 4. According to the calculation rules: Sum = 8+3+5+2=18 and Mean = 18/4 = 4.5. Mean for the 'Coffee' and 'Coca Cola' rated objects is 3.75 and 4 correspondingly.