Google Sheets-funktion

STDEV.P

Calculates the standard deviation based on the entire population.

Skapa en formel med AI Samma funktion i Excel

Den här funktionen fungerar likadant i Google Kalkylark som i Excel — samma syntax och argument.

Syntax

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

The STDEV.P function measures how widely values are dispersed from the average (mean) value of the entire population. It assumes that your data represents the complete set of items being studied, rather than a sample.

Argument

number1obligatorisktThe first number or range of cells corresponding to a population.
number2valfrittAdditional numbers or ranges up to 254 arguments.

Exempel

=STDEV.P(10, 12, 23, 23, 16, 23, 21, 16)

Resultat: 4.898979

Calculates the population standard deviation for the provided set of eight numbers.

Vanliga frågor

What is the difference between STDEV.P and STDEV.S?

STDEV.P is used for the entire population, while STDEV.S is used when calculating standard deviation based on a sample of the population.

Relaterade funktioner

AVERAGE