Histogram bins driving me crazy-please HELP

E

Emily

Hi,

I'm trying to do a simple histogram but Excel seems to ignore the bins I
have set up. I have data ranging from 0 through 8. I have bins 0 through 8.
Yet when I enter this into the Histogram window, it gives me an output like
this:
Bin Frequency
0 1
1.142857143 21
2.285714286 7
3.428571429 5
4.571428571 7
5.714285714 6
6.857142857 1
More 10

First, what's with the decimals? And why "More" instead of "7" and "8"?

Thanks everyone! I'm losing my mind here!
 
J

Joel

Format the cells with your original data to show all the decimal places. The
format is probably number with0 decimal places. change to 10 decimal places.
the problem is with the data you are using.
 
E

Emily

Thanks Joel--I tried your suggestion but unfortunately it didn't make any
difference. Any other ideas? Thanks.
 
J

Joel

Format the output cells in General format. these are the cells that are
giving you the decimal point numbers.
 
J

Joel

I can't tell what the problem is! I would start from scratch in a new
workbook. file a group of cells (D1:F10) with the numbers ) to 8. Then put
the numbers 0 to 8 in the cells A1 to A9.

Next go to menu tools - Data Analysis - Histogram. Open the boxes in pop up
windows for Input Range (D1:F10) Bin Range (A1:A9) and output Range (B1:B9).
See if this works.

If it works then go back to your original workbook and do the same thing
using the cells in your workbook. I suspect the one of the other boxes in
the Histogram Popup window was selected when you set up your original
histogram.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top