STDEVA function - The function of estimating standard deviations based on a sample including both text and logical values ​​in Excel

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

STDEVA function - The function of estimating standard deviations based on a sample including both text and logical values ​​in Excel Picture 1

Description: The function of estimating standard deviations based on a sample includes both text and logical values. Standard deviation is a measure of the dispersion of a value against the mean.

Syntax: STDEVA (value1, [value2], .)

Inside:

- value1, [value2], .: are the values ​​you want to calculate the standard deviation, where value1 is the required parameter, the remaining parameters are optional and contain up to 254 value parameters .

Attention:

- The STDEV.S function assumes that its arguments are a sample of the set.

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

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

- The logical value with True is 1 default, false value is 0 default.

- If the argument is an array or a reference, only values ​​in that array are used.

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

- If you do not want to calculate both logical values ​​and text -> use the STDEV function .

- STDEVA 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:

STDEVA function - The function of estimating standard deviations based on a sample including both text and logical values ​​in Excel Picture 2

- In the cell to calculate enter the formula : = STDEVA (D6: D12)

STDEVA function - The function of estimating standard deviations based on a sample including both text and logical values ​​in Excel Picture 3

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

STDEVA function - The function of estimating standard deviations based on a sample including both text and logical values ​​in Excel Picture 4

Here the logical value is still calculated with its corresponding value.

- Where all values ​​are logical or text values ​​-> function returns results:

STDEVA function - The function of estimating standard deviations based on a sample including both text and logical values ​​in Excel Picture 5

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

Good luck!