Mega Code Archive
Categories
/
MSOfficeExcel 2007 Tutorial
/
Statistical Functions
VARA(value1,value2, ) estimates variance based on a sample, including numbers, text, and logical values
Input the formula: =VARA(A2:A11). Press Enter to get the result. Referenced from Excel Help