Calculates the standard deviation based on the entire population.
Deze functie werkt in Google Spreadsheets hetzelfde als in Excel — dezelfde syntaxis en argumenten.
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)Resultaat: 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.