Education Services home page > CensusAtSchool home page > Year 10 Resources
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.
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.
5. What is the minimum number of lines needed to draw the plot? How do you know?
|Download the full activity: ||
This page last updated 12 November 2013