STDEV. P Function in Excel

This guide provides a practical overview of STDEV. P Function, including its main features, benefits, limitations, and important considerations.

Description: The function returns standard deviations based on the whole, ignoring logical values and text. Standard deviation is a measure of the dispersion of values against the mean. Support functions from Excel 2010 onwards.

Syntax: STDEV. P (number1, [number2]. )

Inside:

- number1, [number2]. : The values you want to calculate the standard deviation, where number1 is the required parameter, the remaining parameters are optional and contain up to 254 number parameters .

Attention:

- STDEV. P function assumes that its arguments are whole.

- For large sample sizes -> STDEV. S, STDEV. P returns the same value.

- Standard deviation calculated using the method 'n'.

- Arguments can be numbers, names or arrays that contain numbers.

- When typing logical values and presenting numeric values into function arguments -> these values are still calculated.

- Function error occurs when arguments are text or error values cannot be converted.

- If you want to calculate both logical values and text -> use STDEVPA function .

- Equation STDEV. P uses:

[sqrt {frac {{sum {{{left ({x - overline x} right)} ^ 2}}}} {n}}]

Inside:

+ x is the sample mean AVERAGE (number1, number2. )

+ n is the sample size.

For example:

Calculate the standard deviation based on the totality of the values in the following data table:

- In the cell to calculate, enter the formula : = STDEV. P (D6: D10)

- Press Enter -> standard deviation based on overall is:

- Where the values of the elements in the set are text or logical values -> they are ignored:

Above are instructions and some specific examples when using the STDEV. P function in Excel.

Good luck!