Calculates the standard deviation based on the entire population.
Cette fonction fonctionne de la même façon dans Google Sheets que dans Excel — même syntaxe et mêmes arguments.
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)Résultat : 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.