Histograms in Excel for Mac 2008
While I do have a whole 'nother post coming up about the failings of Excel 2008, one major issue that was resolved is the analysis toolpak causing Excel 2004 to crash. "Luckily", this problem is fixed by removing VBA from Excel 2008, which means there is NO analysis toolpak. Not that it was ever great to begin with, but I guess histograms are nice. Anyway, I figured people might actually want to do histograms of their own. To that end, I created an excel file that does histograms.
Some of the stuff is a bit of kludge, but I'm sure it's fairly self-explanatory: put your data in column A, and the number of points in the appropriate cell. If you need more bins, change the number of bins and adjust the chart accordingly.
Link Here
Obviously, this is intended for Excel 2008 (and 2007), but it should be backwards compatible with earlier versions, as long as you have the necessary updates to read the new file format.
Some of the stuff is a bit of kludge, but I'm sure it's fairly self-explanatory: put your data in column A, and the number of points in the appropriate cell. If you need more bins, change the number of bins and adjust the chart accordingly.
Link Here
Obviously, this is intended for Excel 2008 (and 2007), but it should be backwards compatible with earlier versions, as long as you have the necessary updates to read the new file format.
Labels: math, things that annoy me
6 Comments:
Thank you for the Histogram spreadsheet - it is much appreciated !
Agreed! So much help thank you!
Thank a lot. The frequency function was beginning to annoy me very much, and your solution became my solution :)
Thanks a lot.i love ur solution,could u please create a similar sheet for relative frequency polygon?
For frequency polygon, all you need to do is just change the chart type into line. There may be other little things you need to do for formatting, but otherwise I think that should work.
That is so great. Now I have found the right tool for me. You really gave me an idea on how to setup those
Histograms in Excel for MAC 08. Such a great help, thanks for the post and keep it up!
Post a Comment
Links to this post:
Create a Link
<< Home