What each number means
- Mean, median and mode describe the center. The median is the middle value once the data is sorted.
- Quartiles split the sorted data into four parts. Q1 has a quarter of the values below it and Q3 has three quarters. The interquartile range, IQR = Q3 − Q1, is the spread of the middle half.
- Outliers are values below Q1 − 1.5 × IQR or above Q3 + 1.5 × IQR (Tukey's rule).
- Standard deviation is the typical distance from the mean. The coefficient of variation is the sample SD as a percent of the mean.
- Skewness measures lopsidedness: positive when there's a long tail of high values. Excess kurtosis compares the tails with a normal distribution, which scores 0.
How the quartiles are found
There's no single agreed way to compute quartiles. Hyndman and Fan (1996) list nine methods used by statistics software. The main results here use the method of the TI-83/TI-84 and most US statistics textbooks (Moore and McCabe):
(with an odd count, the median itself is left out of both halves)
Tukey's hinges include the median in both halves instead, and Excel and R interpolate between values. All four are shown under the results so you can match your class or software. They agree more closely as the data set grows.
Worked example
For 12, 15, 17, 18, 20, 21, 22, 25, 26, 48 (n = 10): the sum is 224, so the mean is 22.4. The median is (20 + 21) ÷ 2 = 20.5. The lower half 12, 15, 17, 18, 20 gives Q1 = 17, and the upper half 21, 22, 25, 26, 48 gives Q3 = 25. So IQR = 8, and the fences are 17 − 12 = 5 and 25 + 12 = 37. That makes 48 an outlier, which also explains why the mean is above the median and the skewness is positive.
Formulas
Excess kurtosis G₂ = (n − 1) ÷ ((n − 2)(n − 3)) × ((n + 1) × (m₄ ÷ m₂² − 3) + 6)
where m_k = Σ(x − x)ᵏ ÷ n
These match Excel's SKEW and KURT functions. The population skewness g₁ = m₃ ÷ m₂^1.5 is shown too.
Limits
- With fewer than 3 values there's no skewness, and with fewer than 4 no kurtosis.
- The 1.5 × IQR rule flags values for a closer look. It doesn't prove they're errors, and in large data sets some flagged values are expected.
- Up to 100,000 numbers can be pasted. Use a point as the decimal mark.