Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Statistical Functions

 

VARP(number1,number2, ) calculates variance based on the entire population

Input the formula: =VARP(A2:A11). Press Enter to get the result. Referenced from Excel Help