13.2.2. Converting Ungrouped Data into Grouped Data

In most of our real life situations, data is usually so large that to make a meaningful study it needs to be condensed as grouped data. So, we need to convert given ungrouped data into grouped data and devise some method to find its mean.

In real life, we often deal with large sets of data, such as test scores of students or daily temperatures. These large datasets can be challenging to analyze when they are ungrouped, as individual values can overwhelm the observer. To make the data more manageable, we convert ungrouped data into grouped data. This condenses the information into class intervals, making it easier to analyze and interpret.

Consider a teacher who has 100 students’ scores in a math test. Looking at 100 individual scores would be overwhelming, but if the teacher groups these scores into ranges (for example, 0-10, 11-20, etc.), she can quickly see how many students scored in each range and identify trends more effectively.

Let us convert the ungrouped data of Example 1 into grouped data by forming class-intervals of width, say 15. Remember that, while allocating frequencies to each class-interval, students falling in any upper class-limit would be considered in the next class, e.g., 4 students who have obtained 40 marks would be considered in the class-interval 40-55 and not in 25-40.

To create grouped data, we first determine the width of the class intervals, which in this case is 15. We must ensure that any data point that reaches the upper limit of a class is included in the following class interval. This means students scoring exactly 40 will be counted in the 40-55 interval, not the 25-40 interval. This method of categorizing data helps us to summarize the scores efficiently.

Think about sorting books in a library. If you're organizing books by their page counts, you might decide that all books with 200-215 pages go into one box. If a new book comes in with exactly 215 pages, you'd place it in the next box (the 215-230 pages box) because it just exceeds the previous range. This way, all items are classified neatly without any ambiguity.

Now, for each class-interval, we require a point which would serve as the representative of the whole class. It is assumed that the frequency of each class-interval is centred around its mid-point. So the mid-point (or class mark) of each class can be chosen to represent the observations falling in the class.

For each class interval, it is crucial to identify a representative value, known as the class mark or midpoint. The class mark is calculated by taking the average of the lower and upper class limits. This helps us in simplifying calculations when determining the mean and other statistical operations.

Imagine a weighing scale that only shows the midpoint for groups of fruits instead of individual weights. For example, if you have apples that weigh between 100 and 120 grams, instead of weighing each apple, you'd treat the entire batch as if each one weighs 110 grams (the midpoint). This simplifies the processing.

We can now proceed to compute the mean in the same manner as in Example 1.

Once we have our class intervals and their corresponding class marks, we can calculate the mean of the grouped data. We multiply each class mark by the frequency of that class and then sum these products. Finally, we divide the total by the sum of all frequencies. This process allows us to find an average that represents the entire grouped dataset.

Think about calculating the average height of all the students in your class. If you group students by their heights, say 140-145 cm and 145-150 cm, you don't have to measure every single student. Instead, you multiply the average height of each group by the number of students in that group to arrive at a collective average height.

We observe that Tables 13.1 and 13.3 are using the same data and employing the same formula for the calculation of the mean but the results obtained are different. Can you think why this is so, and which one is more accurate?

When calculating the mean from different methods or data formats, such as ungrouped vs. grouped data, the outcomes can differ because of the assumptions made about the observations within each class. The mean derived from ungrouped data is exact, while that from grouped data is an approximation since it assumes all observations fall at the class mark.

Consider estimating how many calories are consumed in several meals. If you have precise nutritional data for each meal (ungrouped), you know the exact count. However, if you categorize meals into 'light', 'medium', and 'heavy' meals, you're estimating the average based on assumed values for those categories, which might not represent the exact caloric intake perfectly.

--