How to Calculate Mean & S.D. for Likert-Scale Questionnaires (with 5-Level Interpretation)
Once your survey data is collected, the key step in Chapter 4 (Results) is computing basic statistics — the mean and standard deviation (S.D.) — to describe your data.
1. Arithmetic Mean (x̄)
The sum of all scores divided by the number of respondents. It tells you the overall opinion of the sample toward each item.
2. Standard Deviation (S.D.)
- Low S.D. (near 0): respondents answered similarly (consensus).
- High S.D. (above 1.00): opinions differ widely.
3. Five-Level Interpretation (Best, 1977)
Each interval spans (5 − 1) / 5 = 0.80:
- 4.21 – 5.00: Highest
- 3.41 – 4.20: High
- 2.61 – 3.40: Moderate
- 1.81 – 2.60: Low
- 1.00 – 1.80: Lowest
Computing this item by item in Excel is slow and error-prone. Our free tool computes the mean and S.D. per item, applies the interpretation automatically, and drafts the report text for Chapter 4.
Frequently asked questions
Why report S.D. alongside the mean?
The S.D. shows the spread of the data. A high S.D. means respondents disagree widely; a low S.D. means their opinions are consistent.
What is the most common 5-level interpretation criterion?
Best's (1977) criterion is the most widely used, dividing the scale into intervals of 0.80 (e.g., 4.21–5.00 = highest).
ⓘ This article is general information to help you get started, not advice for your specific project. Before using it in your research, please check it against textbooks, your faculty's requirements and your advisor. Khontob is a team that helps researchers find survey respondents.