Histogram Using Data Analysis

Working Through It said:

Please help...

I am trying to produce a histogram using "data analysis" tool. I want to specify my Bin Ranges, I highlight all of my data (all cells) and put that into the Input Range area, then my instructor told us to highlight the ending value of each bin cutoff, example I want 5 bins, my first bin should end at data up to and containg 10.66 and then my next bin range should be up to 10.69....etc...I am adding the 5 bin cells into Bin Range area and separating with ",". I select chart output and I keep getting odd ball #'s and a "more" bin at the end....

Do you know what I am doing wrong???

Thanks in advance

Click to expand...

Working Through It said:

Ok I got it!!!!!!!!!!!!!!!!

My instructor did not clue us in on having the bin range cells in a group to select...your tip helped a lot.

Thanks!!

Click to expand...