Excel STDEV Function

Use:

Computes standard deviation of a set of sample data

Syntax:

STDEV( range )

Examples:

Cell D12 formula: STDEV( C4:G4 )

Cell D13 formula: STDEV( D3:D9 )
Cell D14 formula: STDEV( C3:G9 )
Cell D15 formula: STDEV( D3:D9,G3:G9 )

Note:

STDEV uses a denominator of N-1 instead of N

STDEV( range ) is equivalent to SQRT( VAR( range ) )

Related Functions:

STDEVP, VAR, VARP, AVEDEV