Related Topics:

Spreadsheet Mathematical Functions

Function Wizard Functions

STDEVP

Description: Calculates standard deviation based on the entire population given as arguments. Non-numerical values are ignored. The standard deviation is a measure of how widely values are dispersed from the average value (the mean).

Syntax: STDEVP(Number1, Number2, ...)

Remarks:

where x is the sample mean AVERAGE(Number1, Number2, …) and n is the sample size.

Example:

Using the same data from the STDEV example and assuming that only 10 tools are produced during the production run, STDEVP measures the standard deviation of breaking strengths for all the tools.

 

© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.