SheetFX
≡
<< Go back to all functions

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.

Function Syntax and Parameters

Syntax: VAR.S(value1, [value2, ...])

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.

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