All templates
Analysis
Survey Analysis
Turn raw survey answers into counts, averages and simple charts.
Responses3 rows
| # | AQuestion | BResponses | CAverage | DTop answer | E% positive |
|---|---|---|---|---|---|
| 1 | Ease of use | 146 | 4.2 | Agree | 81% |
| 2 | Value for money | 146 | 3.6 | Neutral | 58% |
| 3 | Would recommend | 144 | 4.5 | Strongly agree | 88% |
What it tracks
- Responses
- Scores by question
- Averages
- Comment themes
Included sheets
ResponsesAnalysisCharts
Key calculations
- Average score
- =AVERAGEIFS(Score,Question,A2)
- % positive
- =COUNTIFS(Score,">=4")/COUNT(Score)