Need advanced Excel, VBA or SQL support? Outsource your project now!
Connect to our Experts within seconds for a free diagnosis
Our professional experts are available now. Your privacy is guaranteed.

Excel VAR.S Function

Figure 1. Excel VAR.S Function.

Let’s say we have a data set – which represents a whole population – and we want to determine its variance, we must use the Excel VAR.S Function.

Generic Formula

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

  • number 1 is the first reference or number.
  • number 2 is the second reference or number (optional).

Our sample data variance can be determined by the VAR.S Function.

How to use the Excel VAR.S Function.

Variance can provide us with an idea of the data spread across the entire population.

We are now going to make use of the Excel VAR.S Function to determine the variance of our data sample.

  1. Arrange the data set in a column in our worksheet.

Figure 2. Excel VAR.S Function.

Notice how we provided an empty cell for Excel to return the variance value.

  1. In our worksheet example, the VAR.S formula to be entered into cell C5 is as follows;


Figure 3. Excel VAR.S Function.

The calculated variance of the individual weight of the sample group, as shown in cell C5, is 667.6.


The Excel VAR.S function can accept up to 254 arguments/numbers.

Figure 4. Final Result.

Instant Connection to an Expert through our Excelchat Service:

Our live Excelchat Service is here for you. We have Excel Experts available 24/7 to answer any Excel questions you may have. Guaranteed connection within 30 seconds and a customized solution for you within 20 minutes.

Leave a Comment


Subscribe to

Get updates on helpful Excel topics

Subscribe to
Trusted by people who work at, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc