VARP Function (Functions in Excel)
Values | Values | Values | ||
10 | 10 | 10 | ||
10 | 10 | 11 | ||
9 | 11 | 9 | ||
10 | 10 | 12 | ||
0.1875 | 0.1875 | 1.25 | ||
=VARP(C4:C7) | =VARP(E4:E7) | =VARP(G4:G7) |
What Does It Do ? |
This function calculates the variance of a list of values. |
The variance is calculated on the basis that the values represent the entire population. |
Syntax |
=VARP(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 a just four boxes per machine were produced. |
The boxes were weighed and the =VARP() 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.0050 | =VARP(D32:G32) |
Machine 2 | 1.5 | 1.5 | 1.4 | 1.5 | 0.0019 | =VARP(D33:G33) |
Machine 3 | 1.5 | 1.6 | 1.7 | 1.8 | 0.0125 | =VARP(D34:G34) |
The smallest variance is : | 0.0019 | =MIN(H32:H34) | ||||
The machine with the smallest variance is : | Machine 2 | |||||
=INDEX(C32:C34,MATCH(MIN(H32:H34),H32:H34,0)) | ||||||
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. | |
0 comments:
Post a Comment