:STDEV.S function calculates sample standard deviation-Table skills免费ppt模版下载-道格办公

Picture and text skills
Case

Estimates the standard deviation based on the sample (ignoring logical values and text in the sample).

Standard deviation measures the spread of values around the mean (median).

Grammar

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

STDEV.S function syntax has the following parameters:

Number1 Required. Corresponds to the first numerical parameter of the population sample.

You can also use a single array or a reference to an array instead of comma-separated parameters.

Number2, ... Optional. 2 to 254 numerical parameters corresponding to the population sample.

You can also use a single array or a reference to an array instead of comma-separated parameters.

Description

STDEV.S assumes that its parameters are population samples. If the data are representative of the entire population, use STDEV.P to calculate the standard deviation.

The standard deviation is calculated here using the "n-1" method.

Parameters can be numbers or names, arrays, or references containing numbers.

Logical values and text representing numbers typed directly into the argument list are counted.

If the argument is an array or reference, only the numbers in it are evaluated. Blank cells, logical values, text, or error values in arrays or references are ignored.

If the parameter is an incorrect value or is text that cannot be converted to a number, an error will result.

If you want the calculation to include logical values in references and text representing numbers, use the STDEVA function.

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/STDEV-S-han-shu-ji-suan-yang-ben-biao-zhun-pian-cha.html