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

Function Name | Data Set | Text and logical Value |
---|---|---|

VAR | Sample | It will be Ignored |

VARP | Population | It will be Ignored |

VAR.S | Sample | It will be Ignored |

VAR.P | Population | It will be Ignored |

VARA | Sample | It will Evaluate |

VARPA | Population | It will Evaluate |

## 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**Enter**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.

**Read Ahead:**

- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?

Hi there, I’m **Sridhar** – an Excel enthusiast with over **10 years** of experience working with software. I’m passionate about using Excel to solve complex problems and streamline business processes. Over the years, I have helped businesses of all sizes to improve their **operations and save time and money**.

Aside from working with Excel, I also enjoy writing and sharing my knowledge with others. You’ll often find me contributing to the AAW Excel blog, where I provide tips, tricks, and tutorials that are easy to understand for readers of all skill levels.