STDEVP (Calculates standard deviation based on the entire population)

What Does It Do?

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

find the machine name:  =INDEX(C32:C34,MATCH(MIN(H32:H34),H32:H34,0))