When you group data into intervals, information is lost. So assumptions are made in order to make reasonable estimates of the sample mean, median, etc.

The assumption of this formula for estimating the median from grouped data is that the data are spread roughly uniformly throughout the interval. Clearly, this assumption is not met in your situation because all ten of the 's lie at the lower endpoint of the interval. The idea of the formula is to estimate the median by interpolation, putting the estimate somewhere within the interval. In your case the estimated value is in the middle of the 'median interval' (the interval known to contain the median).

If you were trying to contrive a situation in which the estimate is even farther from the truth, you could put your ten 's at the left end of an interval With no other data, your estimate of the median would then be

There is nothing wrong with the formula, provided the assumption of data spread evenly throughout the interval is close to the truth. But any formula for estimating the median from grouped data will have to depend on assumptions. All that can be said for sure is the the median lies somewhere in the median interval. You have to recognize that the information lost in grouping data into intervals cannot be precisely recovered (unless the original data are saved and used).


Note: By contrast, the assumption usually made when trying to estimate the sample mean from grouped data is that each observation lies precisely at the midpoint of the interval that contains it. This idea gives rise to the formula $\bar X \approx \frac 1 n \sum_{i=1}^k f_jm_j,$ where there are intervals (usually of equal width), with midpoints and frequencies

Answer from BruceET on Stack Exchange
🌐
Statology
statology.org › home › how to find the median of grouped data (with examples)
How to Find the Median of Grouped Data (With Examples)
February 11, 2022 - The following examples show how to calculate the median of grouped data in different scenarios. Suppose we have the following frequency distribution that shows the exam scored receive by 40 students in a certain class: In this example, there are N = 40 total values. Thus, the median value lies in the class where 40/2 = 20 is located. The 20th largest value would be located in the 71-80 class. Knowing this, we can calculate the following values: ... We estimate that the median exam score is 75.8.
🌐
Math is Fun
mathsisfun.com › data › frequency-grouped-mean-median-mode.html
Mean, Median and Mode from Grouped Frequencies
Estimated Mode= 20 + 23 − 21(23 − 21) + (23 − 16) × 10 = 20 + 2.22... = 22.2 (to 1 decimal) For grouped data, we cannot find the exact Mean, Median and Mode, we can only give estimates.
People also ask

Why is the median useful in grouped data?
The median provides a measure of central tendency that is not affected by extreme values. It gives a better idea of the middle of the data when the values are spread over intervals.
🌐
testbook.com
testbook.com › home › maths › median of grouped data
How to Find the Median of Grouped Data with Step-by-Step Solved ...
What is the Formula for the Median of Grouped Data?
The median of grouped data can be found using the formula: Median = \( l\ + \left (\frac{\frac{N}{2}-C}{f}\right) \times h \)
🌐
testbook.com
testbook.com › home › maths › median of grouped data
How to Find the Median of Grouped Data with Step-by-Step Solved ...
How do you find the mean of a grouped data?
To compute the arithmetic mean of a continuous frequency distribution, we have to compute the midpoint of the class interval. The midpoints are then multiplied by the corresponding frequencies. We then find the sum of this product and divide it by the sum of frequencies. We can use this formula to find the Arithmetic mean, Mean=A+h/N(Σfu)
🌐
testbook.com
testbook.com › home › maths › median of grouped data
How to Find the Median of Grouped Data with Step-by-Step Solved ...
🌐
Testbook
testbook.com › home › maths › median of grouped data
How to Find the Median of Grouped Data with Step-by-Step Solved Examples
So, we must find the class interval that splits the total number of values into two equal parts. This special class is called the median class. Once we identify the median class, we use a formula to calculate the exact median value.
Top answer
1 of 1
1

When you group data into intervals, information is lost. So assumptions are made in order to make reasonable estimates of the sample mean, median, etc.

The assumption of this formula for estimating the median from grouped data is that the data are spread roughly uniformly throughout the interval. Clearly, this assumption is not met in your situation because all ten of the 's lie at the lower endpoint of the interval. The idea of the formula is to estimate the median by interpolation, putting the estimate somewhere within the interval. In your case the estimated value is in the middle of the 'median interval' (the interval known to contain the median).

If you were trying to contrive a situation in which the estimate is even farther from the truth, you could put your ten 's at the left end of an interval With no other data, your estimate of the median would then be

There is nothing wrong with the formula, provided the assumption of data spread evenly throughout the interval is close to the truth. But any formula for estimating the median from grouped data will have to depend on assumptions. All that can be said for sure is the the median lies somewhere in the median interval. You have to recognize that the information lost in grouping data into intervals cannot be precisely recovered (unless the original data are saved and used).


Note: By contrast, the assumption usually made when trying to estimate the sample mean from grouped data is that each observation lies precisely at the midpoint of the interval that contains it. This idea gives rise to the formula $\bar X \approx \frac 1 n \sum_{i=1}^k f_jm_j,$ where there are intervals (usually of equal width), with midpoints and frequencies

🌐
The Math Doctors
themathdoctors.org › finding-the-median-of-grouped-data
Finding the Median of Grouped Data – The Math Doctors
Then the class boundaries are -1/2 to 2 1/2, so that L = -1/2, N = 30, F = 0, f = 16, and C = 3. The formula gives m = L + [ (N/2 – F) / f ] * C = -1/2 + [ (30/2 – 0) / 16 ] * 3 = 2.3125 (that is, 2 5/16). This is, of course, only an estimate of the true median, based on the assumption ...
🌐
Cuemath
cuemath.com › data › median-of-grouped-data
Median of Grouped Data - Formula, Class 10, How to Find?
Therefore, to find the median for grouped data we can use the following steps and formula: Step 1: Find the total number of observations. Step 2: Define the class size, and divide the data into different classes.
Find elsewhere
🌐
AtoZmath
atozmath.com › StatsG.aspx
Mean, Median and Mode for grouped data calculator
Find Mean, Median and Mode for grouped data calculator - Find Mean, Median and Mode for grouped data, step-by-step online
🌐
GeeksforGeeks
geeksforgeeks.org › mathematics › median-of-grouped-data
Median of Grouped Data: Formula, How to Find, and Solved Examples - GeeksforGeeks
July 23, 2025 - To find median of ungrouped data, one can simply sort the data points in ascending order. In case of odd number of observations, the middle value would be the median. On the other hand , for even number of observations, one can take mean of ...
Top answer
1 of 3
2

Because this is essentially a duplicate, I address a few issues that are do not explicitly overlap the related question or answer:

If a class has cumulative frequency .5, then the median is at the boundary of that class and the next larger one.

If is large (really the only case where this method is generally successful), there is little difference between and in the formula. All references I checked use .

Before computers were widely available, large datasets were customarily reduced to categories (classes) and plotted as histograms. Then the histograms were used to approximate the mean, variance, median, and other descriptive measures. Nowadays, it is best just to use a statistical computer package to find exact values of all measures.

One remaining application is to try to re-claim the descriptive measures from grouped data or from a histogram published in a journal. These are cases in which the original data are no longer available.

This procedure to approximate the sample median from grouped data $assumes$ that data are distributed in roughly a uniform fashion throughout the median interval. Then it uses interpolation to approximate the median. (By contrast, methods to approximate the sample mean and sample variance from grouped data one assumes that all obseervations are concentrated at their class midpoints.)

2 of 3
0

According to what I learned the class where the median is located is the lowest class for which the cumulative frequency equals or exceeds

Therefore, the median class would be in 30-40. which would give 30.833 approximately as you said 31.

🌐
Reddit
reddit.com › r/excel › is there a single formula for calculating median of grouped data for multiple datasets ?
r/excel on Reddit: Is there a single formula for Calculating Median of Grouped Data for multiple datasets ?
August 11, 2022 -

Each row is a separate dataset (up to 150 rows in a spreadsheet). The columns give the frequency in each group. I can manually find the median class and calculate the median for each row (albeit with some difficulty). But would like to make it a more automatic procedure.

I hope the screen shot below helps.

Top answer
1 of 6
1
u/AussieRuth - Your post was submitted successfully. Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread. Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. Include your Excel version and all other relevant information Failing to follow these steps may result in your post being removed without warning. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
2 of 6
1
With grouped data, you have the x-value and its frequency, eg if the data are: 0 0 1 2 3 3 4 4 4 , you could write it as x 0 1 2 3 4 f 2 1 1 2 3 The median is found by finding the half-way point ie the 5th point, ie x=3. If the frequencies are fairly large eg in the 100s, then you cumulatively add until you get to half-way. If, instead of simple x- values, you have say age-ranges or income-brackets, then you can only find the median class (bracket) this way. There is a further adjustment to get an actual numerical estimate of the median. My median brackets are different for each row, so the xl formulae for the adjustment is different for each row. And I have to physically change the formula for each row. That's what I would like to do automatically. eg in row 17, the formulae use columns W and X to calculate median in row 18, the formulae use columns U and V to calculate median Not sure if this is what you wanted to know about need to automate.
🌐
YouTube
youtube.com › the organic chemistry tutor
Mean, Median, and Mode of Grouped Data & Frequency Distribution Tables Statistics - YouTube
This statistics video tutorial explains how to calculate the mean of grouped data. It also explains how to identify the interval that contains the median and...
Published   January 26, 2019
Views   1M
🌐
Excel Insider
excelinsider.com › home › excel for statistics › how to find median for grouped data in excel (2 easy ways)
How to Find Median for Grouped Data in Excel (2 Easy Ways) - Excel Insider
October 16, 2025 - Half of the observations are lower than the median value, while the other half are greater than the median value. Class intervals and frequencies are used to estimate the grouped median, instead of the individual data points.
🌐
Nagwa
nagwa.com › en › explainers › 183154045804
Lesson Explainer: Grouped Frequency Tables: Estimating the Median | Nagwa
We can observe that there is no way to extract an exact median from a grouped table, as we cannot tell the original, exact data values from a grouped distribution. Instead, we determine an estimate for the median.
🌐
University of Massachusetts
people.umass.edu › biep540w › pdf › Grouped Data Calculation.pdf pdf
1. Mean, Median and Mode 2. First Quantile, third Quantile and Interquantile
Median and Interquartile · Range · – Grouped Data · Step 1: Construct the cumulative frequency distribution. Step 2: Decide the class that contain the median. Class Median is the first class with the value of cumulative · frequency equal at least n/2. Step 3: Find the median by using ...
🌐
The Bricks
thebricks.com › resources › how-to-find-median-in-excel-for-grouped-data
How to Find the Median in Excel for Grouped Data
So, the median for our grouped data is approximately 20.42. This calculation provides a precise estimate of the central tendency for grouped data, thanks to Excel’s ability to automate complex arithmetic.
🌐
BBC
bbc.co.uk › bitesize › articles › z3kj6rd
Calculating averages from grouped data - KS3 Maths - BBC Bitesize
September 23, 2025 - Add the frequencies to find how many values there are. Divide the total of all the values by how many values there are. To find the class that contains the median, identify the class that contains the middle value.
🌐
BYJUS
byjus.com › maths › median-of-grouped-data
Median of Grouped Data
... The formula to find the median of grouped data is: Median = l+ [((n/2) – cf)/f] × h Where l = lower limit of median class, n = number of observations, h = class size, f = frequency of median class, cf = cumulative frequency of class preceding ...
Published   June 16, 2022
Views   34K
🌐
ALLEN
allen.in › home › jee maths › median of grouped data
Median of Grouped Data with Solved Examples
May 19, 2025 - Hence, finding the median of grouped data involves estimating the value that lies at the midpoint of the cumulative frequency distribution. To find the median of grouped data, use the following formula: ... Create a cumulative frequency column from the frequency distribution.
🌐
BBC
bbc.co.uk › bitesize › guides › zwhgk2p › revision › 7
Averages from a grouped table - Analysing data - Edexcel - GCSE Maths Revision - Edexcel - BBC Bitesize
February 13, 2023 - There can be more than one mode and there can also be no mode., medianclosemedianThe median is the middle value. or meanclosemeanThe total of the numbers divided by how many numbers there are.. We can find the modal group and identify the group that contains the median. We can find an estimate for the mean by using the mid-values of the groups.