Graphing Exercises
Exercise
|
You need to know how to draw column graphs using Excel. If you don’t, go to Column Graphs. Use chartwizard to display the data from the table below in a column graph.
|
Tally Charts
Often data is not arranged in tables for us to input directly into the computer. Data of this type is often called raw data.
We wish to show how common each of the five vowels (a, e, i, o, u) are. Below is a short phrase from which we wish to display the numbers of each vowel.
Mares eat oats and does eat oats and little lambs eat ivy. A kid’ll eat ivy too, wouldn’t you?
What is the most common vowel used?
A tally chart may help to arrange this data and answer this question.
Copy the following tally chart and complete it by filling in the missing values.
|
vowel |
tally |
frequency |
|
a |
lllllllllll |
11 |
|
e |
lllllll |
7 |
|
i |
llll |
4 |
|
o |
lllllll |
7 |
|
u |
ll |
2 |
|
|
|
31 |
On your spreadsheet enter the above data (without the tally column) and draw a column graph that shows the frequencies of each letter.
When you get to step 1 choose a Chart sub-type and click on the button which says Press and Hold to View Sample. You will see your graph drawn. Choose another format. Try each of the formats possible before deciding on which you would prefer for your graph.
Exercise
|
Use a tally chart to organise each of the following sets of data, then use chartwizard to display the data in a column graph. Remember to vary your graph formats.
|
From the following data draw a pie graph to show the modes of transport used by pupils travelling to school. A tally chart will help you to organise this.
|
walk |
car |
bus |
bike |
bike |
walk |
bus |
|
bike |
walk |
bike |
bike |
walk |
walk |
bike |
|
bus |
bike |
walk |
car |
bike |
bus |
walk |
|
walk |
bus |
car |
walk |
bus |
bike |
car |
|
bike |
walk |
bike |
walk |
car |
car |
walk |
When you get to step 1 try each of the formats possible before deciding on which you would prefer for your graph.
-
Manu sells tickets to the school ball. On Monday she sells 6 tickets, Tuesday and Thursday she sells 4, Wednesday none, Friday 7, Saturday 5, and Sunday 2.
Use chartwizard to draw a column graph of this data. Display the numbers sold each day on the bars of the chart. -
Augustus’ family is trying to budget so that it is clear where savings could be made. The following is the average weekly spending for the family rounded to the nearest dollar.
Telephone $26 Electricity $21
Rent $250 car running $40
Food $150
Augustus brings home $520 per week. Use chartwizard to draw a pie chart showing the weekly spending.
Comment on the following:
How much could be set aside for savings.
How much this would be over a year.
What other expenses could use up these savings.
How the family could increase its savings
-
The following are the monthly sales from a second hand car yard. The numbers are how many cars were sold each month.
|
January |
16 |
February |
24 |
|
March |
22 |
April |
26 |
|
May |
27 |
June |
31 |
|
July |
30 |
August |
29 |
Use chartwizard to draw a line graph that displays these sales.
Describe in words how you see this yards’ car sales. What would you predict as sales for the following month?
Draw a line of best fit through the points and extend your graph for space to plot the September to December data.
What does the line of best fit indicate?
Does this agree with your prediction above?
Is the number of cars sold by a car yard a good indication of how well it is doing? What other factors are involved?
