VARPA function - Function that calculates variance based on the entire set, including logical values ​​and text in Excel

The following article introduces you to the VARPA function - one of the functions in the statistical group is very popular in Excel.

VARPA function - Function that calculates variance based on the entire set, including logical values ​​and text in Excel Picture 1

Description: The function performs calculation of variance based on the entire population, including logical values ​​and text.

Syntax: VARPA (value1, [value2], .)

Inside:

- value1, [value2], .: The arguments in the whole need to calculate the variance, where value1 is the required argument, the next arguments are optional and contain up to 254 value arguments .

Attention:

- The VARPA function assumes that its arguments are an 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.

- True value is 1 default, false value is 0 default.

- 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 VARP function .

- The equation to calculate the VARA 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:

VARPA function - Function that calculates variance based on the entire set, including logical values ​​and text in Excel Picture 2

- In the cell to calculate enter the formula : = VARPA (D6: D10)

VARPA function - Function that calculates variance based on the entire set, including logical values ​​and text in Excel Picture 3

- Press Enter -> variance based on the entire set of number values ​​is:

VARPA function - Function that calculates variance based on the entire set, including logical values ​​and text in Excel Picture 4

- Here the calculated logical values ​​correspond to its default values.

-Where all numeric values ​​are text or logic -> the function still calculates and returns the result:

VARPA function - Function that calculates variance based on the entire set, including logical values ​​and text in Excel Picture 5

Above are instructions and some specific examples when using VARPA function in Excel.

Good luck!