EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Statistical Functions in Excel Excel Median Function
 

Excel Median Function

Madhuri Thakur
Article byMadhuri Thakur

Updated August 23, 2023

Median function in excel

 

 

Median Function in Excel (Table of Contents)
  • Median Function in Excel
  • Median Formula in Excel
  • How to Use the Median Function in Excel?

Median Function in Excel

A median function is categorized under the statistical function; This MEDIAN function returns the median of the numbers provided. This is the number in the middle of a set of numbers, separating the higher half of its value; it is the central aspect of the data set arranged in order of magnitude.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

The values supplied as arguments do not need to be sorted in any particular for the function to work.

Median Formula in Excel

Below is the Median Formula in Excel :

Median function formula

Median Formula in Excel has the following arguments :

  1. Number 1 (required argument) – The number arguments are a set of single or more numeric values (or arrays of numeric values) for which you want to calculate the median.
  2. Number 2 (optional argument)

Steps of using the median function

  • Select the Formulas tab & Click On More Function.

Median function step 1

  • Choose Statistical to open the Function drop-down list. Select MEDIAN in the list.

Median function step 2

  • Also, click on the Insert function icon, then manually write Median and search the formula.

Median function step 3

  • We get new function windows shown in the below mentioned picture.

Median function step 4

  • Then we have to enter the details. Put the Numbers value or Range value where you want to get the middle value of the series. Then Click On OK.

Median function step 5

Shortcut of using the formula

Click on the cell where you want the result from the value, then put the formula as below mentioned.

Median function formula 2

How to Use Median Function in Excel?

The median function is quite simple to understand and use. In contrast, other Microsoft Excel functions have numerous arguments or parameters.

You can download this Median Function Excel Template here – Median Function Excel Template

Example # 1 -Median Function on even Numbers

Let’s understand below mentioned table below and the data as a series of even numbers; now I want to know the middle no of the series; we can see that this is an even series of the set. So, on even numbers of the group, median functions pick the two middle numbers of value and get the average. So in this series, the two middle numbers of the set are 10 and 9; thus, if we get an average of 10 and 9 ( 10 + 9 ) / 2, then we get 9.5. Thus we can use the median function on the numbers of all sets to get the result.

Median function example 1

Now we will apply the Median function on the above data:

= MEDIAN (A2: A17 )

 example 1-2

The Result will be :

 example 1-3

Example #2- Median on Odd Numbers of Group

As shown in example one, this is the same table; only remove one number for creating the odd numbers of the group.

So if we use the median function on an odd number of the set, we simply find the middle numbers of value in the series and get the result. For example, we can see that 9 is the exact middle value of the group.

Median function example 2

Now we will apply the Median function in the below data:

= MEDIAN (E2: E16 )

 example 2-2 png

The Result will be :

 example 2-3 png

Explanation of the Median Function

There are two concepts of median function: odd numbers of the set and even numbers of the set.

If the data series is in odd numbers. The MEDIAN function in Excel finds the middle of a number set or series; this result value is the middle in a group of numbers when those numbers are listed in numerical order.

Suppose the data contains an even number of values. The median then is the average of the middle two numbers in the group – when sorted numerically.

Suppose we talk about the data type: numbers, dates, named ranges, dates, arrays, or references to cells containing digits. Number 1 is required; subsequent numbers are optional.

The median and average functions are approximately the same, but there is some difference between both formulas. Let’s understand mathematical logic.

In the below-given example, we will find the difference between the average and median function by the following set of series.

 explanation 1

 explanation 2

We can see that when we are using the median function for getting the middle number in a set of numbers listed in numeric order, as mentioned above, as per odd numbers, any mathematical calculation of series finally gets the result exactly in the middle value of set as 3.

When we use the average function, the numbers are added, or the sum of the total set, and then the total no of the count is divided. So the sum of the series is 18, and the total no of the count is 5, then 18 / 5 = 3.6 is the average of the series.

= AVERAGE (H7: H11 )

= MEDIAN (H7: H11 )

= SUM ( H7 : H11 ) / COUNTA ( H7 : H11)

The median function uses of the arguments:-

The arguments can contain numbers, cell references, formulas, and other functions, or maybe 1 to 255 arguments (Like number 1, Number 2, Number 3, Etc.) of the Median function mentioned below.

= MEDIAN ( number 1, Number 2, Number 3, Etc / Range Value )

Things to Remember while Using Median Function

  • This function only applies numeric values and dates; it will not work on any text value type. Arguments with text or error values that cannot be translated into numbers cause errors.
  • If there is an even number of values in the dataset, the average of the two middle values is returned.
  • If there is an odd number of values in the dataset, exactly the middle numbers of the set are returned.
  • In current versions of Excel (Excel 2007 and later), the function can only accept up to 30 number arguments, but you can provide up to 255 number arguments to the Mode function in Excel 2003.
  • Cells with zero values (0) are added to calculations.

Recommended Articles

This has been a guide to Median Function in Excel. Here we discuss the Median Formula in Excel and How to use the Median function in Excel, along with practical examples and a downloadable Excel template. You can also go through our other suggested articles –

  1. AGGREGATE Function in Excel
  2. Excel Median Formula
  3. MODE Excel Function
  4. MID Function in Excel

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Median Function Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download Median Function Excel Template

EDUCBA

डाउनलोड Median Function Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW