ExcelFlux

STDEV function

Estimates standard deviation based on a sample.

Compatibility

Where can you use it?

Teams maintaining legacy workbooks. Compare the example inputs and expected results with the formula in your workbook when checking a calculation made in an older version.

Scenario in the workbook

Check sample standard deviation in an older workbook. STDEV.S is its modern counterpart.

A worked example from the workbook

RowABC
6Period 1Period 2Period 3
7246
8333
9036
Record 1
=STDEV(A7:C7)

Expected result2

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=STDEV(A7:C7)
Turkish Excel · tr-TR
=STDSAPMA(A7:C7)

Compatibility function for older workbooks.

Worked examples

Check sample standard deviation in an older workbook. STDEV.S is its modern counterpart.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B C
6 Period 1 Period 2 Period 3
7 2 4 6
8 3 3 3
9 0 3 6
Case Formula Expected result
Record 1 =STDEV(A7:C7) 2
Record 2 =STDEV(A8:C8) 0
Record 3 =STDEV(A9:C9) 3
Microsoft Excel reference