Calculation

Excel formula

Summary Statistics (standard deviation) | # gomaths.net/4237

Calculate summary statistics: (population) standard deviation

=STDEV.P(B1:B10)

where B1:B10 is the range of cells containing numerical data.

Summary Statistics (sum, minimum, maximum) | # gomaths.net/4233

Calculate summary statistics: sum, minimum, maximum

Sum: =SUM(B1:B4)

Minimum: = MIN(B1:B4)

Maximum: = MAX(B1:B4)

where B1:B4 is the range of cells containing numerical data