Australian Bureau of Statistics

Rate this page
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 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:

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.