After I made some of these changes the histogram appears as its shown in Figure

After i made some of these changes the histogram

This preview shows page 4 - 8 out of 14 pages.

change the title of the chart by selecting the text and entering the title you want. After I made some of these changes, the histogram appears as its shown in Figure 41-4. F41xx04 FIGURE 41-4 Changing the format of different elements in the chart. F41xx04: This figure shows the histogram with no gaps and a smaller font size. Notice that Cisco returns are most likely between 0 and 10 percent per month, and the height of the bars drops off as the graph moves away from the tallest bar. When you create the histogram, you also obtain the bin-range frequency summary shown in Figure 41-5. F41xx05 FIGURE 41-5 The Cisco bin-range frequencies. F41xx05: This figure shows the bin-range count and finished histogram. From the bin- range frequencies, you can learn, for example, that for two months, Cisco’s return was greater than 30 percent and less than or equal to 20 percent; for 13 months, the monthly return was greater than 20 percent and less than or equal to 10 percent. If you add new Cisco monthly returns or even if you just modify the existing monthly returns, your histogram will not change unless you rerun the Data Analysis histogram procedure. Excel 2016 provides an easy option to create better-looking histograms that automatically update
Image of page 4