Calculates the standard deviation based on the entire population.
This function works the same in Google Sheets as it does in Excel — same syntax and 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)Result: 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.