Data handling: Calculate, represent and interpret measures of central tendency and dispersion in univariate numerical grouped data

Unit 1: Grouping data using frequency distributions

Natashia Bearam-Edmunds

Unit outcomes

By the end of this unit you will be able to:

  • Construct a frequency distribution by grouping data into classes.

What you should know

Before you start this unit, make sure you can:

  • Work with data and represent data effectively. You can revise the following subject outcomes in Maths level 2:

Introduction

To make sense of data we need to condense it or organise it in a way that makes interpretation easier. We have worked with ungrouped data, which is unorganised or raw data. Now, we will use frequencies to organise and group data. There are different methods to calculate statistics for ungrouped and grouped data. But, before you summarise data, it is important to understand how to organise data using frequency distributions. By counting how often data values appear we can make a frequency distribution.

Frequency is how often something occurs. A frequency distribution, also called a frequency table, is used to organise qualitative and quantitative raw data

Work through Activity 1.1 to learn how to organise data using frequency tables.

Activity 1.1: Organising data using a frequency distribution

Time required: 25 minutes

What you need:

  • a pen and paper

What to do:

Answer the questions based on the given data. Show all the necessary steps.

The following data on the heights (in cm) of netball players has been collected.

[latex]\scriptsize \displaystyle \begin{align*} {165\text{ }148\text{ }158\text{ }150\text{ }160\text{ }165\text{ }150\text{ }156\text{ }155\text{ }164\text{ }162\text{ }160\text{ }158\text{ }148\text{ }158} \\ {140\text{ }146\text{ }160\text{ }148\text{ }152\text{ }139\text{ }165\text{ }148\text{ }160\text{ }156\text{ }158\text{ }170\text{ }155\text{ }160\text{ }148} \\ {155\text{ }158\text{ }179\text{ }170\text{ }158\text{ }161\text{ }155\text{ }160\text{ }163\text{ }178\text{ }138\text{ }172\text{ }170\text{ }156\text{ }160} \\ {160\text{ }171\text{ }140\text{ }160\text{ }170\text{ }175\text{ }148\text{ }170\text{ }177\text{ }155\text{ }167\text{ }154\text{ }160\text{ }170\text{ }155} \\ {136\text{ }179\text{ }150\text{ }167\text{ }148\text{ }160\text{ }164\text{ }167\text{ }157\text{ }165\text{ }163\text{ }140\text{ }162\text{ }178\text{ }160}\\{170\text{ }163\text{ }162\text{ }165\text{ }175\text{ }165\text{ }152\text{ }147\text{ }180\text{ }148\text{ }170\text{ }165\text{ }167\text{ }165~\text{ }165} \end{align*}[/latex]

  1. How many netball players were surveyed?
  2. Is there a simple way to organise the data?
  3. Rewrite the data values from smallest to biggest.
  4. How many netball players are between [latex]\scriptsize 146-155\text{ cm}[/latex] in height?
  5. Group the heights in intervals of [latex]\scriptsize 9\text{ cm}[/latex] starting with a first interval of [latex]\scriptsize 136-145\text{ cm}[/latex]. Draw a table to show the number of netball players that fall within each interval. Label the first column ‘height’ and the second column ‘frequency’.
  6. Can the intervals overlap? Give a reason for your answer.
  7. What is the sum of the frequencies equal to?
  8. From the table you drew for question 5, how many players were shorter than [latex]\scriptsize 166\text{ cm}[/latex]?

What did you find?

  1. There were [latex]\scriptsize 90[/latex] players surveyed.
  2. Even answering a simple question such as ‘how many netball players were surveyed?’ is a long process and can lead to mistakes using ungrouped data. We must organise the data to make it easier to work with. We can arrange these values by rewriting and grouping heights together using intervals.
  3. It is very time consuming to order large sets of raw data and in reality there is computer software that can do this work for us.
    [latex]\scriptsize \displaystyle \begin{align*} 136;\text{ }138;\text{ }139;\text{ }140;\text{ }140;\text{ }140;\text{ }146;\text{ }147;\text{ }148;\text{ }148;\\148;\text{ }148;\text{ }148;\text{ }148;\text{ }148;\text{ }148;\text{ }150;\text{ }150;\text{ }150;\text{ }152;\\152;\text{ }154;\text{ }155;\text{ }155;\text{ }155;\text{ }155;\text{ }155;\text{ }155;\text{ }156;\text{ }156;\\156;\text{ }157;\text{ }158;\text{ }158;\text{ }158;\text{ }158;\text{ }158;\text{ }158;\text{ }160;\text{ }160;\\160;\text{ }160;\text{ }160;\text{ }160;\text{ }160;\text{ }160;\text{ }160;\text{ }160;\text{ }160;\text{ }160;\\161;\text{ }162;\text{ }162;\text{ }162;\text{ }163;\text{ }163;\text{ }163;\text{ }164;\text{ }164;\text{ }165;\\165;\text{ }165;\text{ }165;\text{ }165;\text{ }165;\text{ }165;\text{ }165;\text{ }165;\text{ }167;\text{ }167;\\167;\text{ }167;\text{ }170;\text{ }170;\text{ }170;\text{ }170;\text{ }170;\text{ }170;\text{ }170;\text{ }170;\\171;\text{ }172;\text{ }175;\text{ }175;\text{ }177;\text{ }178;\text{ }178;\text{ }179;\text{ }179;\text{ }180\end{align*}[/latex]
  4. There are 22 players between [latex]\scriptsize 146-155\text{ cm}[/latex] in height.
  5. .
    Height intervals ( in cm) Frequency
    [latex]\scriptsize 136-145[/latex] [latex]\scriptsize 6[/latex]
    [latex]\scriptsize 146-155[/latex] [latex]\scriptsize 22[/latex]
    [latex]\scriptsize 156-165[/latex] [latex]\scriptsize 40[/latex]
    [latex]\scriptsize 166-175[/latex] [latex]\scriptsize 16[/latex]
    [latex]\scriptsize 176-185[/latex] [latex]\scriptsize 6[/latex]
  6. No the intervals cannot overlap. You cannot have a height that falls into two different intervals as you will be double counting.
  7. The total frequency is the same as the total number of observations. [latex]\scriptsize \text{Sum of frequency}=90[/latex].
  8. We must add the frequencies for the intervals [latex]\scriptsize 136-145[/latex]; [latex]\scriptsize 146-155[/latex] and [latex]\scriptsize 156-165[/latex]. There are [latex]\scriptsize 68[/latex] players shorter than [latex]\scriptsize 166\text{ cm}[/latex].

Activity 1.1 showed how to construct a frequency distribution. We also saw that it is much easier to answer questions about data from a frequency table rather than using ungrouped data. As the size of the data set grows it will become even more difficult to handle in its raw form, so we need to organise data before analysing it.

Take note!

Summarising the data into class intervals leads to a loss of detail, in other words we cannot return to the original data set from the grouped intervals. In Activity 1.1, for example, you cannot tell how many players had a height of exactly [latex]\scriptsize 160\text{ cm}[/latex] from the grouped frequency table.

Constructing a frequency distribution

Things to note when creating class intervals for a frequency distribution:

  • Create equal intervals. First, decide how many class intervals you would like to use then calculate the range of data values. Next, divide the range by the number of classes to get an approximate interval width.
  • The first class (lower limit) should start below the smallest observation.
  • Classes must not overlap and must cover the entire range of the data set.

In the next example you will learn how to create class intervals.

Example 1.1

The following data shows the ages of people attending a public reading by an author at a library.

[latex]\scriptsize \begin{align*}&10;\text{ }10;\text{ }11;\text{ }12;\text{ }12;\text{ }13;\text{ }13;\text{ }14;\text{ }14;\text{ }14;\text{ }15;\text{ }15;\text{ }15;\text{ }16;\text{ }16;\text{ }16;\text{ }17;\text{ }17;\text{ }17;\text{ }17;\\&18;\text{ }18;\text{ }18;\text{ }18;\text{ }18;\text{ }19;\text{ }19;\text{ }19;\text{ }19;\text{ }19;\text{ }19;\text{ }20;\text{ }20;\text{ }21;\text{ }22;\text{ }22;\text{ }22;\text{ }22;\text{ }22;\text{ }22;\\&23;\text{ }25;\text{ }25;\text{ }25;\text{ }26;\text{ }26;\text{ }27;\text{ }30\end{align*}[/latex]

Construct a frequency distribution for the data.

Solution

There are [latex]\scriptsize 48[/latex] observations. The minimum age is [latex]\scriptsize 10[/latex] and the maximum age is [latex]\scriptsize 30[/latex] therefore the range of data values is [latex]\scriptsize 20[/latex]. If we would like to create [latex]\scriptsize 7[/latex] class intervals, then the equal interval widths will be [latex]\scriptsize 3[/latex] ([latex]\scriptsize 20\div 7=3[/latex]).

We start the first class interval below the smallest observation so we can start at [latex]\scriptsize 9[/latex] and go up in intervals of [latex]\scriptsize 3[/latex]. You can use a variable to represent age, in this example we have used [latex]\scriptsize x[/latex].

Age intervals Frequency
[latex]\scriptsize 9 \lt x\le 12[/latex] [latex]\scriptsize 5[/latex]
[latex]\scriptsize 12 \lt x\le 15[/latex] [latex]\scriptsize 8[/latex]
[latex]\scriptsize 15 \lt x\le 18[/latex] [latex]\scriptsize 12[/latex]
[latex]\scriptsize 18 \lt x\le 21[/latex] [latex]\scriptsize 9[/latex]
[latex]\scriptsize 21 \lt x\le 24[/latex] [latex]\scriptsize 7[/latex]
[latex]\scriptsize 24 \lt x\le 27[/latex] [latex]\scriptsize 6[/latex]
[latex]\scriptsize 27 \lt x\le 30[/latex] [latex]\scriptsize 1[/latex]
Total [latex]\scriptsize 48[/latex]

You will notice that we include the upper limit of each interval in the lower class and exclude it from the next class. For example, in the first interval we have included [latex]\scriptsize 12[/latex] [latex]\scriptsize (9 \lt x\le 12)[/latex] as the upper limit and we then exclude it [latex]\scriptsize (12 \lt x\le 15)[/latex] as the lower limit of the next interval.

In the frequency column we count the number of observations that fall into each interval and list it. Make sure that the sum of the frequency column is equal to the total number of observations.

Exercise 1.1

The following shows a sample of raw data collected on the number of customers entering a printing shop over a period of time.

[latex]\scriptsize 14[/latex] [latex]\scriptsize 14[/latex] [latex]\scriptsize 15[/latex] [latex]\scriptsize 24[/latex] [latex]\scriptsize 22[/latex] [latex]\scriptsize 26[/latex]
[latex]\scriptsize 20[/latex] [latex]\scriptsize 22[/latex] [latex]\scriptsize 14[/latex] [latex]\scriptsize 11[/latex] [latex]\scriptsize 13[/latex] [latex]\scriptsize 24[/latex]
[latex]\scriptsize 23[/latex] [latex]\scriptsize 11[/latex] [latex]\scriptsize 12[/latex] [latex]\scriptsize 12[/latex] [latex]\scriptsize 23[/latex] [latex]\scriptsize 16[/latex]
[latex]\scriptsize 12[/latex] [latex]\scriptsize 18[/latex] [latex]\scriptsize 20[/latex] [latex]\scriptsize 21[/latex] [latex]\scriptsize 20[/latex] [latex]\scriptsize 15[/latex]
[latex]\scriptsize 21[/latex] [latex]\scriptsize 16[/latex] [latex]\scriptsize 12[/latex] [latex]\scriptsize 23[/latex] [latex]\scriptsize 22[/latex] [latex]\scriptsize 14[/latex]
  1. Construct a frequency table for the data given.
  2. For how many days were customers observed?
  3. The shop owner is deciding if he should close the shop down. He will only stay open for business if he has [latex]\scriptsize 16[/latex] or more customers on [latex]\scriptsize 50\%[/latex] of days. Based on the frequency table, should he stay open or close down?

The full solutions are at the end of the unit.

Note

When you have an internet connection watch this video called “Frequency tables and dot plots” to learn more about frequency distributions.

Cumulative frequencies

Some graphs that represent data from a grouped frequency distribution need cumulative frequencies. Cumulative means to add up or collect values together.

You can think of cumulative frequency as the running total of frequencies in a frequency distribution. This means you are adding a value to all of the values that came before it.

To find the cumulative frequencies, add all the previous frequencies to the frequency for the current row, as shown in the Table 1.1.

Table 1.1 Cumulative frequency of ages

Age intervals Frequency Cumulative frequency
[latex]\scriptsize 9 \lt x\le 12[/latex] [latex]\scriptsize 5[/latex] [latex]\scriptsize 5[/latex]
[latex]\scriptsize 12 \lt x\le 15[/latex] [latex]\scriptsize 8[/latex] [latex]\scriptsize 5+8=13[/latex]
[latex]\scriptsize 15 \lt x\le 18[/latex] [latex]\scriptsize 12[/latex] [latex]\scriptsize 13+12=25[/latex]
[latex]\scriptsize 18 \lt x\le 21[/latex] [latex]\scriptsize 9[/latex] [latex]\scriptsize 25+9=34[/latex]
[latex]\scriptsize 21 \lt x\le 24[/latex] [latex]\scriptsize 7[/latex] [latex]\scriptsize 34+7=41[/latex]
[latex]\scriptsize 24 \lt x\le 27[/latex] [latex]\scriptsize 6[/latex] [latex]\scriptsize 41+6=47[/latex]
[latex]\scriptsize 27 \lt x\le 30[/latex] [latex]\scriptsize 1[/latex] [latex]\scriptsize 47+1=48[/latex]
Total [latex]\scriptsize 48[/latex]

The last value in the cumulative frequency column will always be equal to the total sum of all observations, since the sum of all frequencies will already have been added to the previous total.

Cumulative frequency graphs are often used to represent and compare data. You will see more of this in unit 2 of this subject outcome.

Summary

In this unit you have learnt the following:

  • How to group data using frequencies.
  • How to construct a frequency distribution.
  • How to create equal class intervals for a frequency distribution.

Unit 1: Assessment

Suggested time to complete: 20 minutes

  1. The maths marks, out of [latex]\scriptsize \displaystyle 50[/latex], for [latex]\scriptsize \displaystyle 35[/latex] learners are given below:
    .
    [latex]\scriptsize \displaystyle \begin{align*}&46;\text{ }40;\text{ }12;\text{ }10;\text{ }47;\text{ }23;\text{ }26;\text{ }8;\text{ }29;\text{ }34;\text{ }37;\text{ }17;\text{ }40;\text{ }50;\text{ }18;\text{ }23;\text{ }33;\text{ }\\&23;\text{ }24;\text{ }15;\text{ }35;\text{ }23;\text{ }19;\text{ }22;\text{ }28;\text{ }35;\text{ }27;\text{ }42;\text{ }29;\text{ }26;\text{ }46;\text{ }33;\text{ }27;\text{ }19;\text{ }28\end{align*}[/latex]
    .
    Organise the data by using a frequency table.
  2. The frequency table shows the test marks for a statistics course. Find the missing values.
    Test score intervals Frequency Cumulative frequency
    [latex]\scriptsize 49.5 \lt x\le 59.5[/latex] [latex]\scriptsize 5[/latex] A
    [latex]\scriptsize 59.5 \lt x\le 69.5[/latex] [latex]\scriptsize 10[/latex] [latex]\scriptsize 15[/latex]
    [latex]\scriptsize 69.5 \lt x\le 79.5[/latex] B [latex]\scriptsize 45[/latex]
    [latex]\scriptsize 79.5 \lt x\le 89.5[/latex] [latex]\scriptsize 40[/latex] [latex]\scriptsize 85[/latex]
    [latex]\scriptsize 89.5 \lt x\le 99.5[/latex] [latex]\scriptsize 15[/latex] C

The full solutions are at the end of the unit.

Unit 1: Solutions

Exercise 1.1

  1. .
    Intervals for the number of customers Frequency
    [latex]\scriptsize 10-15[/latex] [latex]\scriptsize 13[/latex]
    [latex]\scriptsize 16-21[/latex] [latex]\scriptsize 8[/latex]
    [latex]\scriptsize 22-27[/latex] [latex]\scriptsize 9[/latex]
  2. [latex]\scriptsize 30\text{ days}[/latex]
  3. He has [latex]\scriptsize 16[/latex] or more customers on [latex]\scriptsize 17[/latex] days, which is more than [latex]\scriptsize 50\%[/latex] of the total number of days observed so he should not close his shop down.

Back to Exercise 1.1

Unit 1: Assessment

  1. .
    Score intervals Frequency
    [latex]\scriptsize 0-10[/latex] [latex]\scriptsize 2[/latex]
    [latex]\scriptsize 11-20[/latex] [latex]\scriptsize 6[/latex]
    [latex]\scriptsize 21-30[/latex] [latex]\scriptsize 14[/latex]
    [latex]\scriptsize 31-40[/latex] [latex]\scriptsize 8[/latex]
    [latex]\scriptsize 41-50[/latex] [latex]\scriptsize 5[/latex]
  2. .
    Test score intervals Frequency Cumulative frequency
    [latex]\scriptsize 49.5 \lt x\le 59.5[/latex] [latex]\scriptsize 5[/latex] [latex]\scriptsize \text{A}=5[/latex]
    [latex]\scriptsize 59.5 \lt x\le 69.5[/latex] [latex]\scriptsize 10[/latex] [latex]\scriptsize 15[/latex]
    [latex]\scriptsize 69.5 \lt x\le 79.5[/latex] [latex]\scriptsize \text{B}=45-15=30[/latex] [latex]\scriptsize 45[/latex]
    [latex]\scriptsize 79.5 \lt x\le 89.5[/latex] [latex]\scriptsize 40[/latex] [latex]\scriptsize 85[/latex]
    [latex]\scriptsize 89.5 \lt x\le 99.5[/latex] [latex]\scriptsize 15[/latex] [latex]\scriptsize \text{C}=100[/latex]

Back to Unit 1: Assessment

License

Icon for the Creative Commons Attribution 4.0 International License

National Curriculum (Vocational) Mathematics Level 3 by Natashia Bearam-Edmunds is licensed under a Creative Commons Attribution 4.0 International License, except where otherwise noted.

Share This Book