Excel VARP Function: Microsoft Excel is a powerful data visualization and analysis program used all around the world. It uses spreadsheets to store, organize, or perform operations with formulas and functions. If you want to find out the variance of the entire population of data, then you can use this VARP function.
In this post, we are going to explore how to use the Excel VARP 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 VARP Function
- It is one of the built-in functions in Microsoft Excel.
- This function is used to calculate the variance of the entire population.
- VARP Function ignores the text and logical values.
Syntax
- Here, you will see the syntax of the VARP 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.
=VARP(number1, [number2], …)
Parameters Description:
- Number 1 – It is the first input number or cell reference.
- Number 2 – 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 VARP Function will work.
- 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 of the entire population of data using the VARP 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 VARP Function in Excel.
- This function ignores Empty cells, Boolean values, and Text, any Non-numerical values.
Verdict
In this article, you can clearly learn the usage of the Excel VARP Function with its syntax, description, and examples. Leave your feedback in the 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 VARP function in the spreadsheet.
Also Read:
- 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.
