How to Calculate Meadian in Excel?

What is Median in Excel?

What is Mode in Excel

Follow the below steps to calculate Median in Excel:

Step 1: Enter your data

Data Entered

Step 2: Select a Cell

Choose an empty cell within your worksheet where you’d like the median value to be displayed.

Cell Selected

Step 3: Use the MEDIAN Function

In the selected cell, type “=MEDIAN(“

Enter the MEDIAN Function

Step 4: Select Your Data Range

Now, select the range of cells that contain your data. In this example, you would select cells A1 to I1. You can either manually type this range or click and drag to select it.

Select the Data range

Step 5: Close the Parenthesis and Press Enter

Once you’ve chosen your data range and closed the parenthesis, press Enter. Excel will then compute the median of the data you selected and show the result in your chosen cell.

Step 6: Preview the Result

Preview the Result

This method works well when dealing with an odd number of values in a dataset. However, what if you have an even number of values? In such a scenario, the median is the average (arithmetic mean) of the two middle values.

For example in the Below example, there are 10 values in the data set.

10 Values in the Dataset

Repeat all the steps as of above and preview the result in the Below image:

Preview the Result

How to Calculate Mean, Median and Mode in Excel

The mean (also called average) of the data set is calculated by adding all the numbers in the data set and then dividing it by the total number of values in the data set. In this article, we will find out how to calculate the mean in Excel.