Microsoft Office Tutorials and References
In Depth Information
One More Example
Now you can create the Bins. I chose, after calculating the highest and
lowest values, to create bins from 25,000 to 250,000, with increments of 25,000.
See Figure 11.10.
Type the word Frequency in G4, then select the range of G5:G14 and activate the
Frequency function menu. Remember, this is an array function and you have to
calculate all the frequencies in the range at once. See Figure 11.11.
Fill the required fields with the following information: type Income in the
Data_array field, then select F5:F14 for the Bin_array field. Remember to apply
the array function rule: hold down the CTRL
Shift keys as you hit Enter. When you
use the CTRL
Enter, you will get the frequency distribution, as shown in
Figure 11.12. Looking at the results it is notable that the data is not distributed
symmetrically. It is skewed data. When you create a chart of the data, the visual
impact will be even stronger for presentation purposes.
To create the chart, select the range F4:G14 and create a two-dimensional
column chart. The process and the chart are illustrated in Figure 11.13.
This is continuous data; the gap between columns should be removed. See
FIGURE 11.10 Preparing the Bins for the Frequency Calculations
FIGURE 11.11 Calculating the Frequency