The following article introduces you to the VAR.P function - one of the functions in the statistical function group is very popular in Excel.
Description: The function performs calculation of variance based on the entire population, ignoring logical values and text. Support functions from Excel 2010 onwards.
Syntax: VAR.P (number1, [number2], .)
Inside:
- number1, [number2], .): The arguments in the whole need to calculate the variance, where number1 is the required argument, the next arguments are optional and contain up to 254 number arguments .
Attention:
- The VAR.P function assumes that its arguments are whole.
- Arguments can be numbers, names or arrays that contain numbers.
- If the argument is an array or a reference, only values in that array are used.
- When typing logical values and presenting numeric values into function arguments -> these values are still calculated.
- Function error occurs when arguments are text or error values cannot be converted.
- If you want to calculate both logical values and text -> use VARPA function .
- The equation to calculate the VAR.P function is:
[frac {{sum {{{left ({x - overline x} right)} ^ 2}}}} {n}]
Inside:
+ x is the sample mean AVERAGE (number1, number2, .)
+ n is the sample size.
For example:
Calculate variance based on the entire set of number values in the following data table:
- In the cell to calculate enter the formula : = VAR.P (D6: D10)
- Press Enter -> variance based on the entire set of number values is:
-Where the values are text or logic -> the function ignores these values:
Above are instructions and some specific examples when using VAR.P function in Excel.
Good luck!