=MEDIAN(number1, [number2], ...)One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward.
Need more than a single MEDIAN formula? Try our free AI for Excel — it reads your entire spreadsheet, answers questions in plain English, and builds charts and analysis in the same chat.
number1:
The first number or range of numbers for which you want to find the median. This is a required parameter.
number2:
An optional second number or range of numbers to include in the median calculation. You can include additional numbers or ranges as needed.
The MEDIAN function in Excel is a statistical tool that calculates the middle value of a set of numbers. It is particularly useful when you want to find the central tendency of a dataset, especially when the dataset contains outliers that could skew the average.
In simpler terms, the MEDIAN function helps you identify the midpoint of a range of values, providing a better representation of the data's center than the average in certain cases.
Imagine you are analyzing the test scores of a group of students, and you have the following data in an Excel spreadsheet:
| Student | Test Score |
|---|---|
| John | 85 |
| Sarah | 92 |
| Mike | 76 |
| Anna | 88 |
| Tom | 95 |
You want to find the median test score of the students.
To calculate the median test score, you would use the MEDIAN formula as follows:
=MEDIAN(B2:B6)When you apply the formula, it calculates the median of the test scores. The output would be:
| Median Test Score |
|---|
| 88 |
Here, the median test score is 88, which is the middle value when the scores are arranged in ascending order (76, 85, 88, 92, 95).
The MEDIAN function is particularly useful when you want to analyze data that may have outliers or extreme values. It provides a more accurate reflection of the dataset's central tendency, making it easier to understand the overall performance or trends in the data.
Understanding how to use the MEDIAN function can significantly enhance your data analysis capabilities in Excel, enabling you to extract meaningful insights from your datasets.
Happy calculating!
You have a table where Column A contains the names of students and Column B contains their corresponding test scores for a particular exam. You can use the MEDIAN function to determine the median score of the class. This helps in understanding the overall performance of the students, identifying the central tendency of the scores, and making informed decisions about areas that may need additional focus or support without getting influenced by outliers in the data.
Beyond the MEDIAN function: Better Analyst is a full Excel AI that goes well past individual formulas. Upload any spreadsheet and ask questions in plain English — you'll get formulas, data analysis, and charts back in seconds. It's a free AI Excel assistant that works with any .xlsx, .xls, or .csv file — no plugins, no Microsoft 365 required.
Don't have a spreadsheet yet? Use our free AI spreadsheet generator to turn a text prompt into a downloadable Excel file — a full AI Excel sheet maker that builds headers, columns, and formulas from your description.
Create a free account for formula help, explanations, and spreadsheet analysis. Usage limits depend on your plan.
Browse our complete library of Excel formula guides
Compare your options
Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose.
AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.