Calculation
Excel formula
Hover over image for animation
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
Weekly wage | # gomaths.net/4217 User submitted, thanks to Simon Job
Calculate weekly wage given hours worked and hourly rate.
=B2*C2
where B2 is the hours worked and C2 is the hourly rate
