• Skip to primary navigation
  • Skip to content
  • Skip to primary sidebar
  • Skip to footer
EDUCBA

EDUCBA

MENUMENU
  • Resources
        • Excel Charts

          • Histogram Chart Excel
          • Basic Excel Formulas
          • Text to Columns in Excel
        • Excel Charts
        • Excel Tips

          • Excel Gantt Chart
          • IFERROR with VLOOKUP
          • Data Table in Excel
        • Excel Tips
        • Excel Tools in Excel

          • Stacked Column Chart
          • Cheat Sheet of Excel Formulas
          • Excel Data Validation
        • Histogram chart in excel
        • Others

          • Resources (A-Z)
          • Excel Functions
          • Financial Functions in Excel
          • Logical Functions in Excel
          • Lookup Reference Functions in Excel
          • Maths Function in Excel
          • TEXT and String Functions in Excel
          • View All
  • Free Courses
  • All Courses
        • Certification Courses

          Excel Course 1
        • All in One Bundle

          All-in-One-Excel-VBA-Bundle
        • Excel course

          Excel-Training
        • Others

          • Excel advanced course
          • VBA Course
          • Excel Data Analysis Course
          • Excel for Marketing Course
          • Excel for Finance Course
          • View All
  • 120+ Courses All in One Bundle
  • Login

Excel Median Function

Home » Excel » Blog » Statistical Functions in Excel » Excel Median Function

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

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 set of numbers, separating the higher half of its value it is the central aspect of the data set arranged in order of magnitude

Start Your Free Excel Course

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

The values supplied as arguments do not need to be sorted in any particular in order 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 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 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?

Median function in excel is very simple and easy compared to other functions in Microsoft Excel which contains lots of 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 and data as a series of even numbers, now I want to know 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, 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 numbers of all set to get the result.

Median function example 1

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

= MEDIAN (A2: A17 )

Median function example 1-2

The Result will be :

Median function 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 then simply find the middle numbers of value in series and we get the result. For example, we can see that 9 is the exact middle value of the group.

Popular Course in this category
Cyber Week Sale
Excel Advanced Training (14 Courses, 21+ Projects) 14 Online Courses | 21 Hands-on Projects | 129+ Hours | Verifiable Certificate of Completion | Lifetime Access
4.8 (2,665 ratings)
Course Price

View Course

Related Courses
Excel for Marketing Training (5 Courses, 12+ Projects)

Median function example 2

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

= MEDIAN (E2: E16 )

Median function example 2-2 png

The Result will be :

Median function example 2-3 png

Explanation of the median function

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

If the data series 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.

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

If we talk about the data type which can be numbers, dates, named ranges, dates, arrays, or references to cells containing digits. Number1 is required, subsequent numbers are optional.

Basically, as we know the median function and average function are approximately the same but there is some difference between both the formulas. Let’s understand the mathematical logic.

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

Median function explanation 1

Median function 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, that as per odd numbers, any mathematical calculation of series finally gets the result exactly in the middle value of set as 3.

When we are using the average function the numbers are added or the sum of the total set and then their total no of the count is divided. So the sum of the series is 18 and total no of the count is 5 then 18 / 5 = 3.6 is 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 it’s Maybe 1 to 255 arguments (Like number 1, Number 2, Number 3, Etc.) of Median function which is below mention.

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

Things to Remember About the Median Function in Excel

  • This function is applicable in only numeric value and dates, it will not work on any type of text value. Arguments that are text or error values and which 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, the function of exactly the middle numbers of the set is returned.
  • In current versions of Excel (Excel 2007 and later), the function can only accept up to 30 number argument but you can provide up to 255 number arguments to the Mode function in Excel 2003.
  • Cells with zero values (0) are added in 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 downloadable excel template. You can also go through our other suggested articles –

  1. Guide on AGGREGATE Function
  2. Illustration of Excel MOD Function
  3. Importance of MID Function in Excel
  4. EVEN Excel Function: Information

All in One Excel VBA Bundle (120+ Courses, 30+ Projects)

120+ Online Courses

30+ Projects

500+ Hours

Verifiable Certificates

Lifetime Access

Learn More

1 Shares
Share
Tweet
Share
Reader Interactions
Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar
Excel Functions Tutorials
  • Statistical Functions in Excel
    • Interpolate in Excel
    • Linear Programming in Excel
    • COUNTIFS in Excel
    • Excel Variance
    • Normal Distribution Formula in Excel
    • Count Cells with Text in Excel
    • Excel Formula For Rank
    • Linear Regression in Excel
    • COUNTA Function in Excel
    • MAX Formula in Excel
    • Excel NORMSINV
    • Count Names in Excel
    • FORECAST Formula in Excel
    • NPER in Excel
    • Excel Median Formula
    • Lognormal Distribution in Excel
    • Excel Chi Square Test
    • Count Formula in Excel
    • COUNTIF Examples in Excel
    • Excel P-Value
    • COUNTIF Not Blank in Excel
    • Excel Standard Deviation Formula
    • Excel GROWTH Formula
    • Excel Percentile Formula
    • Excel Frequency Formula
    • Excel Average Formula
    • Excel Correlation Matrix
    • Excel Z Score
    • Excel MAX IF Function
    • Z TEST in Excel
    • Excel Trendline
    • Excel F-Test
    • Excel STDEV Function
    • VBA Function in Excel
    • Excel Frequency Distribution
    • DCOUNT Function in Excel
    • Excel MIN Function
    • Excel Forecast Function
    • FREQUENCY Excel Function
    • COUNTIF with Multiple Criteria
    • Standard Deviation in Excel
    • MAX Excel Function
    • Excel QUARTILE Function
    • Excel T.Test Function
    • Excel PERCENTILE Function
    • MODE Excel Function
    • SLOPE Excel Function
    • Excel Median Function
    • Excel TREND Function
    • Excel Count Function
    • Excel LARGE Function
    • SMALL Excel Function
    • COUNTIF Excel Function
    • Excel AVERAGE Function
    • Excel CORREL Function
  • Excel Functions (10+)
  • Excel Tools (97+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (12+)
  • Lookup Reference Functions in Excel (30+)
  • Maths Function in Excel (39+)
  • TEXT and String Functions in Excel (25+)
  • Date and Time Function in Excel (20+)
  • Information Functions in Excel (4+)
  • Excel Charts (44+)
  • Excel Tips (195+)
  • VBA (180+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (14+)
  • Excel Formula and Functions (20+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Training Certification
  • Online Excel for Marketing Course
Footer
About Us
  • Who is EDUCBA?
  • Sign Up
  •  
Free Courses
  • Free Online Excel Course
  • Free Vba Course
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training
Resources
  • Resources (A To Z)
  • Excel Charts
  • Excel Tips
  • Excel Tools in Excel
  • Excel Functions
  • Financial Functions in Excel
  • Logical Functions in Excel
  • Lookup Reference Functions in Excel
  • Maths Function in Excel
  • TEXT and String Functions in Excel
  • Date and Time Function in Excel
  • Statistical Functions in Excel
  • Information Functions in Excel
Apps
  • iPhone & iPad
  • Android
Support
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions

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

EDUCBA

Download Median Function Excel Template

By continuing above step, you agree to our Terms of Use and Privacy Policy.
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
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
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
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

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 Login

Forgot Password?

Let’s Get Started
Please provide your Email ID
Email ID is incorrect

Limited Period Offer - All in One Excel VBA Bundle (120+ Courses, 500+ hours of Videos) View More

Limited Period Offer - Limited Period Offer - All in One Excel VBA Bundle (120+ Courses, 500+ hours of Videos) View More