How to Use Excel AVEDEV Function in Office 365? – {with Examples}
Tags: excelavedevfunctioni, excelfunctions
Published: 2020-09-02 10:58:02

---
title: How to Use Excel AVEDEV Function in Office 365? – {with Examples}
published: true
date: 2020-09-02 07:15:48 UTC
tags: ExcelAVEDEVFunctioni,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-excel-avedev-function-in-office-365-with-examples/
---

## Excel AVEDEV Function:

![AVEDEV Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/4.png)<figcaption id="caption-attachment-13137">AVEDEV Function</figcaption>

In this article, you will understand the usage of the **Excel AVEDEV**  **Function in Office 365** with its syntax, explanation, and examples. Let’s step into this article!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)


## **AVEDEV Function – Explanation:**

- This function returns the average of the absolute value of deviations from the mean for a given set of data.

## **Syntax:**

**=AVEDEV(number1, [number2],… )**

The mathematical equation to find average deviation:

![Average Deviation Formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-6.png)<figcaption id="caption-attachment-13133">Average Deviation Formula</figcaption>

### Parameter Description:

**Number 1 ** – First value or reference.

**Number 2 ** – This is optional. It is the second value or reference.

### Note:

- The arguments can be numbers, arrays, names, or references that contain numbers.
- If the arguments contain logical values, empty cells, and the cells that contain text, they are ignored.

## **Examples:**

Let’s see some examples to make it clear.

### Example 1:

- In this below image, you can see the input numbers in **Column A** , its deviation in **Column B** , and its absolute values (find using [ABS Function](https://geekexcel.com/how-to-use-abs-function-in-microsoft-excel-365/)) of deviation are listed in **Column C**.
- The simple average value of the input numbers found in the **cell B9 ** using **Excel Average Function**.
- The Average deviation of numbers is given in the **cell B10**.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/2-5.png)<figcaption id="caption-attachment-13134">Example 1</figcaption>

### Example 2:

- The arguments can be **“numbers** , **arrays** , **names** , or **references”** that contain numbers.
- If the arguments contain **“logical values** , **empty cells** , and the **cells that contain the text”** , they are ignored.
- Refer to the below example.

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/3-1.png)<figcaption id="caption-attachment-13135">Example 2</figcaption>

From the above examples, you can learn how to use **AVEDEV Function** in Excel.

## **Verdict:**

In the above article, you can understand the usage of **Excel AVEDEV**  **Function in Office 365** with its syntax, explanation, and examples. Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Read Also:

- [How to Use Excel ASIN Function in Office 365? – (with Examples)](https://geekexcel.com/how-to-use-excel-asin-function-in-office-365-with-examples/)
- [How to Use Excel ROUND Function in Office 365? – (with Examples)](https://geekexcel.com/how-to-use-excel-round-function-in-office-365-with-examples/)