Calculates the standard deviation based on the entire population.
Diese Funktion funktioniert in Google Sheets genauso wie in Excel — gleiche Syntax und Argumente.
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.
=STDEV.P(10, 12, 23, 23, 16, 23, 21, 16)Ergebnis: 4.898979
Calculates the population standard deviation for the provided set of eight numbers.
STDEV.P is used for the entire population, while STDEV.S is used when calculating standard deviation based on a sample of the population.