How to use VAR.P function in Excel

The VAR.P or VARP function is a statistical function in excel. It is used to calculate the variance of entire population. If you want to calculate variance of a sample then use VAR or VARS or VAR.S function. They all work same.
32
Variance is used to know how much a data vary from mean of data. Mathematically, variance is average of squared mean difference. Standard deviation is squire root of Variance.

VAR/VARS/VAR.S VARP/VAR.P
=(x-x)2/(n-1) =(x-x)2/n

Syntax of VAR.P

=VAR.P(number1,[number2],...)

Number1, number2,...: these are the numbers of which you want to calculate variance.
The first number is compulsory.
Notes: VAR.P ignores blank and non numeric values, including boolean values.
The first argument in is compulsory, rest are optional.
These numbers can be supplied as individual numbers, cell references, ranges or arrays to VAR.P function.
All below formulas are valid VAR.P formulas.

=STDEV.P(1,2,3,{5,99})
=STDEV.P(A1,A2,B3,C2:C5)

Example of VAR.P Function
We have this data of productivity of employees in an organisation. Assuming that this is the entire population, we need to calculate the variance of data.
33
To calculate the variance of entire population, use this VAR.P Formula.

=VAR.P(A2:A12)

This will return the variance in data, which 2.5. This VAR.P function reduces a lot of effort and saves time.
34
If we calculate the square root of this data, we will get the standard deviation, which will be about 1.6.

What is the Difference in VAR, VARS, VAR.S (all are same) and VARP or VAR.P.
The denominatore in VAR, VARS,VAR.S is n-1. Where n is the number of observations. Where VAR.P has denominator n.

VAR/VARS/VAR.S VARP/VAR.P
=(x-x)2/(n-1) =(x-x)2/n

VAR.S is used for sample data. VAR.P is used for entire population.

This was a quick article about the VAR.P function of excel. I hope this was helpful. If you have any doubts regarding this or any other excel function, feel free to ask. I am here to answer all the queries.

Related Data:
How to Use STDEV Function in Excel
Regressions Analysis in Excel
How To Calculate MODE
How To Calculate Mean
How to Create Standard Deviation Graph
Popular Articles
The VLOOKUP Function in Excel
COUNTIF in Excel 2016
How to Use SUMIF Function in Excel

Leave a Reply

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

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube