HomeApplicationOffice information

AVEDEV function

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

AVEDEV function Picture 1

Description: The function returns the average absolute deviation of the data points from their midpoint. The AVEDEV function allows you to measure the variability of a dataset.

Syntax: AVEDEV (number1, [number2], .)

Inside:

- number1, number2 . are the values ​​you want to calculate the average absolute deviation, where number1 is the required parameter, the remaining number values are optional. The function contains up to 255 number values .

Attention:

- AVEDEV function is affected by the measurement unit of input data.

- The values ​​of the arguments must be either numbers or names or references that contain numeric values.

- When typing logical values ​​directly and displaying text numbers in functions, these values ​​will be calculated.

- Parameter values ​​or arrays that are logical values, text or blank cells are ignored.

- The function performs the calculation according to the equation of average deviation:

[frac {1} {n} sum {left | {x - overline x} right |}]

For example:

Calculate the average of the absolute deviation of values ​​in the following data table:

AVEDEV function Picture 2

- Where the number values ​​are located in nonadjacent locations -> enter the number values in the function separated by commas -> enter the formula: = AVEDEV (C6, C7, C8, C9, C10)

AVEDEV function Picture 3

- Where the number values ​​are located adjacent to each other -> enter the formula: = AVEDEV (C6: C10)

AVEDEV function Picture 4

- Press Enter -> average absolute deviation of number values in the data table is:

AVEDEV function Picture 5

- Where the number values are blank cells or text -> the function ignores those values:

AVEDEV function Picture 6

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

Good luck!

4 ★ | 1 Vote

You should read it

May be interested

  • AVG function in SQL ServerAVG function in SQL Server
    the avg function in sql server returns the average value of an expression or average value according to the specified column of the selected row.
  • Hex () function in PythonHex () function in Python
    the hex () function is one of python's built-in functions, used to convert an integer into the corresponding hexadecimal form.
  • ABS function in SQL ServerABS function in SQL Server
    this article will show you in detail how to use the abs () handling function in sql server with specific syntax and examples to better visualize and capture functions.
  • The function id () in PythonThe function id () in Python
    the built-in function id () in python returns a single integer value that identifies an object.
  • DATEPART function in SQL ServerDATEPART function in SQL Server
    the datepart function in sql server returns a time value of the input argument, which can be day, month, year, quarter, hour, minute, second, millisecond ... the return value is an integer type (int)
  • How to use the SUM function to calculate totals in ExcelHow to use the SUM function to calculate totals in Excel
    sum is a popular and very useful excel function, and is also a basic arithmetic function. as its name suggests, the sum function is used to calculate totals in excel. and the parameters can be single parameters or ranges of cells. in this article, tipsmake.com will guide you to use the sum function to calculate the sum in excel, the common errors when calculating sum by sum and how to fix it.
  • LEN function in SQL ServerLEN function in SQL Server
    the len function in sql server returns the length of the specified string. it is important that the len function does not include whitespace characters at the end of the string when calculating length.
  • ROUND function in SQL ServerROUND function in SQL Server
    the article will give you detailed instructions on how to use the sql server round () function with the syntax and specific examples to make it easier to visualize and capture the function better.
  • Max () function in PythonMax () function in Python
    python's built-in max () function returns the largest element in an iterable or the largest of the passed parameters
  • The function dir () in PythonThe function dir () in Python
    the dir () function in python returns a list of valid properties of the object. quantrimang will learn more about this function content through the article. invites you to read the track.

Office information