The last few weeks have been so busy – it’s been fun (most of the time, I think) but we have just rolled out a new report on our survey reporting platform – the Score Index report – which addresses the very common requirement in customer and employee surveys to convert a question’s results into some form of score.
Obviously, not all questions can be scored (no points for being male, or under 25!) so the Score Index is the average answer for a “rating” type question – examples include questions that start how far do you agree/disagree…, how satisfied are you with x, how likely are you to … etc. Each answer is assigned a score (between 0 and 100), the responses are then totalled and averaged to arrive at a score for this question.
An example is often the simplest way to explain this. If the question, “Overall, how satisfied were you with X” had ten responses:
| Answer | No. of Responses |
|---|---|
| Very Satisfied | 3 |
| Somewhat Satisfied | 2 |
| Neither Satisfied or Dissatisfied | 3 |
| Somewhat Dissatisfied | 1 |
| Very Dissatisfied | 1 |
| Total | 10 |
Then the Index Score would be calculated thus:
| Answer | Weighting | Sub-Total |
|---|---|---|
| Very Satisfied | 3 x 100 | 300 |
| Somewhat Satisfied | 2 x 75 | 150 |
| Neither Satisfied or Dissatisfied | 3 x 50 | 150 |
| Somewhat Dissatisfied | 1 x 25 | 25 |
| Very Dissatisfied | 1 x 0 | 0 |
| Total | 625 | |
| Average | 625 / 10 | 62.5 |
Our Score Index weighs each answer evenly between 0 and 100, so taking the example above the range is 0 (for very dissatisfied), 25 (for somewhat dissatisfied), 50, 75 and 100 (for Very Satisfied). It doesn’t matter what range of answers your question had – if there were just 3 options say (a) I liked it, (b) Neutral and (c) I hated it then the report will weight the answers as 100,50,0. (Note that for a question using a 10 point scale, this would result in the range being 0, 11.1, 22.2, 33.3, 44.4, 55.6, 66.7, 77.8, 88.9, 100.)
To view your Score Index reports, click on the Score Index tab at the top of your reports (only present if your survey contains “rating” type questions).



