Calculates the standard deviation based on the entire population.
構文
STDEV.P(number1, [number2], …)引数
number1必須
The first number or range of cells corresponding to a population.
number2省略可能
Additional numbers or ranges up to 254 arguments.
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.898979Calculates the population standard deviation for the provided set of eight numbers.
Select a cell
Click on the cell where you want the result to appear.
Enter the formula
Type =STDEV.P( followed by your data range or numbers, then close the parenthesis.
STDEV.P is used for the entire population, while STDEV.S is used when calculating standard deviation based on a sample of the population.