STDEV.S function - The function returns the standard deviation based on a sample in Excel

The following article introduces you to the STDEV.S function - one of the functions in the statistical function group is very popular in Excel.

STDEV.S function - The function returns the standard deviation based on a sample in Excel Picture 1

Description: The function returns standard deviations based on a sample, ignoring logical values ​​and text. Standard deviation is a measure of the dispersion of values ​​against the mean. Support functions from Excel 2010 onwards.

Syntax: STDEV.S (number1, [number2], .)

Inside:

- number1, [number2], . : The values ​​you want to calculate the standard deviation, where number1 is the required parameter, the remaining parameters are optional and contain up to 254 number parameters .

Attention:

- The STDEV.S function assumes that its arguments are a global sample.

- Standard deviation calculated using the method 'n -1'.

- Arguments can be numbers, names or arrays that contain numbers.

- When typing logical values ​​and presenting numeric values ​​into function arguments -> these values ​​are still calculated.

- Function error occurs when arguments are text or error values ​​cannot be converted.

- If you want to calculate both logical values ​​and text -> use STDEVPA function .

- STDEV.S equation uses the formula:

[sqrt {frac {{sum {{{left ({x - overline x} right)} ^ 2}}}} {{left ({n - 1} right)}}}]

Inside:

+ x is the sample mean AVERAGE (number1, number2, .)

+ n is the sample size.

For example:

Calculate the standard deviation based on a sample of the values ​​in the following data table:

STDEV.S function - The function returns the standard deviation based on a sample in Excel Picture 2

- In the cell to calculate enter the formula : = STDEV.S (D6: D10)

STDEV.S function - The function returns the standard deviation based on a sample in Excel Picture 3

- Press Enter -> standard deviation based on a sample of the above values ​​is:

STDEV.S function - The function returns the standard deviation based on a sample in Excel Picture 4

- Where the values ​​of the elements in the set are text or logical values ​​-> they are ignored:

STDEV.S function - The function returns the standard deviation based on a sample in Excel Picture 5

Above are instructions and some specific examples when using the STDEV.S function in Excel.

Good luck!