Range: what it means and how to read it
In the report: range — max − min.
How to read it
The width of the span of values. It depends on the two extremes only, so one odd value changes it — iqr is steadier.
In plain words
Two classes both have an average mark of 70, and a teacher wanted to know whether they are alike. In class A the marks go from 65 to 75, so the range is 10. In class B they go from 30 to 100, so the range is 70. Now she can see at once that the students in class B are far more spread out. But the range looks only at the two ends. If the 30 was a student who was ill on the day, one odd mark stretches the range, and then iqr, the spread of the middle half of the marks, is steadier.
How it is computed
range = max − minWhere you see it
STATS_DESCRIPTIVE— Column-wise descriptive statistics with flexible metric selection and optional column filtering.
Related values
- Missing values — The number of empty answers and of cells that do not match the column type (text in a number column), inside the selected rows.
- Variance — The mean squared deviation from the mean: sample formula (n − 1); with pop = TRUE in Settings, population (n).
- Standard deviation — The square root of the variance: sample formula (n − 1); with pop = TRUE in Settings, population (n).
- Coefficient of variation — std / mean; empty when the mean is 0.
- Relative dispersion — std / median; empty when the median is 0.
Get it in your sheet
One formula in a cell gives the whole report, Range included. ALS Stats is a free add-on for Google Sheets™.
Install ALS Stats from Google Workspace Marketplace (opens in a new tab)