I want to be able to bin my data set so I can get a histogram in 5% increments. i,e a bar chart that shows how many falls in the
[-999%,-50%, ],[-50%,-45%), [-45, -40%),.......[+50%,+999%]
Even in standard excel, I only know how to do this with a "CountIf" statement. However, this is something that i do every regularly, so I"m wondering if there is actually an easier way to do this than always typing it up.
If there is a way to do this, can I make it dynamic depending on the range. I,e if my range is actually between -20 to +20, it'll bin it in that range.
[-999%,-50%, ],[-50%,-45%), [-45, -40%),.......[+50%,+999%]
Even in standard excel, I only know how to do this with a "CountIf" statement. However, this is something that i do every regularly, so I"m wondering if there is actually an easier way to do this than always typing it up.
If there is a way to do this, can I make it dynamic depending on the range. I,e if my range is actually between -20 to +20, it'll bin it in that range.
