Cambridge International Mathematics

Graphs, charts and tables (Chapter 5) 119

Many special computer programs are used to help us organise and graph data.

Click on the iconto run the statistical graphing software.

Change the data in the table and see the effect on the graph.

² Notice that the graph’s heading and the labels on the axes can be changed.

² The type of graph can be changed by clicking on the icon to give the type that you want.

Experiment with the package and use it whenever possible.

Discovery Spreadsheets for graphing data

#endboxedheading

Colour white red blue green other

Frequency 38 27 19 18 11

The colours of cars in a supermarket carpark are

recorded alongside. Suppose you want to draw a

frequency bar chart of this data.

The following steps using a computer spreadsheet enable you to do this quickly and easily.

Step 1: Start a new spreadsheet, type in the

table, and then highlight the area as

shown.

Step 2: Click on from the menu bar.

Step 3: Choose

This is probably already

highlighted. Click.

You should get: This demonstration takes

you through all the steps.

Colour white red blue green other

Frequency 1 38 27 19 18 11

Frequency 2 15 18 21 9 3

Now suppose the colours of cars in the

neighbouring car park were also recorded.

The results are summarised in the following

table.

Step 4: Into the C column type the

Frequency 2data and highlight

the three columns as shown.

C USING TECHNOLOGY TO GRAPH DATA [11.3]

STATISTICS

PACKAGE

DEMO

SPREADSHEET

IGCSE01

cyan magenta yellow black

(^05255075950525507595)
100 100
(^05255075950525507595)
100 100
Y:\HAESE\IGCSE01\IG01_05\119IGCSE01_05.CDR Tuesday, 4 November 2008 12:08:18 PM PETER