Spread Formula Reference
Formula Functions / Functions T to Z / VAR.P
In This Topic
    VAR.P
    In This Topic

    Summary

    This function returns variance based on the entire population, which uses only numeric values.

    Syntax

    VAR.P(value1,value2,...)

    VAR.P(array)

    VAR.P(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.

    Logical values and text representations of numbers that are typed into the list of arguments are counted. If an argument is an array or reference, only numbers in that array or reference are counted. Empty cells, error values, logical values, or text in the array or reference are ignored.

    This function uses the following equation to calculate the variance,

    VAR.P Equation

    where x is the sample mean AVERAGE(number1,number2,…) 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.S 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

    VAR.P(B3,C4,B2,D10,E5)

    VAR.P(A1:A9)

    VAR.P(R1C2,100,R2C5,102)

    VAR.P(98,85,76,87,92,89,90) gives the result 39.26530612

    Version Available

    This function is available in Spread for Windows Forms 11.0 or later.