Buzz
Discover the power of VAR.P function in Excel
Learn about its syntax and usage
VAR.P function calculates variance based on the entire dataset, excluding logical and text values. It has been available since Excel 2010.
Syntax:
Syntax: VAR.P(number1, [number2], ...)
Where:
- number1, [number2], ...: The arguments representing the entire population for which variance is to be calculated. Number1 is required, and subsequent numbers are optional, with a maximum of 254 arguments.
Note:
Considering the VAR.P function, assume its parameters represent the entire population. These parameters can be numbers, names, or arrays containing numbers. If the parameter is an array or reference, only the values within that array are used. Even when inputting logical values directly or presenting numbers in text format as function parameters, they are still considered. The function encounters an error if the parameters are text or values that cannot be converted. To compute both logical and textual values, use the VARPA function. The equation for calculating the VAR.P function is:
Where: x represents the sample mean AVERAGE(number1,number2,...) and n denotes the sample size.
2. Specific Scenario Examples
Suppose you need to calculate variance based on the entire dataset below:
Step 1: In the cell where calculation is needed, input the formula: =VAR.P(B3:B9)
Step 2: Press Enter -> the variance result based on the entire set of values is:
- If the values are text or logical, the function disregards them:
- If the parameters are text or values that cannot be converted, the function encounters an error:
Thus, Mytour has just guided you on how to use the VAR.P Function in Excel. This function computes variance based on the entire dataset, excluding logical and textual values.
Additionally, if you need to calculate variance considering the entire dataset, including both logical and textual values in Excel, then you need to use the VARPA function. Wishing you success in working with Excel functions!
