Microsoft Office Tutorials and References
In Depth Information
Creating a frequency distribution
Note that the frequency distribution consists of values, not formulas. Therefore, if you make any changes to your
input data, you need to rerun the Histogram procedure to update the results.
Is the Analysis ToolPak Available?
To make sure that the Analysis ToolPak add-in is available for use, click the Data tab. If the Ribbon displays
the Data Analysis command in the Analysis group, you’re all set. If not, you’fill need to install the add-in:
Options . The Excel Options dialog box appears.
2. Click the Add-Ins tab on the left.
3. Select Excel Add-Ins from the Manage drop-down list.
4. Click Go to display the Add-Ins dialog box.
5. Place a check mark next to Analysis ToolPak.
6. Click OK.
If you’ve enabled the Developer tab, you can display the Add-Ins dialog box by choosing Developer
1. Choose File
In the Add-Ins dialog box, you see an additional add-in, Analysis ToolPak – VBA. This add-in is
for programmers, and you don’t need to install it.
Using a PivotTable to create a frequency distribution
If your data is in the form of a table, you may prefer to use a PivotTable and a PivotChart to
create a histogram. Figure 17.10 shows the student grade data summarized in a PivotTable
and a PivotChart. The counts were created by grouping.
Using a PivotChart to display a histogram