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.
