StatPakDescriptive statistics in Google Sheets
Descriptive statistics summarise a column of numbers. Example: 20 exam scores in A2:A21.
All at once
In StatPak choose Descriptive Statistics, select A1:A21, tick Labels in first row, Summary statistics and Confidence level (%), then Run.
| Score | |
| Mean | 75.6 |
| Standard Error | 2.254119 |
| Median | 75 |
| Mode | 75 |
| Standard Deviation | 10.08073 |
| Sample Variance | 101.6211 |
| Kurtosis | -0.3354797 |
| Skewness | 0.05892628 |
| Range | 39 |
| Minimum | 56 |
| Maximum | 95 |
| Sum | 1512 |
| Count | 20 |
| Confidence Level(95.0%) | 4.717925 |
One at a time with functions
| Statistic | Formula | Value |
|---|---|---|
| Mean | =AVERAGE(A2:A21) | 75.6 |
| Standard Error | =STDEV.S(A2:A21)/SQRT(COUNT(A2:A21)) | 2.254119 |
| Median | =MEDIAN(A2:A21) | 75 |
| Mode | =MODE(A2:A21) | 75 |
| Standard Deviation | =STDEV.S(A2:A21) | 10.08073 |
| Sample Variance | =VAR.S(A2:A21) | 101.6211 |
| Kurtosis | =KURT(A2:A21) | -0.3354797 |
| Skewness | =SKEW(A2:A21) | 0.05892628 |
| Confidence Level (95%) | =CONFIDENCE.T(0.05, STDEV.S(A2:A21), COUNT(A2:A21)) | 4.717925 |
What the numbers mean
- Standard Error measures how precisely the mean is estimated. It shrinks as the sample grows.
- Kurtosis is excess kurtosis: 0 for a normal distribution, negative for flatter shapes, positive for heavier tails.
- Skewness near 0 means roughly symmetric. Positive means a longer right tail.
- Confidence Level is the margin of error. The 95% confidence interval for the mean is Mean plus or minus this value.