Excel FunctionsLesson 107Free preview

STDEV.P

This lesson is part of Excel · All levels

Summary

STDEV.P is an Excel statistical function that calculates standard deviation for the entire population of data. The syntax is STDEV.P(number1, [number2],...). Use this function when the data you're analyzing is the entire population, not a sample.

Key points

STDEV.P is used for data of entire populations
Divide by n (number of data)
Replacing the old STDEVP function in Excel 2010 and above
STDEV.S is used if the data is just a sample

Full lesson

Code examples and quizzes

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