Boxplots in Excel
Library Home || Full Table of Contents || Library Help
|Neville Hunt, Coventry University|
|A method for using Microsoft Excel to create boxplots, or box and whisker diagrams, which provide a simple graphical summary of a set of data. Boxplots show a measures of central location (the median), two measures of dispersion (the range and inter-quartile range), the skewness (from the orientation of the median relative to the quartiles) and potential outliers (marked individually). Adapted from Hunt's article The Spreadsheet User.|
|Levels:||Middle School (6-8), High School (9-12), College|
|Resource Types:||Manuals/How-To's, Topic Tools Miscellaneous|
|Math Topics:||Graphing of Data|
© 1994- The Math Forum at NCTM. All rights reserved.