In this tutorial, we will learn about How People use AVERAGE to fool you. Use MEDIAN in Excel with the help of 2 Formulas given below.

1. AVERAGE Function in Excel

2. MEDIAN Function in Excel

**Case 1**

In this data, I have one column named Salary after MBA, and inside there are various salaries in each row.

Now I want to find out the average salary after MBA from the given data. So to find out the average salary we will be using the Average Formula.

1. Press =**AVERAGE**

2. Choose the **entire data =AVERAGE(B6:B10)**

3. Press **Enter** and the answer is RS **738000** which is the expected salary after MBA

**Case 2**

In this given data, one person is a US citizen, so when the person migrates to his home country, then the salary will be high according to purchasing power.

So when there are outliers in the table, and you want to know the Average salary after MBA, then you will be using Median Formula by following the steps given below:

1. Press **=MEDIAN**

2. Choose the entire data **=MEDIAN(B6:B10)**

3. Press **Enter** and the answer is **400000** which means most of the people will get this much amount as an expected Salary after MBA

**Note –** Outliers means which are different from the average data

4. Using MEDIAN Formula will give you a better information while making a decision. So whenever you see any outliers in the table then use **MEDIAN formula along with the AVERAGE** to see the difference of your answer in the given data.

## Leave a Reply