Ok I am trying to make a histogram in Excel using a frequency function. And I have looked at a number of articles online. They all say hit crtl-shift-enter after you have entered the function but it still isn't entering the numbers in the other bins. WTF am I doing wrong?
Edit: I have Bins of 4, 8, 12, 16, 20, 24, 28. And I have 820 values and I am 0 for 4, 44 for 8, 267 for 12, 622 for 16, 766 for 20, 779 for 24 and 758 for 28.
Nevermind I got it
Whew, was just about to explain it to you.
Okay, not really.
Margie
"It looks like your Dilbert screen saver is messing it up"
A common mistake I see folks make when trying to create a histogram is that they don’t maintain categorical exclusiveness. In other words, they try something like this: 1-4, 4-7, 7-10, etc. The problem is that a value such as “4” meets the criteria for both the first & second category. So, you need to set up the histogram like this: 1-4, 5-8, 9-12, etc.
Brett
RX Reven' wrote:A common mistake I see folks make when trying to create a histogram is that they don’t maintain categorical exclusiveness. In other words, they try something like this: 1-4, 4-7, 7-10, etc. The problem is that a value such as “4” meets the criteria for both the first & second category. So, you need to set up the histogram like this: 1-4, 5-8, 9-12, etc.
Brett
and then things get wonky when there are decimals not shown because the formatting is set to not show any numbers right of the decimal, so, for example in my work, when someone enters that they have been in the industry for 4.5 years, it would exclude them from the 1-4, 5-7 bins, so i have to do it as 4 thru <= 7.
Strizzo wrote:RX Reven' wrote:A common mistake I see folks make when trying to create a histogram is that they don’t maintain categorical exclusiveness. In other words, they try something like this: 1-4, 4-7, 7-10, etc. The problem is that a value such as “4” meets the criteria for both the first & second category. So, you need to set up the histogram like this: 1-4, 5-8, 9-12, etc.
Brett
and then things get wonky when there are decimals not shown because the formatting is set to not show any numbers right of the decimal, so, for example in my work, when someone enters that they have been in the industry for 4.5 years, it would exclude them from the 1-4, 5-7 bins, so i have to do it as 4 thru <= 7.
It might be interesting to create a pissedogram showing the frequency distribution of you getting pissed at having to do the conversion.
In reply to RX Reven':
it would be about as interesting as histograms go. who honestly says they've been working for 7/8ths of a year? also irritating are people that say they've been working for 20.5 years.
What the heck's a histogram? Other than the one in Photoshop that looks like a torque curve...
