MEDIAN in Microsoft Excel: Median, Outliers and Even Counts

Use MEDIAN in Microsoft Excel to find the middle of a numeric data set, averaging the two central observations when the count is even. The working example below describes daily order totals; its result is measured in orders. The official reference supports the function’s identity and purpose.

This guide separates documentation review from application testing. The expected numbers are independently calculated, not screenshots or results captured from Microsoft Excel.

MEDIAN(number1, [number2], ...)

Numeric inputs: individual numbers or cell ranges holding the observations. One range can contain many observations; a header is not a measurement.

Additional inputs: optional extra numeric values or ranges. Omit the square brackets shown in the syntax notation when entering a formula. The numeric-only examples avoid relying on text or logical-value conversion.

Use the median when the question is about a typical observation rather than a total. An unusually large observation can pull an arithmetic mean far away from most records. The middle position answers a different question and is worth showing alongside the mean, not treating as a replacement in every report.

A median does not measure variability. Two lists can have the same median while one has much more extreme observations. It also cannot recover a combined median from subgroup medians alone: retain the underlying observations when combining groups.

An operations workbook with one row per trading day provides the scenario. Enter the following numeric observations into A2:A9, one per row, with a header in A1. Use a spare result cell outside the input range.

Download the Microsoft Excel MEDIAN practice data (CSV). Import it into a new, blank sheet starting at A1, with a comma as the file delimiter and the header row retained. The CSV contains input values only, not formulas or native test results. Blank spacer columns place the requested position in D2 and any additional test data in column F. Keep observations numeric rather than importing them as text.

Example 1: Find the middle of the working register

=MEDIAN(A2:A9)

Expected result: 270.

The ordered observations are 120, 180, 240, 240, 300, 360, 420, 540. The two central observations are 240 and 300; their average is the median.

Example 2: Check an odd count with a high outlier

=MEDIAN(3,5,7,9,101)

Expected result: 7.

The third of these five ordered values is 7. The unusually large last value changes the mean much more than it changes this middle position. These are literal numbers, not text strings.

Example 3: Keep a real zero in an even-sized group

For this check, use F2:F5 containing 0, 2, 8, 10, in that order. These values are included in the practice file.

=MEDIAN(F2:F5)

Expected result: 5.

The central values are 2 and 8, so their average is 5, even though 5 does not appear in the list. Removing the measured zero would leave three values and change the median to 8.

For odd n, select ordered position (n + 1)/2. For even n, average positions n/2 and n/2 + 1. This positional definition explains both the odd-count and even-count examples without changing the order of the input register. Keep stored results at full available precision and round only the final presentation when a report requires it. The displayed expectations above are rounded where necessary; a different number of displayed decimal places is not by itself a calculation error.

The result is not present in the data. That is normal for an even count: the median can lie between the two central values. Do not replace it with the nearest observed value unless your reporting rule explicitly requires that different statistic.

A numeric count unexpectedly changes. Examine imported numbers, blank cells and zero values separately. A missing measurement and a measured zero have different meanings. The examples use numeric cells so they do not rely on text-conversion behaviour.

A summary of group medians seems wrong. The median of medians is generally not the median of all original observations. Recalculate from the original records when possible, with the intended inclusion rule documented.

The Microsoft function reference is the source for this guide’s Excel name and purpose. The reviewed Excel help distinguishes values supplied as arguments from values inside referenced arrays or ranges. Keep imported observations numeric rather than depending on automatic conversion of text or logical values.

For the daily order workbook, keep one comparable trading day per row. Exclude a grand-total row from the statistical input; it is not another trading day. When combining weeks, check that repeated dates are legitimate records rather than duplicated imports. The formula cannot make that distinction for you.

These examples use English function names and comma-separated arguments. A workbook configured for another regional separator may require semicolons. The data addresses stay the same. Test a copied formula on a small known input after an import or file conversion; this guide is not a certification of every Excel edition or exchange format.

For the same statistical question in other programs, see MEDIAN in Google Sheets, MEDIAN in ONLYOFFICE, MEDIAN in SoftMaker PlanMaker. These links identify corresponding measures, not a guarantee that names, mixed-data rules, error codes or file conversions are identical.

LARGE, SMALL, RANK.EQ, STDEV.S, STDEV.P, VAR.S, VAR.P. Browse the Microsoft Excel function library for the other published guides.

Editorial verification: The vendor documentation was reviewed on 2026-10-12. Scope: Microsoft Excel worksheet functions; the current Microsoft help entry is the reference, not a claim about every historical edition. Three numeric examples were checked with an independent arithmetic model. No native application run was performed. Single-value population edge cases, mixed-data coercion, exact error-code parity and round-trip workbook compatibility remain untested; they are not labelled application-verified.