Title: Exploring Linear Function Models PowerPoint Instructions
1Exploring Linear Function ModelsPowerPoint
Instructions
Part 1 Getting the data Part 2 Modelling the
data Part 3 Creating your data story
2Part 1 Getting the data
3Open your web browser and type www.censusatschool.
ca
Click on Related sites
4Click on the United Kingdom link.
5Click on the Results and Data button.
6Click on the Random Data Selector button.
7Click on the Next Page link.
8Click on the Combined link.
9Click on the pull-down arrow and select Age 14.
Type in 100 records.
Type in your schools name.
Type in your name.
Type in your e-mail address.
Click on Submit Request.
10Here is a summary of the data that will be sent
to you via e-mail.
11Part 2 Modelling the data
12Use a spreadsheet program (such as QuattroPro or
Excel) to open the file.
13Click on Edit, then Select All.
14Click on Edit, then click on Copy.
15Open your statistics software program (such as
Fathom) and select New Collection.
16Left-click in your blank document and you will
see Collection 1.
17Click on Edit, then click on Paste Cases.
18Collection 1 now has data. Double-click on
Collection 1.
19Here, you can see that we have 19 attributes and
100 cases.
20Open up an Empty Plot.
21Grab onto the heightcm attribute.
22Drag the heightcm attribute over to the
horizontal axis of your empty plot and let go.
23You now have a dot plot where each dot represents
a person.
24Grab and drag the FootSizecm attribute over to
the vertical axis of your plot and let go.
25You now have a scatter plot, where each dot
represents a person.
26Click on Graph and select Movable Line.
27The brown line is the movable line that you can
fit to your data.
Note the equation of your movable line.
28Grab and rotate the bottom of your movable line.
29Grab and slide the middle of your movable line.
30Grab and rotate the top of your movable line.
31Click on Graph and select Least-Squares Line.
32The red line is your least-squares line.
Note the equation of your least-squares line.
33Double-click on any data point that looks
interesting to you. The Inspect Collection window
will show you all the information for that person.
34Click on Data and select Add Filter.
35The Edit Filter dialogue box appears. Filter out
boys by typing in Gender F. Click on OK.
36You now see only girl cases. Note the filter,
Gender F, at the bottom of the scatter plot
window.
37To filter out the girls, first double-click on
Gender F.
38Then type Gender M in the Edit Filter
dialogue box.
39You now see only boy cases. Note the filter,
Gender M, at the bottom of the scatter plot
window.
40Now, filter out all students except those from
the United Kingdom by typing Country UK in
the Edit Filter window.
41You now see only United Kingdom cases. Note the
filter, Country UK, at the bottom of the
scatter plot window.
42Now, filter out all but the South Africa cases.
43Now, filter out all but the Queensland
(Australia) cases.
44Part 3 Creating your data story
45To copy a data display, select it by clicking on
or inside it.
46Click on Edit and select Copy Picture.
47Now, open your presentation software. Click on
Edit and select Paste.
48Your data display image should now be in your
presentation software page, where you can resize
and reposition it.