VAR.S Function in Excel

VAR.S function in Excel calculates the sample variance of supplied set of values.

Sample variance is calculated using formula
VAR.S function in Excel 1

Where,

  • X takes each value in the set;
  • X̄ is the average of the set of values;
  • N is the number of values.

 

Syntax of VAR.S Function in Excel:

VAR.S (number1, [number2], … )

Where the number arguments are numeric values for which you want to calculate the sample variance.

 

Example of VAR.S Function in Excel

VAR.S function in Excel 2

The Above example calculates the sample variance of subject scores with formula

= VAR.S (A2:A13)

Which results in value 178.6969697

previous-small VAR.S Function in Excel                                                                                                                next_small VAR.S Function in Excel