Data Analysis with Microsoft Excel: Updated for Office 2007

Excel Reference 561

Multiple Histograms

The StatPlus>Multivariable Charts>Multiple Histograms command creates

stacked histogram charts. The source data can be arranged in separate col-

umns or within a single column along with a column of category values. The

user can choose to display frequencies, cumulative frequencies, percentages,

or cumulative percentages. A normal curve can also be added to each of the

histograms. The histograms have common bin values and are shown in the

same vertical-axis scale. The histogram charts are sent to embedded charts

on a worksheet.

Multiple Normal Probability Plots

The StatPlus>Multivariable Charts>Normal P-plots creates a collection of

normal probability plots for variables arranged in columns. Normal curves

are plotted on a single chart.