Education Services home page > CensusAtSchool home page > Year 10 Resources
CaSQ 24C - Using a Trend Line to find a Relationship Between Height and Foot Length
You can download this activity as a rich text file (RTF) using the link at the bottom of the page.
|How to: Get a Random Sample from CensusAtSchool|
Go to the CensusAtSchool Random Sampler to download a sample.
Reference year: (Select year) Sample size: At least 30 students
Select questions: Height, Foot length
Location: Select location Year level: (Select a range of year levels)
To protect privacy there is a rule built into the sampler that the requested sample size cannot exceed 10% of the respondents for the parameters entered.
From CasQ 24A and CaSQ 24B you are going to use a scatter plot and trend line to test Tilly’s assertion that a person’s height is 7 times their foot length.
Creating a scatter plot in Excel 2007
Creating a trend line
8. Use the mean found in question 7 to answer how many times greater a person’s height is than their foot length.
9. Find the foot length of 3 people in your class. Use your result to estimate their height.
10. Find the height of three different people and use your result to estimate their foot length.
11. Write a report of your investigation including:
- how accurate you think your result is,
- what factors may affect the accuracy of your result,
- whether a trend line is a useful tool for making predictions, and
- a discussion of how you could obtain a result that more accurately described the relationship between height and foot length for a particular sample of people.
Download the full activity:
This page last updated 12 November 2013