Rating and Ranking Averages Calculations

The following question types calculate an average or weighted average:

Rating Scale

Rating Scale questions calculate a weighted average based on the weight assigned to each answer choice. If needed, you can change the weight of each answer choice in the Design section of the survey, even after the survey has collected responses.

The rating average is calculated as follows, where:

w = weight of answer choice
x = response count for answer choice

x1w1 + x2w2 + x3w3 ... xnwn

Total

If you chose to include an N/A column on your Rating Scale question, any N/A responses will not factor into the rating average.

Example

For this example, we'll use a 5-point rating scale question. The weights assigned to each answer choices are shown in parentheses:

Responsibilities are shared fairly among your team members.

Strongly Disagree (1)
Disagree (2)
Neither Agree nor Disagree (3)
Agree (4)
Strongly Agree (5)

After collecting responses to the survey, the results will look something like this. 

  Strongly Disagree Disagree Neither Agree nor Disagree Agree Strongly Agree Total Average Rating
Responsibilities are shared fairly among your team members. 20.45%
9
27.27%
12
20.45%
9
11.36%
5
20.45%
9
44 2.84

The average rating of 2.84 indicates that the average sentiment among respondents is that responsibilities are not shared fairly among their team members. The average rating was calculated as follows:

(9*1) + (12*2) + (9*3) + (5*4) + (9*5)

44

125/44 = 2.84

 

Ranking

Ranking questions calculate the average ranking for each answer choice so you can determine which answer choice was the highest ranked overall. The largest average ranking indicates the top answer choice. When presented on a bar graph, for example, the longest bar will logically correspond with the highest ranked answer choice. You cannot change the default weights on the Ranking question.

The ranking average is calculated as follows, where:

w = weight of ranked position
x = response count for answer choice

x1w1 + x2w2 + x3w3 ... xnwn

Total

 

Numerical Textboxes

Numerical Textboxes questions calculate the average of all answers for each textbox.

The average is calculated as follows:

Sum of numerical answers

Total responses