STDEVP

 

This function calculates the standard deviation of a list of values.
The result is calculated on the basis that the values represent the entire population.

Syntax

=STDEVP(Range1,Range2,Range3 through to Range30)

Formatting

No special formatting is needed.

Example
The table below was used by a company interested in buying a new machine
to pack washing powder.
A trial run of just four boxes per machine were produced.
The boxes were weighed and the =STDEVP() function used as these boxes
represented the entire test run.
The machine with the smallest variance was the most consistent. ????????????????????

Explanation of formula:

This finds the lowest value. =(MIN(H32:H34)
This finds the position of the lowest value. =MATCH(MIN(H32:H34),H32:H34,0)
This looks down the Machine column to =INDEX(C32:C34,MATCH(MIN(H32:H34),H32:H34,0))
find the machine name.