STDEV.P

Home

4D v19

STDEV.P


STDEV.P ( value {, value2 , ... , valueN} )

Parameter	Type	Description
value	Number, CellRef	Values to evaluate

Description

The STDEV.P function returns the standard deviation for an entire population of numeric values. Standard deviation is a measure of the dispersion of values in relation to the average (average value).

In value, value2..., pass numeric arguments corresponding to the population. Each argument can be a cell, a cell range, or a number. This function can have up to 255 arguments.

Note: If your data represents a sample of the population, then compute the standard deviation using the STDEV function.

The STDEV.P is calculated using the "biased" or "n" method. The STDEV.P function uses the following formula:

Example

STDEV.P(A1,B2,C3,D4,E5,F6)

STDEV.P(A1:A9)

STDEV.P(95,89,73,87,85,76,100,96,96) gives the result 8.8079649700473