# Rating and Ranking Average 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 ranking average for each answer choice so you can determine which answer choice was most preferred overall. The answer choice with the largest ranking average is the most preferred choice.

The ranking average is calculated as follows, where:

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

 x1w1 + x2w2 + x3w3 ... xnwn Total

Weights are applied in reverse. In other words, the respondent's most preferred choice (which they rank as #1) has the largest weight, and their least preferred choice (which they rank in the last position) has a weight of 1. You can't change the default weights.

For example, if a Ranking question has 5 answer choices, weights are assigned as follows:

• The #1 choice has a weight of 5
• The #2 choice has a weight of 4
• The #3 choice has a weight of 3
• The #4 choice has a weight of 2
• The #5 choice has a weight of 1

We apply weights in this way to ensure that when the data is presented on a chart, it's clear which answer choice is most preferred.

If you chose to include an N/A option on the Ranking question, any N/A responses will not factor into the ranking average.

When you export summary data to XLS the results appear inverted from what you see in Analyze. Excel assigns the rank number of an answer choice as weight, so the #1 choice has a weight of 1, the #2 choice has a weight of 2 and so on. So if the adjusted average in Analyze is calculated as a 6 on a 9-point scale, it appears as a 4 in Excel.

## 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