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.
Excel shows 2.138089935
A
1
2
2
4
3
4
4
4
5
5
6
5
7
7
8
9
Data
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.
| Formula | Excel shows | Case |
|---|---|---|
=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.
A
B
F
1
2
10
1
2
4
20
2
3
4
TRUE
3
4
4
4
5
5
abc
5
6
5
30
7
7
FALSE
8
9
40
Data
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 .