The VARP() function calculates the variance of an entire population values. The syntax for the function is VARP (number1, number2, ...number_n). The arguments "number1, number2, ..number_n" can be numerical values, references to a range of cells or a named range of which you want to find the variance (up to 30 data points).The function accepts logical values when entered directly into the function as arguments but the function will ignore referenced logical value and other terms not recognized as numerical values. Note: arguments that are text that cannot be translated into numerical values or that contain errors will cause the function to return an error value. The VARP function returns the amount of variance of a population which describes how distributed the population data is. It can also be thought of the square of the standard deviation or more specifically the average squared deviation form the mean. [chart and worked example comparing VAR and VARP] To learn more about variance in statistics see: [The Variance Mathematics Knowledgebase]

How to use the VARP() function: Type " =VARP( " Enter the reference for the array of data "A2:A10". Type")" then press the "Enter" key.

Note: The VAR and the VARA functions are only estimate the variance of the population data as they use a sample of data values no the complete pupulation of data value.