hannah553 -
how do you use the histogram function?i don't really understand bins. all
i have in my data are income groups e.g 0-10k, 11-20k etc and the
frequency of each one. can i make a histogram with this data? <
To use the Histogram tool, the data range is the raw data on a worksheet,
and the bins are values you enter in the worksheet to specify the upper
limits for each interval of the frequency distribution. The Histogram tool
creates the frequency distribution and a Column chart.
You already have a frequency distribution, so you could create a Column
chart to display the results.
- Mike
www.mikemiddleton.com