The Analysis ToolPak add-in, distributed with Excel, provides another way to calculate a frequency distribution. Start by entering your bin values in a range. Then choose Data?Analysis?Analysis to display the Data Analysis dialog box. If this command is not available, see the sidebar, “Is the Analysis Toolpak Installed?”.

In the Data Analysis dialog box, select Histogram and click OK. You should see the Histogram dialog box shown in Figure 17-8. Specify the ranges for your data (Input Range), bins (Bin Range), and results (Output Range), and then select any options. Figure 17-9 shows a frequency distribution (and chart) created with the Histogram option.

Note that the frequency distribution consists of values, not formulas. Therefore, if you make any CAUTIION changes to your input data, you need to rerun the Histogram procedure to update the results.

FIGURE 17-8
The Analysis ToolPak’s Histogram dialog box.

FIGURE 17-9
A frequency distribution and chart generated by the Analysis ToolPak’s Histogram option.

• Green Electric Hybrid Vehicle In this day and age, especially with cities becoming so clogged with buildings, homes and people, having a vehicle is...
• Bushnell 5x20 Golf Scope Rangefinder (Silver) User Reviews Send this to a friend Bushnell 5x20 Golf Scope Rangefinder (Silver) Manufacturer: Bushnell Customer Rating: List Price: $24.99...
• How to Make Independent Music : How to Distribute Your Music Online Learn how and where to distribute your indie album online in thisfree video series that will show you how to...
• How Traders Make 28% Returns In A Day Friday's stock market had a distinct sense of deja vu about it. Even though it was down overal, I was...