|
|
Books at Amazon.com
Peltier Tech
Buy me a coffee If this topic or the whole site has been helpful, please support further development by treating me to a cup of coffee. |
Box and Whisker Plots.
Box and Whisker charts are commonly used in the display of statistical analyses. Unfortunately, Microsoft Excel does not have a built in Box and Whisker chart type. You can create your own custom Box and Whisker charts, using stacked bar or column charts and error bars, in combination with line or XY scatter chart series to show additional data. Note: there are several different ways that box and whisker plots describe sample data. The charts described in these tutorials have boxes indicating the range of the second and third (inner) quartiles of the data, with error bars indicating the first and fourth (outer) quartiles. The whiskers may alternatively show a more rigorously defined upper control limit, and special markers may be used to indicate outliers beyond these. Any such alternatives are beyond the scope of this exercise. There are other web pages that show how to make Box and Whisker charts in Excel:
Vertical Box and Whisker Charts
This tutorial shows the procedures used to construct a vertical box and whisker plot. In this example, the boxes show medians and upper and lower quartiles of the data, while the whiskers indicate the minimum and maximum values. This tutorial also shows how to add another series representing the means of the data. Horizontal Box and Whisker Charts
This tutorial shows the procedures used to construct a horizontal box and whisker plot. In this example, the boxes show medians and upper and lower quartiles of the data, while the whiskers indicate the minimum and maximum values. This tutorial also shows how to add another series representing the means of the data. Example Box and Whisker ChartsBoxWhisker.zip is a zipped Excel workbook with examples of and step-by-step instructions for constructing vertically and horizontally oriented Box and Whisker plots. Box and Whisker Chart UtilityIn these pages I have described techniques for constructing box and whisker charts in Excel. I have also developed a commercial Box and Whisker Chart utility that allows the user to construct box and whisker charts directly from the data. The utility builds the intermediate summary table and then creates and formats the chart from this table. There is also a free demo version with fewer features. These utilities is designed to work in Excel versions 2000 through 2007. The Box and Whisker Chart dialog is shown below:
Read about the PTS Box and Whisker Chart Utility. |
Peltier Technical Services, Inc.Custom Solutions | Commercial Utilities | Training | Charts and Tutorials | PTS BlogPeltier Technical Services, Inc., Copyright © 2009. All rights reserved. |
