## Excel Function : VARPA

###### Category

Statistical

###### Description

Calculates variance based on the entire population, including numbers, text, and logical values

###### Microsoft Excel Reference Page

https://support.office.com/en-us/article/VARPA-function-59a62635-4e89-4fad-88ac-ce4dc0513b96

## Syntax and Description of the VARPA Excel Function

syntax Excel syntax VARPA VARPA is a statistical function that calculates the variance of a population based on the entire population. The population is a set of data that includes every possible value from a given distribution. VARPA is a statistical function that calculates the variance of a population based on the entire population.The population is a set of data that includes every possible value from a given distribution. VARPA syntax The VARPA function syntax has the following arguments: Array1 (required argument) – This is an array or reference to cells that contain numeric values for which we want to calculate the variance. Examples Example 1 To understand

## About VARPA Excel Function

The VARPA function calculates the variance of an array of data. The function takes two arguments: the array of data and the population parameter, which can be either TRUE or FALSE. If the population parameter is TRUE, the function calculates the variance of the entire population. If the population parameter is FALSE, the function calculates the variance of the sample.