Histograms

  • Thread starter Thread starter TarheelGirl33
  • Start date Start date
T

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
 
TarheelGirl33 -
Help Me! I am trying to create a Histogram on Excel. The only information
Click to expand...
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
 
I hope ;you are clciking Histogram in tools-dataanalysis-histogram(analysis
tooloack ADDIN is checked).
in the <histogram> window you select the input range, Bin range, outputrange
and also you check
chartoutput in the same window at the bottom. then you get both freq.
distribution and the histogram.
 
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.!
 
Back
Top