Microsoft Office Tutorials and References
In Depth Information
Advanced Counting Formulas
Is the Analysis ToolPak installed?
To make sure that the Analysis ToolPak add-in is installed, click the Data tab. If the Ribbon
displays the Data Analysis command in the Analysis group, you’re all set. If not, you’ll need to install
1. Choose File➜Options to display the Excel Options dialog box.
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.
Note: In the Add-Ins dialog box, you see an additional add-in, Analysis ToolPak - VBA. This
addin is for a programmer, and you don’t need to install it.
I cover pivot tables in Chapter 18, and you can learn more about the conditional
formatting data bars in Chapter 19.
Figure 7-11: Using data bars within a pivot table to display a histogram.
Using adjustable bins to create a histogram
Figure 7-12 shows a worksheet with student grades listed in column B (67 students total).
Columns D and E contain formulas that calculate the upper and lower limits for bins, based on
the entry in cell E1 (named BinSize ). For example, if BinSize is 10 (as in the figure), then each bin
contains ten scores (1–10, 11–20, and so on).