## Take a guess!

This might sound like a strange first direction for a math course, but let’s see where it leads.

Estimate how many jelly beans are in the jar?

Estimate how many ways you can throw these dice to equal seven?

### Think

How might you estimate your monthly income, when your income changes every month?

Your Monthly Income
Month Income
April $800 May$1105
June $900 July$1000

When you don’t know all the information, you sometimes have to rely on estimates based on what you do know. Continue in this learning activity to learn how to make better estimates using graphs.

### Estimation

Estimates can be used to get an approximate (or close) value without having to use a calculator. For example, if your hourly wage is $11.07 and you want to know how much you’ll earn if you work 10 hours, you can estimate the answer. The amount$11.07 is very close to $11.00. To find the approximate amount you would earn, multiply$11.00 by 10 hours:

$11×10=110$

If you work 10 hours at $11.07 per hour, you’d earn about$110.00.

Estimates are often used by businesses. If you’re going to have the windows replaced in your house, you want an idea of what it will cost before the work begins. The window company will look at the number and type of windows that need to be replaced. They’ll estimate how much time it will take to do the work and then give you an estimate of the total cost. The final bill won’t be exactly the same as the estimate, but it should be close.

Estimates are also used for reading graphs.

### Estimation Using a Graph

Graphs are designed to display trends and to give a general picture of a situation. They are not intended to give exact information. To read both column and line graphs you’ll need to learn how to estimate. When you read a graph, you get an approximate value. To get the exact value, you need to read the original data. The following scenario will help you learn to estimate using a graph.

#### Sean's income

Sean has been working for four months. He doesn’t work the same number of hours each month, so his monthly income changes. Sean recorded his monthly income for each month in a table. He created a graph to compare the income for each month to help him make a monthly budget.

Look at the following table and graph:

Sean’s Monthly Income
Month Income
April $800 May$1105
June $900 July$1000

Select the tabs to review how to read a graph.

#### Horizontal Axis

The line across the bottom of the graph is the horizontal axis.

#### Vertical Axis

The line going up and down on the left of the graph is the vertical axis. The numbers on the vertical axis indicate the scale and allow you to estimate the amount of the monthly income.

#### Labels

Each axis has a label to indicate what the categories and numbers represent.

#### Gridlines

The horizontal lines on the graph are guidelines to help you estimate the monthly income.

#### Reading a graph

Notice that the column above the month of April reaches the line that connects to 800 on the vertical axis, so the income for April is $800. Similarly, the column above the month of July reaches the line that connects to 1000 on the vertical axis, so the income for July is$1000.

Again, this is the same as the amount given in the table.

#### Estimating

It’s more difficult to determine the income for May and June accurately from the graph. You can see that the column above the month of May is about halfway between 1000 and 1200 and the column above the month of June is about halfway between 800 and 1000.

It would be reasonable to estimate that the income for May is $1100 and the income for June is$900.

#### Estimating with gridlines

Look at the following graph:

Horizontal lines have been added halfway between the original lines. You can now see that the column above the month of June reaches the horizontal line at 900, so the income for June is $900. This is the same as the amount given in the table. The column showing the month of May is a little above the line at 1100. This means the income for May is a little more than$1100. You can see from the table that the income for May is $1105, but it isn’t possible to be that precise when you read the graph. If you estimate the monthly income for May from the original graph, an answer anywhere between about$1100 and $1110 would be acceptable. ### Try It! #### Your turn: Here is the graph of Sean’s income for the next four months. Estimate his income for each of the four months. The actual amounts are available for viewing once you enter the estimation. Estimated Income for August: Estimated Income for September: Estimated Income for October: Estimated Income for November: Graphs can be very helpful. They can show you the direction and speed of a trend or provide a big picture of a complex situation, such as how quickly the price of a litre of gas is increasing or how your total expenses are being distributed among the different categories such as rent, food, and so on. Scroll through the examples of graphs provided and think about what information is being communicated in each one. In this activity, you’ll learn to read, interpret, and create column (or bar) graphs, circle (or pie) graphs, and line graphs so that you can better understand the information or data displayed in the graph. If you look at the business and sports sections of a news website or newspaper, you’ll see examples of tables and graphs. There are many different types of graphs commonly used. ### Types of graphs Data can be displayed on different types of graphs. Each type of graph is used for a specific purpose. First let’s look at the different types and then we can discuss which graph to use for which type of data. Circle graphs are sometimes called pie graphs. As you will see in the following example, the name fits because the graph resembles a pie that has been cut into pieces. In most cases, the pieces in a pie graph aren’t equal in size. If the slice of pie is large, then the value it represents is a large portion of the total. If the slice of pie is small, then the value it represents is a small portion of the total. It’s easiest to understand by looking at an example. #### Example Karla has created a circle graph for her monthly expenses. You can see very clearly from the graph that the largest portion of Karla’s expenses goes to rent. This is the largest piece of the pie. You can also read the percentage beside each category. The circle graph allows you to see quickly what portion of the total budget each category represents. Your turn Use the circle graph of Karla’s monthly budget to answer the following questions. Compare your thinking with the suggested answers. a) On what categories does Karla spend the least? b) What percentage of her expenses does Karla spend on transportation? c) Given that Karla’s total expenses are$1365 per month, how much does she spend on food each month?

You will be creating spreadsheets later in this activity. The examples provided have been created in Microsoft Excel. In Excel, a graph that has vertical bars (bars that go up and down) is called a column graph, and a graph that has horizontal bars (bars that go left to right) is called a bar graph. To avoid confusion, graphs with the bars going up and down will be referred to as column graphs throughout this unit. You should be aware that some other sources refer to these graphs as bar graphs.

#### Example

The following column graph displays the total monthly expenses for some household budgets. The categories on the horizontal axis tell you the name of the family or individual. The scale on the vertical axis is used to estimate the monthly expenses.

It is easy to compare the amounts that each family spends. The tallest column represents the largest amount. The shortest column represents the lowest amount.

Your turn

Input the answers to the following questions. Compare your thinking with the suggested answers.

a) Which family has the highest expenses?

b) Which family has the lowest expenses?

c) Use the graph to estimate the Noll family’s monthly expenses.

The structure of a line graph is similar to a column graph. There is a horizontal axis and a vertical axis. Instead of constructing a column above the horizontal axis, a point is plotted. The points are connected from left to right.

A line graph is most frequently used to illustrate how something is changing over time. You could use a line graph to record the height of a child each year or to track your monthly expenses.

#### Example

The following line graph shows how the value of a car changes from the day it was purchased. The horizontal axis represents the number of years since the purchase and the vertical axis represents the value of the car.

You can easily see that the value of the car goes down as time passes. Line graphs help to identify trends. This means that you can see whether the overall pattern is an increase in value or a decrease in value. The line graph is sometimes not as smooth as this one. You can extend this graph and make a prediction about the value of the car after the last point plotted by following the trend. You’d have to make the assumption that the conditions that existed in the first five years will continue. For example, if the owner has an accident with the car, or for some reason people no longer wanted to purchase that particular type of car, the car would lose value more quickly than before.

Your turn

Input the answers to the following questions. Suggested answers are available.

a) What was the value of the car when it was purchased?

b) Estimate the value of the car two years after it was purchased.

c) Estimate the value of the car six years after it was purchased?

d) What assumptions did you make in answering part c)?

### Which graph to use?

When you need to decide what type of graph will best display the data, consider the following:

 Circle or pie graphs allow you easily to see what portion of the total each item represents Column or bar graphs allow you easily to compare one item to another. Line graphs allow you to track changes over time and determine general trends.

A well-made graph can be very handy when you need to inform someone about or convince someone of the facts. There will be times when you, or your employer, need to communicate data quickly and persuasively with a graph. Have you ever wondered how professional-looking graphs are created? Now it’s time for you to learn how to create your own.

### Constructing graphs using technology

Graphs can be made with several different software programs. You’ll be using Microsoft Excel or a comparable spreadsheet program in this course. Please note that the examples in this course use a dated version of Microsoft Excel. Most of the spreadsheet programs have similar features, so once you’ve learned one program you should be able to adapt to other programs.

The first step is to collect your data. You need to have the data organized in a table before you can create the graph. The table must be organized into one or two columns of numbers. The data can then be entered in a spreadsheet to create the graph.

### Creating circle graphs

In the examples that follow, you’ll learn how to create a circle graph, a column graph, a line graph, and a special kind of line graph that is referred to as an XY (Scatter) graph in the Excel program. A line graph and XY (Scatter) graph look almost the same. Whether you should choose the line graph or the XY (Scatter) graph will depend on the situation:

• Use a line graph if the data in the first column of the table are words and you have only one column of numbers. This is called one-variable data.
• Use an XY (Scatter) graph if the data contains two columns of numbers. This is called two-variable data.

Before creating the graph, you need to think about which type of graph best displays the particular set of data that you are working with. In the examples that follow, you’ll consider which is the best type of graph and then learn to use Excel to create the graph.

##### Example

The following table shows the results of a survey about music. People were asked to indicate which type of music they preferred. You want to create a circle graph to show what portion of the total each type of music represents.

Music Survey
Type of music Frequency
Hip Hop 20
Metal 70
Rap 50
Pop 100
Alternative 120
Other 60

#### Step 1

Open the program Microsoft Excel. Enter the data into the spreadsheet. You do not need to include the headings at this time. It is much easier and less confusing to enter these later.

#### Step 2

Select the data by clicking and dragging the mouse so that the cells containing the data are highlighted.

#### Step 3

From the toolbar at the top, select Insert and chart.

#### Step 4

You can also click on the chart icon on the toolbar.

#### Step 5

Select Pie since you want to create a circle graph. Select the one in the upper left hand corner.

Click next.

#### Step 7

There are two tabs that say Data Range and Series. The default settings are fine for most purposes so click next.

#### Step 8

You’ll see a toolbar with titles, legend and data labels. These selections allow you to customize your graph.

#### Step 9

Select titles and enter Music Survey.

#### Step 10

Select legend and de-select show legend. This removes the key that shows the categories on the page with the graph. You may want to include it on your pie graphs if you print them in colour.

#### Step 11

Click data labels and select category name and percentage.

#### Step 12

Click next and finish.

You can make the graph bigger by clicking on a corner and dragging it out. You can copy and paste the graph into a word document or print the graph once you have completed it.

### Creating column graphs

A column graph is used to compare things. For example, you could use a column graph to compare the number of goals that were scored in a season by some of the players in the National Hockey League or to compare the number of people that preferred certain movies in a survey.

#### Example

The following table shows the results of a survey on the favourite hockey team of people in Toronto. You want to create a column graph to compare the popularity of the teams.

Toronto Survey of Hockey Teams
Team Number of people
Calgary 100
Edmonton 120
Montreal 400
Ottawa 50
Toronto 600
Vancouver 100

#### Step 1

Open the program Microsoft Excel. Enter the data into the cells. Remember you don’t need to enter the titles.

#### Step 2

Select the data in the cells.

#### Step 3

Open the chart wizard by selecting insert, then chart or by clicking the chart icon on the toolbar. Since you want to compare the popularity of the teams, select column.

#### Step 4

There are different types of graphs available. Choose the default graph in the upper left-hand corner. Click next.

#### Step 5

You’ll see tabs labelled data range and series. The default settings are fine. Click next. Select titles.

#### Step 6

Under chart title enter Toronto Survey of Hockey Teams.

#### Step 7

Under category (X) title enter Team.

#### Step 9

Under Value (Y) title, enter Number of People.

#### Step 10

Select the legend tab and de-select show legend.

#### Step 11

Select next and then finish.

You can copy and past the graph into a word document or print the graph.

### Creating line graphs

As you may recall, a line graph is most frequently used to illustrate how something is changing over time.

This particular example will walk you through the creation of a line graph. Let’s get started.

#### Example

The following table shows the average monthly temperature for a town in Ontario. You want to create a line graph to show the temperature changes as the year progresses.

Town in Ontario
Month Average temperature (°C)
January –10
February –5
March 0
April 10
May 15
June 22
July 25
August 25
September 17
October 12
November 8
December –4

#### Step 1

Open Microsoft Excel. Enter the data into the cells. You can use the first letter of each month instead of entering the entire month name.

Select the data. Open the chart wizard by using the insert tab or the icon on the toolbar.

#### Step 2

A line graph should be used to display this data since you want to see the temperature change as the year progresses and the data in the first column are words. Select line. Use the default setting. This is the one in the middle row on the left. Click next.

#### Step 3

There are two tabs labelled Data Range and Series. The default setting is fine. Click next.

#### Step 4

Select the Titles tab. Under the chart title enter Town in Ontario.

#### Step 5

Under Category (x) title enter Month.

#### Step 6

Under value (Y) axis enter Average Temperature (Degrees Celsius).

#### Step 7

Select next and finish.

You can copy and paste the graph into a word document or print the graph.

### Check your understanding

Here are some questions for you to try on paper. Complete the questions first and then compare your work with the suggestions provided. Review the solutions to ensure you are following the correct format. These questions will be similar to those on the assessment at the end of this unit.

1. The following graph represents the results on a survey done before a nationally televised reality talent show. The contestants were all winners from previous shows. Viewers were asked which of the contestants they would vote for.

a) Who appears most likely to win the talent show?

b) Who appears least likely to win the talent show?

c) What percentage of the people surveyed indicated they would vote for Luke?

d) There were 200 viewers surveyed. How many indicated that they would vote for Kim?

2. The following column graph shows the number of goals scored in one season by 10 players on a hockey team.

a) Who scored the most goals?

b) Who scored the fewest goals?

c) Estimate the number of goals John scored.

d) How many more goals did Carl score than Jim?

3. The following graph contains information about Jason’s annual income for a period of eight years.

a) What was Jason’s annual income in year 5?

b) In what years was Jason’s income lowest?

c) What is the overall trend (that is, is Jason’s income increasing or decreasing?) How can you tell?

d) From year 1 to year 2, Jason’s income went down. During what other time did his income go down?

e) Estimate what Jason’s annual income was in year 4.

f) Estimate what Jason’s annual income will likely be in year 9. What assumption did you make?

4. Create the indicated type of graph for each of the following sets of data:

a) The results of the number of seats won in an election are provided in the following table. Display the data using a column graph.

Election Results
Party Number of Seats
Green 1
Liberal 60
NDP 10
PC 36

b) People in a small town were asked to identify their first language. The results of the survey are provided in the following table. Display the data using a circle graph.

First Language
Language Frequency
English 200
French 150
Italian 50
Cantonese 30
Other 75

c) A gas station recorded the average cost of a litre of regular gasoline. Graph the data in the table using a line graph (XY Scatter).

Average Cost of 1 Litre of Gasoline
Year Cost (in cents)
1970 55
1975 53
1980 62
1985 85
1990 75
1995 68
2000 70
2005 92
2010 62
2015 109

### Conclusion

Good work! You have completed Learning Activity 1. You have worked through all the examples and had several opportunities to check your understanding along the way. You should feel comfortable

• Reading and interpreting graphs obtained from various sources,
• Representing categorical data by constructing graphs using a spreadsheet, and
• Making inferences based on the graphical representation of data and justifying conclusions in writing using convincing arguments.

Now that you’ve learned to read graphs and to create graphs of existing data using technology, you may be wondering how the data is collected. In Learning Activity 2, you’ll learn about different methods of data collection and you’ll be able to use your skills to graph the data that you’ll collect.