Text-only    Bypass Navigation
Biology4all Logo and Link to Home Page
 

 
Title: Statistics - Box Plots in Excel
Deposited By: Derek Christie, Department of Science and Technology, Waikato Institute of Technology, Hamilton, Aotearoa - New Zealand
Date Deposited: 18 April 2004
Description: Box plots are a simple but effective method of showing the distribution of a single set of data or of comparing several sets of related data simultaneously. A typical box plot might show the distribution of heights of corn seedlings grown under three different sets of conditions. While Microsoft Excel is an excellent way of storing, summarising and graphing data, its range of graphs unfortunately does not include box plots. This Excel spreadsheet automatically draws side by side box plots for up to 25 sets of related data with appropriate category and axis labels, ready for copying into another document.
Download: MS Excel Spreadsheet (36 KB)
License: View Creative Commons Attribution-ShareAlike license
This work is licensed under a Creative Commons License.  
Rated: Rating of 3.7/5 by 42  users
spacer image
How do YOU rate this resource ?
 
One Star Two Stars Three Stars Four Stars Five Stars  
Disappointing OK Good Impressive Exceptional