STATISTIC CALCULATION
Data Set
Count (n)
Measures of dispersion
Minimum
Maximum
Range
Variance
Standard deviation
=STDEV(B2:B12)
Quartile
Inter-quartile range
Measures of central tendency
Mean
Mode
=MODE(B2:B12)
Median
=MEDIAN(B2:B12)
Average
=AVERAGE(B2:B12)