STDEVP

Formulas / STDEVP
Calculate the standard deviation for a population.
STDEV.P(number1,[number2],...)
  • number1 - The first number or range of the population for which you want to calculate the standard deviation. This argument is required.
  • [number2, ...] - [OPTIONAL] Additional numbers or ranges of the population for which you want to calculate the standard deviation. These arguments are optional, and you can specify up to 254 additional numbers or ranges.

Examples

  • =STDEVP(B3:B7)

    This returns the standard deviation of the breaking strength assuming that only 5 tools were produced.

  • =STDEVP(A1:A9,C1:C9)

    This returns the standard deviation of the breaking strength and the weight assuming that only 9 tools were produced.

  • =STDEVP(D3:D20,F3:F20)

    This returns the standard deviation of the breaking strength and the weight assuming that only 18 tools were produced.

  • =STDEVP(G1:G100,H1:H100)

    This returns the standard deviation of the breaking strength and the weight assuming that only 100 tools were produced.

Summary

The STDEVP function calculates the standard deviation for data in a population, providing a measure of how spread out the data is in relation to the mean.

  • The STDEVP function is used to calculate the standard deviation of a data set and is the same as the STDEV.P function.


Frequently Asked Questions

What is the STDEVP function?
The STDEVP function calculates the standard deviation of a population. The standard deviation is a measure of how widely values are dispersed from the average value and is measured using the "n" method.
What kind of arguments can the STDEVP function take?
The STDEVP function can take numerical, name, array, and reference arguments.
Is the STDEVP function the same as the STDEV.P function?
No, the STDEVP function is older than the STDEV.P function.
Sourcetable Logo

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code.

Drop CSV