Excel Functions

Excel STDEVA Function

Pinterest LinkedIn Tumblr

The STDEVA function calculates standard deviation for a sample of data. Unlike the STDEV function, STDEVA will evaluate text and logicals that appear in references.

Purpose of Excel STDEVA Function

To calculate standard deviation for an entire population, use STDEVPA or STDEV.P.

Return value

The sample standard deviation of a supplied set of values.


=STDEVA (number1, [number2], …)


number1First number or reference in the sample.Mandatory
number2Second number or reference. Optional

Usage notes

  • Use STDEVA when you need to evaluate logicals or text in the standard deviation calculation.
  • STDEVA calculates standard deviation using the “n-1” method.
  • STDEVA calculates standard deviation using the “n-1” method.
  • Values are supplied as arguments.
  • They can be supplied as actual numbers, ranges, arrays, or references that contain numbers.
  • STDEVA evaluates logical values and/or numbers in supplied references.
  • To ignore these values use STDEV or STDEV.S .


Since 2007 for Windows.
Since 2011 for Mac.

Related Posts

Write A Comment