VARP function

Category: Compatibility
Introduced: Excel 2003

Summary

Calculates variance based on the entire population

Syntax

VARP(number1,[number2],...) The VARP function syntax has the following arguments:
• Number1 Required. The first number argument corresponding to a population.
• Number2,... Optional. Number arguments 2 to 255 corresponding to a population.

Example

=VAR.P(A2:A11)
=VAR.S(A2:A11)

Microsoft Support Page

https://support.microsoft.com/en-us/office/var-p-function-73d1285c-108c-4843-ba5d-a51f90656f3a

Back to Functions