Data Presentation - Tables

Tables are a useful way to organize information using rows and columns. Tables are a versatile organization tool and can be used to communicate information on their own, or they can be used to accompany another data representation type (like a graph). Tables support a variety of parameters and can be used to keep track of frequencies, variable associations, and more.

For example, given below are the weights of 20 students in grade 10: \[50, 45, 48, 39, 40, 48, 54, 50, 48, 48, \\ 50, 39, 41, 46, 44, 43, 54, 57, 60, 45.\]

To find the frequency of \(48\) in this data, count the number of times that \(48\) appears in the list. There are \(4\) students that have this weight.

The list above has information about the weight of \(20\) students, and since the data has been arranged haphazardly, it is difficult to classify the students properly.

To make the information more clear, tabulate the given data.

\[\begin \\ \text & & & \text \\ 39 & & & 2 \\ 40 & & & 1 \\ 41 & & & 1 \\ 43 & & & 1 \\ 44 & & & 1 \\ 45 & & & 2 \\ 46 & & & 1 \\ 48 & & & 4 \\ 50 & & & 3 \\ 54 & & & 2 \\ 57 & & & 1 \\ 60 & & & 1 \end\]

This table makes the data more easy to understand.

Contents

Making a Table

To make a table, first decide how many rows and columns are needed to clearly display the data. To do this, consider how many variables are included in the data set.

The following is an example of a table where there are two variables.

NameAge (years)
Jennifer15
Alex13
Paul38
Laura9

The following is an example of a table with three variables.

NameAge (years)Favorite Food
Jennifer15Pizza
Alex13Bananas
Paul38Steak
Laura9Watermelon

A table is good for organizing quantitative data in a way that it is easy to look things up. For example, a table would be good way to associate a person’s name, age, and favorite food. However, when trying to communicate relations, such as how a person’s favorite food changes over time, a graph would be a better choice.

23 21 25 17

Using the table below, determine the average age of the group?

NameAge (in years)
Robert15
Jane25
Steven23
Scott36
Lucy6

What is wrong with this table?

Flavor of Ice CreamNumber Sold (cones)
Chocolate104
Vanillatwo-hundred
Strawberry143
Coconutthirty
Mango126
Show answer

Answer: The data isn’t consistently formatted. The number of cones sold is written in numbers in both symbols and words. It would be easier to understand if all entries were numerical symbols.

What is wrong with this table?

Jackblue
Sarahyellow
Billygreen
Ronred
Christinablue
Margretpurple
Show answer

Answer: There are no labels on the columns. It is not clear what the table is displaying — does the table show what color shirt each person is wearing? Do it show what each person's favorite color is? It isn't clear because labels are missing.

Making and Using Tables

Many word processing softwares include tools for making tables. You can easily make tables in Microsoft Word and Excel and in Google Docs and Sheets.

Here is an example table (left blank) with which you could record information about a person's age, weight, and height.

Tables are used to present information in all types of fields. Geologists might make a table to record data about types of rocks they find while doing field work, political researchers might create a table to record information about potential voters, and physicists might make a table to record observations about the speed of a ball rolled on various surfaces.