STDEVA Function - Estimating Standard Deviation Based on Sample Including Both Text and Logical Values in Excel

This article introduces you to the STDEVA function - one of the statistical functions highly favored in Excel.

Description: The STDEVA function estimates the standard deviation based on a sample that includes both text and logical values. Standard deviation is a measure of the dispersion of values around the mean.

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

Where:

- value1, [value2], ...: Are the values you want to calculate the standard deviation for. Value1 is a required parameter, while the rest are optional and can contain up to 254 values.

Note:

- The STDEV.S function assumes its arguments represent a sample from the population.

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

The argument can be a number, a name, or an array containing numbers.

Logical value True defaults to 1, and False defaults to 0.

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

Errors occur when the arguments are text or non-convertible error values.

To exclude logical and text values from calculations, use the STDEV function.

The STDEVA equation employs the formula:

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

In which:

+ x represents the sample mean AVERAGE(number1,number2,…)

+ n denotes the sample size.

For example:

Calculate the standard deviation based on the sample of values in the data table below:

- Enter the formula: =STDEVA(D6:D12) into the cell where calculation is required.

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

Here, logical values are still computed with their corresponding values.

- If all values are logical or text -> the function returns the result:

Above is the instruction and some specific examples when using the STDEVA function in Excel.

Wishing you all success!