|
Excel Books
| |
Books that I own and use while developing in Excel
|
|
Goods and Services
| |
Excel or charting related products and services which I use or feel are worthwhile additions
|
|
|
Excel Charts for Statistics.
|
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. The procedures in these tutorials have been updated to show how to add additional series (means of other populations, perhaps, or sets of target values). This page also links to a utility which can be used to generate Box and Whisker charts directly from population data. The Box Plot utility has recently been upgraded to provide more professional output, to correct treatment of outliers in horizontally oriented charts, to run tenfold faster, and to fix a few small bugs. The utility was previously updated to provide additional chart styles, and to correct problems experienced by some non-US users.
I have developed a Box and Whisker Chart Utility that allows the user to construct box and whisker charts directly from the raw data. The utility builds the intermediate summary table and then creates and formats the chart from this table. The utility is designed to work in Excel versions 2000 through 2007. There is a professional version with an extensive feature list, and a free demo version which makes simple box plots.
Top of Page
|
|
Microsoft Excel does not offer a built in capability to chart probability data, but the technique described here allows you to simulate a probability scale along a chart axis.
Top of Page
|
|
A histogram is a column chart which shows the distribution of a population's values over the range of values. This page examines a few ways to generate histograms in Excel.
Top of Page
|
|
Suppose you want to chart the relative frequency of numbers in a list. Suppose further that instead of a bland column chart, you want to put an X in the histogram for every occurrence of a value. You can do this with a scatter chart, using a procedure offered by Excel MVP Debra Dalgleish in the Microsoft Charting news group.
Top of Page
|
|
Microsoft Excel does not offer a built in capability to draw lines corresponding to statistical values for a series, such as the mean and the mean ± k standard deviations. The example on this page shows how to add statistical indicators to a simple run chart.
Top of Page
|
|
This zipped Excel file draws a control chart from data within a dynamic range on the worksheet, adds lines for Mean, UCL, and LCL, and updates same as data evolves. Contains randomly generated values in this demo. Features include a chart axis rescaling algorithm which is simple but effective in limited testing, and code that formats a data point's marker based on its value. (Warning: incompletely documented.)
Top of Page
|
|
Woody Santy has provided an advanced control chart program that he made for a class he teaches. There is no special documentation, but its use is self-explanatory.
Top of Page
|
|
A paired comparison chart is used to compare pairs of experimental values over a set of different conditions. The paired comparison chart above has a pair of data points at each of three conditions. The chart is part of a larger study examining the direction of plant species interactions (vertical or Y axis) across an estuarine salinity gradient (salt, brackish, or oligohaline marshes, along the category or X axis) and with and without small mammal herbivores (pairs of points). The numbers beside each point indicate the number of observations.
This article shows how to create a paired comparison chart.
Top of Page
|
|
A parallel coordinates chart, or profile plot, is a useful way to compare several sets of observations (here, one set per quarterback) of a combination of different factors (offensive categories). The entire population, or at least a broad set of data, is generally shown in a subdued color (the gray lines in the chart) while one or more individuals are highlighted for inspection (the blue and red lines).
Top of Page
|
|
|
Waterfall Chart
Box and Whisker
