STDEVP Function Dictionary

Function Dictionary Function Examples Function Categories

Values Values Values
10 10 10
10 10 11
9 11 9
10 10 12
0.433013 0.433013 1.118034
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. ????????????????????
Soap Powder Box Filling Machine Test Results
Test 1 Test 2 Test 3 Test 4 Variance
Machine 1 1.4 1.5 1.6 1.5 0.0707  =STDEVP(D32:G32)
Machine 2 1.5 1.5 1.4 1.5 0.0433  =STDEVP(D33:G33)
Machine 3 1.5 1.6 1.7 1.8 0.1118  =STDEVP(D34:G34)
    The smallest variance is :  0.0433  =MIN(H32:H34)
The machine with the smallest variance is :  Machine 2
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.


Popular posts from this blog

Tamilnadu SIXTH all books free download, Tamilnadu 6th all books free download

Tamilnadu FIRST STANDARD all books free download, Tamilnadu 1ST STANDARD all books free download