David Posted March 14, 2005 Report Share Posted March 14, 2005 (edited) Hey everyone, im trying to make a histogram in excel but I dont think you can do it. If anyone has any software or know how could they please, please help me!!! Hours of television watched 0<5 6<8 9<11 12<15 16<20 This includes both end values (Cant remember how to write that!) Class width 5 3 3 4 5 frequency 4 5 2 0 0 frequency density 0.8 1.67 0.67 0 0 Edited March 14, 2005 by David Quote Link to comment Share on other sites More sharing options...
Dan Hardman Posted March 14, 2005 Report Share Posted March 14, 2005 (edited) give me a bit of time and i will try get one down for you Edited March 14, 2005 by Dan Hardman Quote Link to comment Share on other sites More sharing options...
plainlazy84 Posted March 14, 2005 Report Share Posted March 14, 2005 hows this? Histogram Quote Link to comment Share on other sites More sharing options...
David Posted March 15, 2005 Author Report Share Posted March 15, 2005 hows this? Histogram ← hmm. problem is for a histogram you have to plot freq density against the class groups. Its not a simple bar chart either because the frequency can be worked out by the area of each bar. (i think) Quote Link to comment Share on other sites More sharing options...
Urpedigreechumdog Posted March 15, 2005 Report Share Posted March 15, 2005 If you try and get hold of a copy of Autograph, it produces great histograms, and it does most of the work for you. And be for you ask no sorry, i don't have it so i can't send you it, we use it in school. (Y) Quote Link to comment Share on other sites More sharing options...
Urpedigreechumdog Posted March 15, 2005 Report Share Posted March 15, 2005 (edited) And when i was doing my statistics gcse coursework, only 2 people did histograms in excel so it must be quite hard or misleading to do (Y) Edit: Oh shit! i meant to edit the post above instead of 'add reply' ..... oh well :S" Edited March 15, 2005 by Urpedigreechumdog Quote Link to comment Share on other sites More sharing options...
Tomm Posted March 15, 2005 Report Share Posted March 15, 2005 As far as I remember, excel is pretty rubbish for actual histograms where you want the groups to be continous (rather than discreet values). I think I got around it by drawing the graph as a normal bar chart, then resizing the "bars" manually, so there was no space between them. I think you can do that :) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.