Excel FunctionsLesson 108Free preview

STDEV.S

This lesson is part of Excel · All levels

Summary

STDEV.S is an Excel statistical function that calculates the standard deviation based on a sample of data. The syntax is STDEV.S(number1, [number2],...). This function divides by n-1, so it's a better estimate for the sample population.

Key points

STDEV.S is used when the data is a sample of a larger population
The division is done by n-1 (Bessel correction)
Replace the old STDEV function in Excel 2010 and above
The result is slightly larger than STDEV.P for similar data

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.