MS Excel: StDev Function

In Excel, the StDev function returns the standard deviation of a population based on a sample of numbers.

The syntax for the StDev function is:

StDev( number1, number2, ... number_n )

number1, number2, ... number_n are numeric values - they can be numbers, named ranges, arrays, or references to numbers. There can be up to 30 values entered.

Applies To:

Excel 2007, Excel 2003, Excel XP, Excel 2000

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=StDev(B2, B3) would return 2.333452378

=StDev(B3, B5, 45) would return 22.36157418

=StDev(B2:B6) would return 85.9740833