Home Computer Learn STD deviation formula in excel Uses With Example.

Learn STD deviation formula in excel Uses With Example.

1 min read


google document excel


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.


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


No special formatting is needed.

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. ????????????????????

excel signatures, google excel sheet

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.

Load More Related Articles
Load More By amitgupta
Load More In Computer

Leave a Reply

Check Also

How to Check BUSY Updates

How to Check BUSY Updates Company > Check BUSY Updates Check BUSY Updates option provid…