VARPA(value1,value2,...) calculates variance based on the entire population, including numbers, text, and logical values : VARPA « Statistical functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Statistical functions
  3. VARPA
Input the formula: =VARPA(A2:A11). Press Enter to get the result.
Input the formula: =VARPA(A2:A11)

Referenced from Excel Help

21.80.VARPA
21.80.1.VARPA(value1,value2,...) calculates variance based on the entire population, including numbers, text, and logical valuesVARPA(value1,value2,...) calculates variance based on the entire population, including numbers, text, and logical values