Ideas for Extension |
The following ideas for extending this topic require the full version of Autograph. |
|
Baby Weight Data.xls |
|
We will be using the above data set for the next three activities. It gives data about babies and their mothers, and also includes information about if the mother smoked or not. I have split the data into separate worksheets for Smokers and Non-Smokers (click on the tabs at the bottom), or you can use the filters on the first worksheet. |
|
To import data from Excel into Autograph, follow these steps: |
|
• |
Select and copy the column you want (it does not matter if it has a header). |
• |
Open a new Statistics page. |
• |
Click on Raw Data and paste the data into the appropriate cells. |
• |
Or click on Grouped Data, click on Use Raw Data, Edit and then paste the data as above. |
• |
Top Tip: If your data has commas in it, these will need to be removed before you import it. Just select the cells, right-click and choose Format Cells, Number and remove the tick by Use 1000 separator. |
|
Idea 1 – Cumulative Frequency Diagrams |
Download 1. Cumulative Frequency.agg |
|
The Autograph page shows a cumulative frequency diagram of the birth weights of babies from non-smoking mothers. |
|
• |
Use the C.F.D Measure tool to get an estimate for the median and quartiles. |
• |
How will the cumulative frequency diagram for the Smokers differ? Select the birth weight column for the Smokers and paste it in as Grouped Data as described above or in the video below. |
• |
Select the new data set from the key at the bottom of the page, create a cumulative frequency diagram and calculate the median and quartiles. |
• |
How do they differ? |
• |
Can you explain this? |
• |
What would the two box plots look like? |
• |
Use the Scribble Tool to mark on your students’ predictions. |
• |
Select the Data set and then click on Box Plot to find out! |
• |
Investigate Cumulative Frequency Diagrams and Box Plots for some of the other columns of data. |
|
Idea 2 – Frequency Diagrams/Histograms |
Download 2. Histograms.agg |
|
The Autograph page shows a frequency diagram of the gestation period (in days) of babies from non-smoking mothers. |
|
• |
Which group contained the most people, and approximately how many were in this group? |
• |
Use the Animation Controller to adjust the group sizes until you find one you are happy with. |
• |
Select the gestation period column for the Smokers and paste it in as Grouped Data as described above or in the video below. |
• |
Select the new data set from the key at the bottom of the page and create a Histogram |
• |
How do they differ? |
• |
Double-click on your new frequency diagram and choose Plot Down. |
• |
Edit the y-axis so it has a minimum value of −400. |
• |
What would the diagrams look like if we used Frequency Density instead of Frequency? Double-click on them and select Frequency Density to find out! |
• |
Investigate Frequency Diagrams and Histograms for other columns of data. |
• |
Experiment by changing the group widths so they are not uniform (see the video). |
|
Idea 3 – Scatter Diagrams |
Download 3. Scatter Diagram.agg |
|
What is the relationship between a mother’s weight and the weight of their babies? |
|
• |
Will it be positive or negative correlation? Strong or weak? |
• |
Select and copy the Birth Weight column, and paste it into the x column of the Enter XY Data Set. |
• |
Repeat for Mother Weight (kg) in the y column and click OK. |
• |
Click Default Scales to make your graph look a bit nicer. |
• |
You may need to drag the page into a better position. |
• |
Does the relationship match your predictions? |
• |
Scribble on your estimate for the line of best fit. |
• |
To check your answer, make sure the dots are selected, right-click and choose Line of Best Fit from the menu. |
• |
Investigate how the relationship changes if you separate Smokers and Non-Smokers. |
|