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.