AVEDEV

Formulas / AVEDEV
Calculate the sum of the squared deviations of a data set.
=AVEDEV(number1, [number2], ...)
  • The AVEDEV function accepts 1-30 arguments
  • Each argument is a number

Examples

  • =AVEDEV(B5:B10)

    The AVEDEV function can be used to calculate the mean of the absolute values of deviations from the mean. For example, this formula will return the mean of the absolute values of deviations from the mean for the data in the range B5:B10.


Summary

The AVEDEV function is a useful tool for calculating the average absolute deviation of numbers in a data set. It takes numerical arguments, including numbers, names, arrays, and references, and ignores empty cells, text, and logical values.

  • The AVEDEV function takes multiple arguments which can be numbers, names, arrays, or references.
  • Average deviation measures of variability of a data set and has the same units as its values.
  • AVEDEV only works with absolute values of negative numbers.

Frequently Asked Questions

What is the AVEDEV function?
The AVEDEV function is a statistical function in Sourcetable that averages the absolute deviations of a set of data from the mean. This function is used to measure the variability of a data set.
What kind of arguments does the AVEDEV function take?
The AVEDEV function takes numerical arguments. These arguments can be numbers, names, arrays, or references.
Does the AVEDEV function accept logical values or text representations of numbers?
Yes, the AVEDEV function accepts numbers directly entered into the arguments, as well as logical values or text representations of numbers.
What data will the AVEDEV function ignore?
The AVEDEV function will ignore empty cells, text, and logical values from arrays or references.
Will the AVEDEV function include cells containing zero?
Yes, the AVEDEV function includes cells containing zero.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV