Histogram bins driving me crazy-please HELP
Tried that, but they were already in General format. No change.
"Joel" wrote:
Format the output cells in General format. these are the cells that are
giving you the decimal point numbers.
"Emily" wrote:
Thanks Joel--I tried your suggestion but unfortunately it didn't make any
difference. Any other ideas? Thanks.
"Joel" wrote:
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.
"Emily" wrote:
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!
|