Calculation
Excel formula
Hover over image for animation
Summary Statistics (quartiles) | # gomaths.net/4235 User submitted, thanks to Simon Job
Calculate summary statistics: quartiles
First Quartile: =QUARTILE(B1:B10,1)
Second Quartile: =QUARTILE(B1:B10,2)
Third Quartile: =QUARTILE(B1:B10,3)
where B1:B10 is the range of cells containing numerical data.
Note: Excel calculates quartiles differently to the usual method of splitting the data into 25% lots.
Summary Statistics (standard deviation) | # gomaths.net/4237 User submitted, thanks to Simon Job
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 User submitted, thanks to Simon Job
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
