This function returns variance based on the entire population, which uses only numeric values.
Syntax
VARP(value1,value2,...)
VARP(array)
VARP(array1,array2,...)
Arguments
Each argument can be a double-precision floating-point value, an integer value, or an array (cell range) of these. Up to 255 arguments may be included. You can use a single array (cell range) instead of a list of values. You can use multiple arrays (cell ranges) as well.
Remarks
The variance returns how spread out a set of data is.
This function uses the following equation to calculate the variance, where n is the number of values.
where x is the value and n is the number of values.
This function assumes that its arguments are the entire population. If your data represents only a sample of the population, then compute the variance using the VAR function.
This function differs from VARPA, which accepts logical or text values as well as numeric values.
Data Types
Accepts numeric data for all arguments. Returns numeric data.
Examples
VARP(B3,C4,B2,D10,E5)
VARP(A1:A9) VARP(R1C2,100,R2C5,102)
VARP(98,85,76,87,92,89,90) gives the result 39.2653061224