# How to Use Excel VAR.P Function?

Excel is a powerful data visualization and manipulation software. It is popular all over the world. It provides numerous formulas and functions for performing mathematical operations. If you want to calculate the variance based on the entire population, you can use the VAR.P function in Excel. It is one of the built-in functions in Excel.

In this article, we will learn how to use Excel VAR.P Function with its syntax, description, and examples. Get an official version of MS Excel from the following link:

https://www.microsoft.com/en-in/microsoft-365/excel

## Description of VAR.P Function

• It is one of the built-in functions in Microsoft Excel.
• This function is used to calculate variance based on the entire population.
• It can be manually calculated by using the below-given formula.

## Syntax

• Here, you will see the syntax of the VAR.P function.
• To apply this function on your spreadsheet, you have to select a cell and enter the formula in the following format.
• Once you enter the formula, just click on the button to get the result.

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

Parameters Description

• Number1 – It is the first input number or cell reference.
• Number2 – It is an optional one. It can be a number or cell reference.

Note:
1) The arguments can be Numbers, Names, Arrays, or References.
2) This function ignores Empty cells, Boolean values, and Text, any Non-numerical values.

The following table explains that the list of functions will consider the text and logical value, but will not consider the text and logical values.

## Examples

Let’s see some examples to understand how the VAR.P function will work in the worksheet.

• Initially, you have to open your Excel workbook on your PC and launch a worksheet that has data.
• For example, we have given a range of input values in B2:B10 and we will get the variance based on the entire population using the VAR.P function.
• Then, we have to apply the above-mentioned formula to get the result, as shown in the following screenshot.
• Finally, we need to click on the button to get the result.

The following mathematical calculation explains the working of the VAR.P Function in Excel.

## Input Boolean Values

• This function ignores Empty cells, Boolean values, and Text, any Non-numerical values.

## Summary

In the above article, you can understand the usage of Excel VAR.P Function with its syntax, description, and examples. Drop your feedback in the below comment section. To learn more about Excel functions, then visit our webpage Aawexcel.com.

## Video Tutorial

The following video will show you how to apply the Excel VAR.P function in the worksheet.