- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to calculate median in a range in Excel?
Follow the steps given below to understand clearly how to calculate the median in a range in a Microsoft Excel sheet.
Step 1
Open a Microsoft Excel sheet, and enter the data as shown in below you can also enter the data as per your wish.
Step 2
Now select a blank cell and type the below given formula in order to calculate the median and then press enter key to get the median in the cell.
=MEDIAN(A1:A6)
Note −
In the above‑mentioned formula, A1:A6 represents the range that you want to calculate the median from).
You can use the below given formula if the data range is not continuous.
You can use the below given formula if you have the data with three discontinuous ranges.
=MEDIAN(A1:C3,E1:G3)
=MEDIAN(A1:A3,E1:G3, A5:D8)).
In the above formula, A1:C3 and E1:G3 are the ranges which you want to calculate the median from, and then the comma refers to and.
Calculating the Median Excluding the Zero in a Range
Consider at times if the data is zero, and then you do not want to calculate the median excluding zero. In this case, you will use the below mentioned formula. Follow the steps given below −
Step 1
Open a Microsoft excel sheet, and enter the data as shown below you can also enter the data as per your wish. Kindly find the below screenshot for your reference.
Step 2
If you do not want to calculate the median excluding zero, use the below formula. Select a blank cell enter the formula and press enter key as shown in the below screenshot.
=MEDIAN(IF(A1:C6>0,A1:C6))
Conclusion
In this tutorial, we used a simple example to demonstrate how you can calculate the median in a range in Excel.
180 Views
