VARPA function in Excel

VARPA function in Excel

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


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:

ham varpa in excel 2


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

ham varpa in excel 3

Step 1: In the cell to calculate -> you enter the formula: = VARPA (B3: B9)

ham varpa in excel 4

Step 2: Press Enter -> The variance results based on the entire set of values ​​are:

ham varpa in excel 5

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

ham varpa in excel 6

– If the arguments are text or an error value cannot be converted ->, the function returns the value as an error:

ham varpa in excel 7

So 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.


Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *