VARP(number1,number2,...) calculates variance based on the entire population : VARP « Statistical functions « Microsoft Office Excel 2007 Tutorial






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

Referenced from Excel Help

21.79.VARP
21.79.1.VARP(number1,number2,...) calculates variance based on the entire populationVARP(number1,number2,...) calculates variance based on the entire population