Two sample groups of waiting times both average 10 minutes. One varies by a minute around the center and the other by five. Calculate spread as well as the mean.

Compare the same unit in both groups

Enter 9, 10, 11 in B2:B4 and 5, 10, 15 in C2:C4. Use =STDEV.S(B2:B4) and =STDEV.S(C2:C4). The expected sample standard deviations are 1 and 5 minutes.

The readings 9, 10, 11 cluster near 10 while 5, 10, 15 spread out.

Illustrated comparison on the same time scale.

Report spread with the mean and count

Write that both averages were 10 minutes, based on three readings per group. Include the sample standard deviations beside them. Keep real zero readings numeric and check missing observations separately. These small samples illustrate the calculation, and a larger sample is needed to characterize a variable process more reliably.

A summary shows the mean, sample standard deviation, and count for both samples.

Illustrated reporting check. Keep the units with the statistic.

Microsoft’s STDEV-S function reference