Course / Data Analysis

Descriptive statistics: the summary table

Build the ToolPak's Descriptive Statistics report with formulas: centre, spread, shape and the standard error. Intermediate · 7 min · AVERAGE, STDEV, VAR, SKEW, KURT, Standard error, Descriptive statistics

The ToolPak's Descriptive Statistics tool summarises a column in one table: where the values sit, how spread out they are, and what shape they have. Here you'll build that same table with formulas, in the same order, so it stays up to date.

The data are delivery times, in minutes, for 20 orders. You'll need:

Steps

  1. Start at the bottom of the table with the basics. Fill in the Count (E14), Sum (E13), Minimum (E11) and Maximum (E12) of the delivery times in B2:B21.

  2. Now the centre. Fill in the Mean (E2) with AVERAGE, the Median (E4) with MEDIAN and the Mode (E5) with MODE.

  3. Next, the spread. Fill in the Standard Deviation (E6) with STDEV, the Sample Variance (E7) with VAR, and the Range (E10) as the maximum minus the minimum you already have.

  4. The Standard Error says how precisely the 20 orders pin down the true average delivery time. In E3, divide the standard deviation by the square root of the count: =E6/SQRT(E14)

  5. Last, the shape. Fill in the Kurtosis (E8) with KURT and the Skewness (E9) with SKEW.

Remember

In the function reference: AVERAGE, COUNT, KURT, MAX, MEDIAN, MIN, MODE, SKEW, SQRT, STDEV, SUM, VAR

Previous: Histograms with FREQUENCY · Next: Moving averages: smoothing out the noise