Microsoft Office Tutorials and References
In Depth Information
l The Histogram dialog
box appears.
6
Click and drag the
range of numbers to
categorize, or type
the cell range.
6
!
7
Click and drag the
range of bins created
in Step 1, or type the
cell range.
7
8
9
8
Click where you want
to place your output.
0
9
Click the cell where you
want the results to
start, or type the cell
address.
0
Select options.
Pareto sorts data from highest to lowest.
Cumulative shows cumulative percentage.
Chart Output displays a chart.
!
Click OK.
The results appear on the same worksheet
as the original data.
l Frequency means number of values
per bin.
l More refers to the uncategorized values
above the highest bin.
Did You Know?
Click the Chart Output option
( changes to ) in the
Histogram dialog box to create a
histogram and a chart at the same
time. You can modify the chart just
as you would any other chart.
Did You Know?
You can click the Cumulative
Percentage option ( changes
to ) in the Histogram dialog box
to create a histogram output table
that includes cumulative
percentages. You can click the
Pareto (sorted histogram) option
( changes to ) to create a
histogram output table that includes
your data sorted in descending
order based on frequency.
Did You Know?
The FREQUENCY function gives
you the same capabilities as the
histogram tool. However, when
you use the FREQUENCY function,
your bins are automatically
updated as you update your data.
See the Excel Help files for more
about this function.
Chapter 6: Create Charts
149
 
Search JabSto ::




Custom Search