Calculates the standard deviation based on the entire population.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
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)결과: 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.