Excel STDEV.P Function

Excel STDEV.P Function

Summary 

The Excel STDEV.P function calculates the standard deviation for a sample set of data. STDEV.P calculates standard deviation using the “n” method, ignoring logical values and text.

Purpose 

Get standard deviation of population

Return value 

Estimated standard deviation

Syntax 

=STDEV.P (number1, [number2], …)

Arguments 

  • number1 – First number or reference in the sample.
  • number2 – [optional] Second number or reference.

Usage notes 

The STDEV.P function calculates the standard deviation in a sample set of data.

Standard deviation is a measure of how much variance there is in a set of numbers compared to the average (mean) of the numbers.

Note: STDEV.P replaces the STDEVP function, with identical behavior. Although STDEVP still exists for backwards compatibility, Microsoft recommends that people use the newer STDEV.P function instead.

Notes:

  • STDEV.P calculates standard deviation using the “n” method, ignoring logical values and text.
  • STDEV.P assumes your data is the entire population. When your data is a sample set only, calculate standard deviation using the STDEV.S function.
  • Numbers are supplied as arguments. They can be supplied as actual numbers, ranges, arrays, or references that contain numbers.
  • The STDEV.P function ignores logical values and text. If  you want to include logical values and/or numbers as text in a reference, use the STDEVA function.

0 votes. 0 / 5

Excel - Excel Functions - Excel Formulas
Logo