Histograms

[TarheelGirl33]

Help Me! I am trying to create a Histogram on Excel. The onl
information that I have is class limits and the frequnecy's for eac
class. Every time I enter the information on Excel and click o
Hisogram it changes my Bins. I know there is a way to create one wit
this inforamtion, but I have no idea how. Thanks

 

[Michael R Middleton]

TarheelGirl33 -

Help Me! I am trying to create a Histogram on Excel. The only information

that I have is class limits and the frequnecy's for each class. Every time I
enter the information on Excel and click on Hisogram it changes my Bins. I
know there is a way to create one with this inforamtion, but I have no idea
how. Thanks! <

Excel's Histogram tool uses raw data to create a frequency distribution and
associated histogram (vertical bar chart).

You already have the frequency distribution, so you could use the
ChartWizard to create an Excel Column chart type.

- Mike Middleton, www.usfca.edu/~middleton

 

[Phanny Chheng]

Hi my name is Phanny Chheng. In order to use Histogram,
you can click on the chart picture on the window menu or
go to Insert and chart. Click on historgram under Chart-
sub type. Then you select the data range. Then you
specify the legend. Then you select finish in order to
show your chart. Make sure that you select the range
that you want the chart to show, if you do not do this,
you will not get the correct data to generate into the
graph. It is important that you select the entire cell.
Formmatting of the chart can also be done once you have
generate the graph. I hope this is was of some help.
good luck.!