XL98: How to Use the Histogram Add-In

This article was previously published under Q189519
This article has been archived. It is offered "as is" and will no longer be updated.
The Analysis ToolPak that ships with Microsoft Excel includes a Histogramtool. This article describes how to create a histogram with a chart from asample set of data.

Installing the Analysis ToolPak

Before using the Histogram tool, you need to make sure the Analysis ToolPakAdd-in is loaded. To verify whether the Analysis ToolPak is loaded, followthese steps:
  1. On the Tools menu, click Add-Ins.
  2. In the Add-Ins dialog box, make sure the Analysis ToolPak check box under Add-Ins Available is selected. Click OK.
NOTE: In order for the Analysis ToolPak to be shown in the Add-Ins dialogbox, it must be installed on your computer. If you do not see AnalysisToolPak in the Add-Ins dialog box, follow these steps:
  1. Quit Microsoft Excel.
  2. Start Microsoft Office Installer in the Office Custom Install folder on the Microsoft Office 98 CD-ROM.
  3. In the list that is currently set to Easy Install, click Custom Install.
  4. In the dialog box, click to clear all check boxes.
  5. Click the triangle next to the Microsoft Excel component.
  6. Click the triangle next to the Add-Ins component.
  7. Click to select Analysis ToolPak, and click Install.
  8. Click Quit when the Installer is finished.

Creating a Histogram

  1. Enter the following in a new worksheet:
        A1:  87      B1: 20    A2:  27      B2: 40    A3:  45      B3: 60    A4:  62      B4: 80    A5:   3      B5:    A6:  52      B6:    A7:  20      B7:    A8:  43      B8:    A9:  74      B9:   A10:  61     B10:						
  2. On the Tools menu, click Data Analysis. In the Data Analysis dialog box, click Histogram, and then click OK.
  3. In the Input Range box, type A1:A10.
  4. In the Bin Range box, type B1:B4.
  5. Under Output Options, click New Workbook and click to select the Chart Output check box, and then click OK.
A new workbook, with a Histogram table and an embedded chart, is generated.Based on the sample data from step 1, the Histogram table will look likethe following
   A1: Bin     B1: Frequency   A2:  20     B2:        2   A3:  40     B3:        1   A4:  60     B4:        3   A5:  80     B5:        3   A6: More    B6:        1				
and your chart will be a column chart reflecting the data in this Histogramtable.

Microsoft Excel counts the number of data points in each data bin. A datapoint is included in a particular data bin if the number is greater thanthe lowest bound and equal to or less than the greater bound for the databin. In the example here, the bin that corresponds to data values from 0to 20 contains two data points, 3 and 20.

If you omit the bin range, Microsoft Excel creates a set of evenlydistributed bins between the data's minimum and maximum values.

NOTE: You will not be able to create the Histogram chart if you specify theoptions (Output range or New worksheet ply) that create the Histogram tablein the same workbook as your data.

For additional information, please see the following article in theMicrosoft Knowledge Base:
183188 XL98: ATP Error: "Cannot Add Chart to a Shared Workbook"
For more information about the Histogram tool, click the Office Assistant,type "histogram," click Search, and then click to view "Histogram analysistool."

NOTE: If the Assistant is hidden, click the Office Assistant button on theStandard toolbar. If Microsoft Help is not installed on your computer,please see the following article in the Microsoft Knowledge Base:
179216 OFF98: How to Use the Microsoft Office Installer Program
XL98 toolpack tool pack

Article ID: 189519 - Last Review: 10/09/2013 19:51:38 - Revision: 1.0

Microsoft Excel 98 for Macintosh

  • kbnosurvey kbarchive kbhowto KB189519