VAR.P function

Category: Statistical
Introduced: Excel 2010

Summary

Calculates variance based on the entire population

Syntax

VAR.P(number1,[number2],...) The VAR.P function syntax has the following arguments:
• Number1 Required. The first number argument corresponding to a population.
• Number2, ... Optional. Number arguments 2 to 254 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