CensusAtSchool home page > Mathematics - Quick C@S Activities
 CaSQ 35C – Creating a Box and Whisker Plot using Excel
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 40 students
Select questions: 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. |
This task builds on skills developed in CaSQ 35A and CaSQ 35B. In CaSQ 35B you would have developed a parallel box and whisker plot using scatter plot in Excel.
Task:
1. Download a random sample of 100 foot lengths in Excel.
Note: You can or use all data or sort and use either Male or Female data for this activity.
2. Calculate the 5 figure summary statistics for your data.
3. Develop a set of ordered pairs that will allow a box and whisker plot to be drawn with the minimum number of lines.
Note: there are 5 vertical and 4 horizontal lines in a single box and whisker plot. Can you construct a box and whisker using fewer than 9 lines?
4. Comment on the distribution.
Extension:
5. What is the minimum number of lines needed to draw the plot? How do you know?
| Download the full activity: |
 |
To provide any feedback regarding this activity, please contact ABS Education Services on 1800 623 273 or email education@abs.gov.au.
Back to activities list for Mathematics Quick Activities.
|
This page last updated 20 February 2013 | 
