MS Excel: StDevP Function

In Excel, the StDevP function returns the standard deviation of a population based on an entire population of numbers.

The syntax for the StDevP function is:

StDevP( number1, number2, ... number_n )

number1, number2, ... number_n are the population numbers. There can be up to 30 numbers entered.

Applies To:

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=StDevP(C2, C3, C4, C5) would return 1.647224939

=StDevP(D2, D3, D4) would return 7.345

=StDevP(34.5, 2, 8.9, -4) would return 14.67114515