How to use VARP function in Excel?

The `VARP` function in Excel is used to calculate the variance of an entire population of data. If you’re dealing with a sample of a population, instead of the entire population, you would use the `VAR` function (or `VAR.S` in Excel 2010 and later).

Here’s how you can use the `VARP` function:

Syntax

VARP(number1, [number2], ...)
  • number1: This is the first number or cell reference that you want to calculate the variance for.
  • [number2], …: Additional numbers or cell references for which you want to calculate the variance. You can include up to 254 numbers or cell references in total.

Steps to Use VARP

  • Select the Cell: Click on the cell where you want the result of the variance to appear.
  • Enter the Function:
    • You can start with an equal sign `=`, then type `VARP(`.
    • Input your data either by typing numbers directly separated by commas or by selecting cell ranges. For example, `VARP(A1:A10)` calculates the variance for the numbers in cells A1 through A10.
  • Close the Parenthesis: After entering your data or selecting your cell ranges, close the parenthesis `)` to complete the function.
  • Press Enter: Hit the Enter key to compute the variance of your data.

Example

Suppose you have a data set in cells B2 through B6, and you want to calculate the variance for this entire population:

=VARP(B2:B6)

Important Notes

  • Populated Data: The `VARP` function is intended for use when you have data that represents an entire population. If you’re working with a sample from the population, `VAR.S` (or `VAR` in older Excel versions) is more appropriate.
  • Excel Versions: The `VARP` function is available in all versions of Excel, but starting in Excel 2010, you might prefer to use `VAR.P` as it follows the newer naming convention, although `VARP` still works for backward compatibility.

Using this function appropriately will help you perform statistical analysis on your entire data set, providing insights into the dispersion or variability within your population.

Unlock Your Potential

Excel

Basic - Advanced

Access

Access Basic - Advanced

Power BI

Power BI Basic - Advanced

Help us grow the project