topic badge

5.02 Frequency tables and column graphs

Lesson

In the world of data, we are often interested in the number of times, or frequency, that something occurs. It could be the number of road accidents caused by drink driving, the number of hot days in a year, or the number of visits to a website in a month.

In situations like these, where the same data value can occur multiple times, the data can be organised into a a frequency table

 

Categorical data example

As an example, let's say the colour of every car that passed though a given intersection was recorded over a ten minute period:

green, white, yellow, white, black, green, black, blue, blue, silver, white, black, green, blue, blue, white, black, silver, silver, red, red, red, black, white, blue, white, black, silver, silver, white, blue, white, black, yellow, blue, white, white, red, green, silver, black, white, black, white.

We can see that the same colours are occurring multiple times, so it makes sense to organise the data using a frequency table. 

Vehicle colour Tally Frequency
Black |||| |||| $9$9
White |||| |||| || $12$12
Blue |||| || $7$7
Green |||| $4$4
Silver |||| | $6$6
Yellow || $2$2
Red |||| $4$4

Notice that the frequency table has three columns:

  • The first column shows the subgroups within the data
  • The tally column (optional) uses tally marks to record the frequency of each subgroup 
  • The final column sums the tally marks and records the frequency as a number 

The sum of the frequencies is equal to the total number of data values. In this case, the colours of $44$44 vehicles were recorded. 

The graph on the right is a column graph. Column graphs are well suited for displaying frequency data for both categorical and discrete numerical data. The table and graph allow us to analyse the frequency distribution - how the frequency of outcomes is spread across the different categories.

Use the following applet to create your own column graph for the data:

 

Remember!

For creating column graphs:

  • Title the graph clearly
  • Label each axis
  • Label each category and give the vertical axis a clear scale
  • Make sure the columns are equal widths and equally spaced
  • Make sure that the height of the column matches the value it represents which is often the frequency of the category (how often that outcome occurred) or relative frequency (the percentage of how often that outcome occurred)

Numerical data example

When displaying discrete numerical data we still use column graphs to display frequency distributions. For continuous numerical data we will use a similar graph called a histogram. We will look in more detail at histograms later on. Below are some examples and a brief description of their differences.

Column graphs Histograms

  • Column graphs are used for displaying categorical or discrete numerical data.
  • Gaps are shown between column for categorical data to show separate categories.
  • Gaps are often also used for discrete numerical data to emphasise that the values are discrete but are not required.
  • Labels go underneath each column
  • Histograms are used to display continuous numerical data.
  • No gaps between columns
  • The axis forms a continuous number line and the scale indicates the boundary values of each group

 

Practice questions

Question 1

Mr. Rodriguez recorded the number of pets owned by each of the students in his class. He found that $15$15 people had no pets, $19$19 people had one pet, $3$3 people had two pets and $8$8 people had three pets.

Write Mr. Rodriguez's results in the frequency table below.

  1. Number of Pets Frequency
    $0$0 $\editable{}$
    $1$1 $\editable{}$
    $2$2 $\editable{}$
    $3$3 $\editable{}$

Question 2

In a survey, $20$20 people were asked how many languages they spoke. Here are their answers:

$1,1,1,2,3,2,3,1,1,1,2,2,1,1,1,3,1,1,1,1$1,1,1,2,3,2,3,1,1,1,2,2,1,1,1,3,1,1,1,1

  1. Count how many people said $1$1, $2$2 or $3$3 languages and record the results in the table.

    Number of Languages Number of People
    1 $\editable{}$
    2 $\editable{}$
    3 $\editable{}$
  2. Draw a column graph to show the information in the table.

    Number of Languages SpokenNumber of LanguagesNumber of People51015123

Question 3

Use the given column graph to complete the frequency table.

Score ClassFrequency5101-56-1011-1516-2021-2526-3031-35

  1. Score $(x)$(x) Frequency $(f)$(f)
    $1-5$15 $\editable{}$
    $6-10$610 $\editable{}$
    $11-15$1115 $\editable{}$
    $16-20$1620 $\editable{}$
    $21-25$2125 $\editable{}$
    $26-30$2630 $\editable{}$
    $31-35$3135 $\editable{}$

Outcomes

1.2.2.1

display categorical data in tables and column graphs

What is Mathspace

About Mathspace