Ok, I will post here rather than PMing.
Here's what I have:
A data set including the average gmat score for the top 25 schools, circa 1990, from what I can tell. (Stanford tops the list at 675 -- everyone take a moment to feel superior.)
I am supposed to make a histogram showing the frequency distributions with 9 classes: 595 to less than 605, 605 to less than 615.....675 to less than 685. My problem was that the histogram excel was giving me wasn't counting the frequencies correctly. There are 3 scores in the first class (or bin as excel says), but excel keeps giving me two.
Gogetter reminded me that there is online help that is better than the in-software stuff, so that was awesome. I realized that excel defines the bins a little differently than my book does - excel uses "less than or equal to 605," more than 605 and equal to or less than 615," etc, finishing with "more than or equal to 675"
That's ok with me; I've just jiggered the bins a bit and now they match up with the classes the book asks for. But for some reason, stinking excel is still cutting off the first data point - a gmat score of 597. So instead of getting 3 data points in bin #1, I get only 2. Instead of having 25 total data points, I've got 24. Why oh why?
The whole annoying thing is attached for your viewing pleasure.
Attachments
GMAT.XLS [19.5 KiB]
Downloaded 113 times