< Go Back

Excel STDEVA Function

Excel STDEVA Function

Excel STDEVA function estimates standard deviation based on the sample including logical and text values. It gives an estimate how much sample values differ or widely disperse from an average of sample values.

Formula

=STDEVA (value1, [value2], ...)

Excel STDEVA function syntax has the following arguments:

value1 (required) – It is first value of sample

[value2], … (optional) – These are additional values of the sample

Explanation

Excel STDEVA function estimates the standard deviation of the sample data set including logical and text values. Logical value FALSE and text value are evaluated as 0 and logical value TRUE is evaluated as 1 in cell references of sample data.

You can add total 255 arguments in Excel STDEVA function as numbers, named ranges, arrays or cell references. These arguments can have numbers, logical values, and text values, all of these values are evaluated in standard deviation calculation of sample. Empty cells found in cell references of sample data set are ignored.

Cell references containing text representations of numbers are considered as text values, therefore evaluated as 0. But, text representations of numbers entered directly as an argument in Excel STDEVA function are evaluated as numbers.

Example

Suppose you have the sample of values derived from entire population data and you want to estimate the standard deviation of sample values by evaluating logical and text values also. The formula using Excel STDEVA function is:

=STDEVA(A2:A11)

Figure 1. STDEVA_Function

Notes

Following points must be taken into consideration before using Excel STDEVA function:

  • Arguments containing data must represent the sample of a population. If data set represents entire population then Excel STDEVPA must be used.
  • It evaluates text and logical values found in cell references of the sample. If you don’t want to evaluate these values then use Excel STDEV.S or STDEV function.
  • It calculates standard deviation using “n-1” method.
  • Text values in cell references are evaluated as number as 0. However, logical values entered either in cell references or directly as arguments in function are evaluated as numbers.
  • Text representations of numbers in cell references are evaluated as text values as 0, but these values entered directly as an argument in function are evaluated as numbers.
  • It generates error value #VALUE! if any text value is supplied directly as an argument.

 

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California
This blog is one way to figure it out. A 20 minute chat session with an expert is a better way.Get step-by-step guidance on your question

Leave a Comment

avatar