loading

STDEV.P

Excel STDEV.P Function

A pre-made Excel function called STDEV.P determines the Standard Deviation (Std) for the whole population.

The type is =STDEV.P.

Note: Cells containing logic and text are ignored by this function.

Note: The standard deviation (σ) expresses the distance between a “typical” observation and the data average (μ). Visit our Statistics – Standard Deviation Tutorial to learn more about standard deviation.

A tip: If you have the data for a sample, you can use another function called STDEV.S.

How to use the =STDEV.P function:

  1. Select a cell (H5)
  2. Type =STDEV.P
  3. Double click the STDEV.P command
  4. Select a range (E2:E755), including all Pokemons
  5. Hit enter

Let’s have a look at an example!

Find the Standard Deviation of Pokemon total stats in the range E2:E755:

Stdev.p -

Not every row is visible in the image. E2:E755 is the range (753 rows).

Stdev.p -
Stdev.p -
Stdev.p -

With success, the STDEV.P function returned 113,4497844 as the population’s standard deviation.

Share this Doc

STDEV.P

Or copy link

Explore Topic