Select 'OK' to let StatPlus create the histogram from your data.ġ0. Select 'Advanced Options,' and then check both the 'Plot Histogram' and 'Overlay' boxes. Enter the values of the cells containing the X-values, or bin numbers.ĩ. Enter the values of the cells containing the numeric data values.Ĩ. The StatPlus installation automatically adds these menu options to your Excel installation.ħ. Select 'Basic Statistics,' and then 'Descriptive Statistics' from the menu in Excel. For frequency histograms, these values are your frequency data.Ħ. Histograms can only compare qualitative data, so do not enter non-numeric values in this column. Enter your numeric data in a single column or row - one per cell - that corresponds.
These are the labels that display at the bottom of your histogram to label each bar.ĥ. Enter your bin values, which display as the horizontal axis values on your histogram, in a single row or column, one per cell. Open Microsoft Excel and select 'File,' and then 'Open' to either open an existing workbook or start a new one.Ĥ. Restart your Mac to complete the installation process and add StatPlus to your Excel installation.ģ. Excel 2011 for Mac does not include Microsoft's Analysis ToolPak.Ģ. This free add-on provides Mac users with statistical analysis tools. Install the StatPlus-Mac LE (full link in Resources).
