VARPA function

Category: Statistical
Introduced: Excel 2003

Summary

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

Syntax

VARPA(value1, [value2], ...) The VARPA function syntax has the following arguments:
• Value1, value2, ... Value1 is required, subsequent values are optional. 1 to 255 value arguments corresponding to a population.

Example

=VARPA(A2:A11)
=VAR(A2:A11)

Microsoft Support Page

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

Back to Functions