Following the steps below, you can pull your survey data into a spreadsheet and analyse scores.
| Survey data | Into Excel | Code questions |
 |
 |
 |
| Code customer answers |
 |
|
 |
Use Excel formula to calculate the average (mean) answer for each question and check standard deviation. The average value isn't reliable if the deviation is greater than two. | |
It's worth taking time to check deviation is lower than two for all your survey results. Discrepancies can be explained by a lack of conformity in your customer base. This means that your customers are made up of groups of individuals who have different needs. You may then need to survey these groups individually to understand their satisfaction and needs from your business. Ysatisfy can help you deal with these complexities.