Histogram Using Data Analysis

[Working Through It]

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

 

[VoG]

Does this help? http://www.vertex42.com/ExcelArticles/mc/Histogram.html

 

[tusharm]

Put the bin values in contiguous cells in a column and specify that cell range in the 'Bin Range' field.

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

 

[Working Through It]

Please show example of data below in contingous cell

10.72
10.81
10.98

what do I use to separate when entering the values?

Thanks

 

[Working Through It]

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!!

 

[tusharm]

Good you got that worked out on your own.

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!!