The STDEV.S (STDEV S) is a Statistical function that calculates and returns the standard deviation for a sample of data. The standard deviation is a measure of how widely values are dispersed from the average value (the mean). The STDEV.S calculates standard deviation using the “n-1” method. In this guide, we’re going to show you how to use the STDEV.S function and also go over some tips and error handling methods.


Supported versions

  • Excel 2010 and later

Syntax

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


Arguments

number1 The first number or reference in the sample of the population. You can also use an array instead of multiple arguments.
[number2], … Other numbers of the population up to 254 arguments.

Example

The standard deviation is a measure of how widely values are dispersed from the average value (the mean). The STDEV.S function assumes that given arguments are a sample of the population. The function uses the following formula:

where x is the average (mean) and n is the sample size.

All you need to do is to supply your dataset as arguments.

=STDEV.S(B5:B13)

Excel STDEV.S Function

Download Workbook


Tips

  • Use STDEV.S to calculate the standard deviation for a sample of the population.
  • The function calculates the standard deviation by using the “n-1” method.
  • The STDEV.P function uses “n” method to calculate the standard deviation.
  • You can use the AVERAGE function to calculate the mean of a data set.
  • The STDEV is the older version of this function. Refrain from using STDEV.
  • Arguments can either be numbers or names, arrays, or references that contain numbers.
  • Logical values, and text representations of numbers that you type directly into the list of arguments are counted.
  • If an argument is an array or reference, only numbers in that array or reference are counted. Empty cells, logical values, text, or error values in the array or reference are ignored.
  • Arguments that are error values or text that cannot be translated into numbers cause errors.

If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the STDEVA function.