VAR.S

The VAR.S function in Google Sheets is a statistical function used to calculate the variance based on a sample data set. It measures the dispersion or spread of data points from the average. Learn how to use this function effectively with our comprehensive guide.

Parameters

• value1: The first value or range containing the sample data.
• value2, ...: [Optional] Additional values or ranges containing the sample data.

Step-by-Step Tutorial

1. Using VAR.S with individual numbers:

   • Example: =VAR.S(5, 8, 10, 12, 15)
   • Result: The variance will be calculated based on the provided data points.

2. Using VAR.S with a range of cells:

   • Example: If cells A1:A5 contain the data 5, 8, 10, 12, 15, then =VAR.S(A1:A5) will calculate the variance.

Working with a Single Value, a List, and a Range

VAR.S accepts numbers one at a time, as a comma-separated list, or as a range — mix and match freely, as long as at least two numeric values are supplied.

• Single value: =VAR.S(A1) — not meaningful on its own; VAR.S needs at least two data points and returns a #DIV/0! error with just one.
• List of values: =VAR.S(A1, A2, A3) — treats each cell as one data point in the sample.
• Range: =VAR.S(A1:A10) — treats every cell in the range as part of the sample.
• Mixed: =VAR.S(A1, A3:A6, 10) — combine single cells, ranges, and literal numbers into one sample.

Use Cases and Scenarios

1. Financial Analysis: Measure the volatility of stock prices.
2. Quality Control: Assess the variability in product dimensions.
3. Educational Research: Analyze the spread of test scores.

Related Functions

• VAR.P: Calculate the variance based on the entire population.

Related Articles

• Understanding Statistical Functions in Google Sheets
• Data Cleaning, Sorting, and Analysis Tips in Google Sheets