VARP in Excel

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

Content Data

	Soap Powder Box Filling Machine Test Results
	Set 1	Set 2	Set 3	Set 4	Variance
Machine 1	1.4	1.5	1.6	2	0.0519	=VARP(D32:G32)
Machine 2	1.5	1.5	1.4	2.6	0.2425	=VARP(D33:G33)
Machine 3	1.5	1.6	1.7	2.2	0.0725	=VARP(D34:G34)
				The smallest variance is :	0.0519	=MIN(H32:H34)
	The machine with the smallest variance is :				Machine 1
					=INDEX(C32:C34,MATCH(MIN(H32:H34),H32:H34,0))

Example  

The table above  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.