Descriptive statistics (Analysis ToolPak) in Excel - Cell-by-Cell Formula Trace

Sample Data

This column contains test scores of 9 students.

Cell	Value
A1	Scores
A2	85
A3	90
A4	78
A5	92
A6	88
A7	75
A8	95
A9	80
A10	85

Formula Trace

Descriptive Statistics from Analysis ToolPak (no single formula, but output includes Mean, Median, Mode, Std Dev, etc.)

Step 1: Calculate Mean = AVERAGE(A2:A10)

Step 2: Calculate Median = MEDIAN(A2:A10)

Step 3: Calculate Mode = MODE.SNGL(A2:A10)

Step 4: Calculate Standard Deviation = STDEV.S(A2:A10)

Step 5: Calculate Variance = VAR.S(A2:A10)

Step 6: Calculate Range = MAX(A2:A10) - MIN(A2:A10)

Cell Reference Map

    A   
1 |Scores|
2 | 85  |
3 | 90  |
4 | 78  |
5 | 92  |
6 | 88  |
7 | 75  |
8 | 95  |
9 | 80  |
10| 85  |

The formula references the range A2:A10 which contains the scores.

Result

    A       B
1 |Scores| Statistic
2 | 85   | Mean: 84.67
3 | 90   | Median: 85
4 | 78   | Mode: 85
5 | 92   | Std Dev: 6.62
6 | 88   | Variance: 43.83
7 | 75   | Range: 20
8 | 95   |
9 | 80   |
10| 85   |

The descriptive statistics summary shows mean, median, mode, standard deviation, variance, and range calculated from the scores.

Sheet Trace Quiz - 3 Questions

What is the mean of the scores in A2:A10?

A 84.67

B 85

C 6.62

D 20

Key Result

Descriptive statistics summarize data using formulas like AVERAGE, MEDIAN, MODE.SNGL, STDEV.S, VAR.S, MAX, and MIN on a data range.