Microsoft Office Tutorials and References
In Depth Information
Creating a frequency distribution
1. Enter your bin values in a range.
2. Choose Data Analysis Data Analysis . The Data Analysis dialog box appears. If
this command is not available, see the sidebar, “Is the Analysis ToolPak Available?”
3. In the Data Analysis dialog box, select Histogram, and then click OK. The
Histogram dialog box, shown in Figure 17.8, appears.
FIGURE 17.8
The Analysis ToolPak’s Histogram dialog box
17
4. Specify the ranges for your data (Input Range), bins (Bin Range), and results
(Output Range), and then select any options and click OK. Figure 17.9 shows a
frequency distribution (and chart) created with the Histogram option.
FIGURE 17.9
A frequency distribution and chart generated by the Analysis ToolPak’s Histogram
option
Search JabSto ::




Custom Search