Australian Bureau of Statistics

Rate the ABS website
ABS Home
ABS @ Facebook ABS @ Twitter ABS RSS ABS Email notification service
CensusAtSchool Australia

Education Services home page > CensusAtSchool home page > Year 10 Resources


Back to CensusAtSchool home page 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:

Commonwealth of Australia 2008

Unless otherwise noted, content on this website is licensed under a Creative Commons Attribution 2.5 Australia Licence together with any terms, conditions and exclusions as set out in the website Copyright notice. For permission to do anything beyond the scope of this licence and copyright terms contact us.