Microsoft Office Tutorials and References
In Depth Information
USING THE ANALYSIS TOOLPAK TO CREATE A FREQUENCY DISTRIBUTION
Figure 8-38: Creating a frequency distribution for the data
in column A
Enter an array formula by pressing Ctrl+Shift+Enter.
The array formula is entered into all the selected cells and returns the count of
values in the Data range that fall into each bin. You can then create other formulas
that make use of the frequencies. For example, column E displays cumulative
frequencies, and column F shows cumulative percent.
The combination chart was created using the frequency data in column D (the
column series) and the cumulative percent data in column F (the line series). The
histogram suggests that the data approximates a normal distribution.
USING THE ANALYSIS TOOLPAK TO CREATE
A FREQUENCY DISTRIBUTION
If you install the Analysis ToolPak add-in, you can use the Histogram option to
create a frequency distribution. Select Tools
Data Analysis to display the Data
Analysis dialog box. Next, select Histogram and click OK. You should see the
Histogram dialog box shown in Figure 8-39.