Wrong Frequencies for Histograms

J

jmease

Everytime I create a histogram the frequencies generated are incorrect and I
have to manually count and change. Any suggestions on how to correct this
issue?
 
V

Val

How are you setting up the bin range, relative to the type of data?


Everytime I create a histogram the frequencies generated are incorrect and I
have to manually count and change. Any suggestions on how to correct this
issue?
 
J

jmease

I have one column of just the raw data (percentages) that I have copied and
pasted from other places in the worksheet. Then I have an MROUND formula in
the next column to round the raw data to the nearest 1%. This column is what
I use as my input range. I then copy and paste only unique numbers into the
next column and use this as my bin range. My only guess is that somehow the
rounding formula is throwing off my frequencies.
 
V

Val

When you paste the mround values, are you pasting the formula or the values
(paste special)?

Are you placing the bin values in sorted order, low to high?

And remember, the histogram counts values that are strictly lower than the
bin numbers.

For example, when I'm doing class grades, with cutoffs at 90, 80, 70, 60, my
bin values are
59.9
69.9
79.9
89.9

(assumes grades are in whole number values only, no fractional parts.)

Val


I have one column of just the raw data (percentages) that I have copied and
pasted from other places in the worksheet. Then I have an MROUND formula in
the next column to round the raw data to the nearest 1%. This column is
what
I use as my input range. I then copy and paste only unique numbers into the
next column and use this as my bin range. My only guess is that somehow the
rounding formula is throwing off my frequencies.
 
Top