VARPA is a calculation function in Excel that produces variance based on an entire set, including logical values and text in Excel.
VARPA function in Excel, the calculation function of variance
How to use the VARPA function in Excel
1. Description and syntax used
This is a function that calculates variance based on an entire population, including logical values and text.
The syntax of this function is:
VARPA (value1, [value2], …)
– Value1, [Value2], …: The arguments in the whole population that need to be calculated Value1 are required arguments, subsequent arguments are optional, and contain up to 254 value arguments.
– Function VARPA Assuming its arguments are the entire population.
– 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.
– Value TRUE The default is 1, the value FALSE The default is 0.
– Function error occurs when arguments are text or error values cannot be converted.
– If you do not want to calculate both logical values and text -> use the function VARP.
– Functional equation VARPA was:
+ x is the sample mean AVERAGE (number1, number2, …)
+ n is the sample size.
2. Examples of specific situations
Suppose you need to calculate variance based on an entire population with specific information like the spreadsheet image below:
Step 1: In the cell to calculate -> you enter the formula: = VARPA (B3: B9)
Step 2: Press Enter -> The variance results based on the entire set of values are:
– Here the calculated logical values correspond to its default values.
– Where all values are text or logic -> the function still calculates and returns the result:
– If the arguments are text or an error value cannot be converted ->, the function returns the value as an error:
So Taimienphi.vn has just taught you how to use VARPA function in Excel. This is a calculation function that produces a variance based on an entire population, including logical values and text in Excel.
If you only want to calculate variance based on a sample (including both logical and text values) then you must use the function VARA. Wish you success when working with functions in Excel!
You don’t know how to merge cells when they all have different data? Immediately refer to the article about tips ConcateNate function to find a solution for you guys.