Practice free

STDEV.S function

STDEV.S returns the sample standard deviation, the default choice for measuring spread when your data is a sample of a larger group. It divides by n-1 and ignores text and logicals in ranges.

Example

Read it as a sentence: estimate the standard deviation of the sample in A1:A8, which gives 2.138089935.

Practice this in the app

Syntax

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

Arguments in [square brackets] are optional.

number1 (required)
First number or range.
number2 (optional)
More numbers or ranges.

Returns: The sample standard deviation.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=STDEV.S({2,4,4,4,5,5,7,9}) 2.138089935 Array constant
=STDEV.S(10,"20",TRUE) 9.504384953 Direct args: number, text-number, TRUE
=STDEV.S({1,"2",TRUE,3}) 1.414213562 Array with text and boolean
=STDEV.S(Data!A1:A8) 2.138089935 Range of numbers
=STDEV.S(Data!B1:B8) 15.27525232 Mixed range: num, text-number, TRUE, blank, text, FALSE
=STDEV.S(Data!A1:A4,Data!F1:F5) 1.301708279 Two ranges
=STDEV.S(10,"abc") #VALUE! Direct arg: non-numeric text
=STDEV.S(5) #DIV/0! Single number

The Data sheet these formulas read

A cell that starts with = holds that formula.

Watch out for

  • Needs at least two numbers or you get #DIV/0!.
  • Ignores text and logicals in ranges.

Where it works

Excel
STDEV.S arrived in Excel 2010. Older versions do not have it.
Google Sheets
Same name, but behaves differently: `STDEV`. Sheets has STDEV and STDEV.S.

Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .