The VAR.S function returns the variance based on a sample – ignores logical values and text in the sample.

- This function was introduced in Excel 2010 and so is not available in earlier versions.
- The VAR.S function replaces the VAR function included in earlier versions of Excel.

### Syntax

=VAR.S(num_1,[num_2], … )

#### Arguments

Argument | Description |
---|---|

num_1 | The first number, cell references or range argument corresponding to a population |

[num_2], … | Optional. Additional numbers, cell references or ranges for which you want the variance, up to a maximum of 255 |

#### Examples

A | B | C | D | |
---|---|---|---|---|

1 | Data | |||

2 | 1,471 | |||

3 | 1,474 | |||

4 | 1,491 | |||

5 | 1,452 | |||

6 | 1,436 | |||

7 | 1,445 | |||

8 | 1,442 | |||

9 | 1,427 | |||

10 | 1,432 | |||

11 | 1,407 | |||

12 | ||||

13 | Formula | Result | Notes | |

14 | =VAR.S(A2:A11) | 626.23 | Variance of values provided using the VAR.S function, which assumes that 10 is only a sample population | |

15 | =VAR.P(A2:A11) | 563.61 | Variance of values provided, assuming that 10 is the entire population. The result is different from VAR.S |

Note: The VAR.S function is used when calculating the variance for a

sampleof a population. If you are calculating the variance for anentirepopulation, you need to use the VAR.P function.

#### Common Function Error(s)

Problem | What went wrong |
---|---|

#VALUE! | Occurs if any values that are supplied directly to the function are text values that cannot be interpreted as numeric values |

#DIV/0! | Occurs if less than 2 numeric values have been supplied to the function |

Variance is a statistical measure commonly used across a set of values, to identify the amount that the values vary from the average.

When your data set is a sample of a population, rather than an entire population, you should use a slightly modified form of variance, known as the Sample Variance.

The equation for VAR.S is:

where x is the sample mean of the set of values and n is the sample size.

See Wikipedia for more information on variance.