**Are you calculating variance based on the entire population? You do not know which function to use in Excel to calculate and process? Please follow the tutorial on how to use the VARPA function in Excel to know how to calculate variances based on an entire population.**

**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], …)*

**Inside:**

– **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.

**Attention:**

– 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:

**Inside:**

+ **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!

https://thuthuat.taimienphi.vn/ham-varpa-trong-excel-43749n.aspx

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.

.