Saturday, May 28, 2011

How to Add a Histogram in Microsoft Excel for Macs


1. Install the StatPlus-Mac LE (full link in Resources). This free add-on provides Mac users with statistical analysis tools. Excel 2011 for Mac does not include Microsoft's Analysis ToolPak.
2. Restart your Mac to complete the installation process and add StatPlus to your Excel installation.
3. Open Microsoft Excel and select 'File,' and then 'Open' to either open an existing workbook or start a new one.
4. Enter your bin values, which display as the horizontal axis values on your histogram, in a single row or column, one per cell. These are the labels that display at the bottom of your histogram to label each bar.
5. Enter your numeric data in a single column or row -- one per cell -- that corresponds. Histograms can only compare qualitative data, so do not enter non-numeric values in this column. For frequency histograms, these values are your frequency data.
6. Select 'Basic Statistics,' and then 'Descriptive Statistics' from the menu in Excel. The StatPlus installation automatically adds these menu options to your Excel installation.
7. Enter the values of the cells containing the numeric data values.
8. Enter the values of the cells containing the X-values, or bin numbers.
9. Select 'Advanced Options,' and then check both the 'Plot Histogram' and 'Overlay' boxes. Select 'OK' to let StatPlus create the histogram from your data.
10. Insert the graph into the current worksheet if you wish to include the histogram along with the table of data, or open a new worksheet on to put the graph into its own worksheet.

Blogger news