Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelAVEDEV Function in Excel

# AVEDEV Function in Excel

Â In this post, youâ€™ll learn about AVEDEV function and the term that refers AVEDEV function in excel, its syntax and how to use AVEDEV function in excel spreadsheet.

## What is an AVEDEV Function in Excel?

An AVEDEV function is a function which calculates and returns the average of absolute deviations with the numbers provided from the mean in a given data. AVEDEV function handles negative value by working only with absolute values.

This method is an easy way to show the variability in a data set. AVEDEV function is a built-in function which is termed as statistical function in excel. AVEDEV Function is a Worksheet function (WS) in excel.

#### Notes:

• Arguments (values) must be numbers, named ranges, zeros, arrays or reference (which contains numbers) is valid. you can enter up to 30 values.
• Ignores empty cells , text, string, error, and logical values.
• AVEDEV returns always a numeric value.
• AVEDEV function applies to;
• Excel for office 365, excel 2019, excel 2016, excel 2013, excel for 2011 for mac, excel 2010, excel 2007, excel 2003, excel XP, excel 2000.
##### SYNTAX:
`=AVEDEV (number 1, [number 2], â€¦ [number_n]Â Â Â Â Â Â Â Â Â Â  Â `

#### Parameters:

=>> AVEDEV () â€“ it is a functionâ€™s name.Â Â  Â Â

=> (number 1), [number 2],â€¦ [number_n] â€“ is the number of values.

## How to use AVEDEV Function in Microsoft Excel?

Â Average absolute deviation function calculates the absolute values and to get the sum of squared values.

##### Step 1:
• Open your workbook in Microsoft excel. Select the cell, where you want to calculate the AVEDEV.
##### Step 2: you can give the formula in the cell, â€˜=AVEDEVâ€™ open the parenthesis â€˜(â€˜, thenÂ enter the values, and then close the parenthesis â€˜)â€™.

Press Enter, to get the calculated value.

Share:

### You May Also Like

#### SKEW.P Function in Excel

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...

#### SKEW Function in Excel

In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...

#### RANK.EQ Function in Excel

In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
• Excel
• November 23, 2021