VAR.S function

Category: Statistical
Introduced: Excel 2010

Summary

Estimates variance based on a sample

Syntax

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

Example

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

Microsoft Support Page

https://support.microsoft.com/en-us/office/var-s-function-913633de-136b-449d-813e-65a00b2b990b

Back to Functions