- #1
Pengwuino
Gold Member
- 5,123
- 20
I want to have an analysis of my lab report grading for my students and I figured I could make a histogram. I had been manually doing =COUNTIF()'s before but I learned you could install a histogram package just now! However, it seems to be giving me conflicting results that have to do with how the BIN sizes work.
Here's what I have: A bunch of report grades from 0-20 and I occasionally give students half integer grades such as 15.5 or 18.5 or whatever. I have a list of grades, 0 to 20 in integer steps. I do a COUNTIF() and count up the integer guys and the half integer guys. For example, for the 15 score, i count up 15s and 15.5s. Then I plot those both as 15s. However, when I use the actual histogram function, I get numbers that aren't exactly what I have by doing COUNTIF()s. I used the 0-20 list as my bin array. Apparently that must be causing the problem. I assumed, and as far as any site that I read told me, that if they go as 1,2,3,4,5 etc, that it would count how many scores are 1-1.999,2-2.999,3-3.999, etc but that doesn't seem to be exactly how it works. Can someone explain how Excel does this?
Thanks!
Here's what I have: A bunch of report grades from 0-20 and I occasionally give students half integer grades such as 15.5 or 18.5 or whatever. I have a list of grades, 0 to 20 in integer steps. I do a COUNTIF() and count up the integer guys and the half integer guys. For example, for the 15 score, i count up 15s and 15.5s. Then I plot those both as 15s. However, when I use the actual histogram function, I get numbers that aren't exactly what I have by doing COUNTIF()s. I used the 0-20 list as my bin array. Apparently that must be causing the problem. I assumed, and as far as any site that I read told me, that if they go as 1,2,3,4,5 etc, that it would count how many scores are 1-1.999,2-2.999,3-3.999, etc but that doesn't seem to be exactly how it works. Can someone explain how Excel does this?
Thanks!