Calculates the standard deviation based on a sample of a population.
構文
STDEV.S(number1, [number2], ...)引数
number1必須
The first numeric argument corresponding to a sample of a population.
number2省略可能
Additional numeric arguments, up to 254, corresponding to a sample of a population.
STDEV.S estimates standard deviation based on a sample of data. It ignores logical values and text contained in references, focusing only on numeric data points.
=STDEV.S(10, 12, 23, 23, 16, 23, 21, 16)→5.23Calculates the sample standard deviation for the provided set of eight numbers.
Select a cell
Click on the cell where you want the standard deviation result to appear.
Enter the formula
Type =STDEV.S( followed by your range of numbers or individual values, then close the parenthesis.
STDEV.S is used when your data is a sample of the population, while STDEV.P is used when your data represents the entire population.