To create bin ranges I first enter 02 02 03 the boundaries of the

To create bin ranges i first enter 02 02 03 the

This preview shows page 2 - 5 out of 14 pages.

To create bin ranges, I first enter CSCO, 0.4, 0.3, 0.2,…, – 0.2, 0.3 (the boundaries of the bin ranges) in cells H54:H62. Next, on the Data tab, in the Analysis group, I click Data Analysis to open the Data Analysis dialog box. The dialog box lists the functions of the Analysis ToolPak, which contains many of the statistical capabilities in Excel. Note If the Data Analysis command doesn’t appear on the Data tab, click the File tab, click Options, and then click Add-Ins in the left pane. In the Manage box, click Excel Add-Ins, and then click Go. In the Add-Ins dialog box, select Analysis ToolPak (the first choice, not Analysis ToolPak - VBA), and then click OK. Now you can access the Analysis ToolPak functions by clicking Data Analysis in the Analysis group on the Data tab. By clicking Histogram in the Data Analysis dialog box (and then clicking OK), you open the Histogram dialog box shown in Figure 41-2.
Image of page 2