Hi Gabriel,
"My question is not why there is one item more in the histogram.
The question is, why the value of "6.0" in my input data is shown in the "overflow bin".
According to the documentation, it should be shown in the interval (bin) defined by cell J12 (together with J11).
("All other frequency values, [...] will be the count of those values that are greater than the immediately lower interval value and less than or equal to the current interval value.")"
And in what you are calling the 'overflow bin', the number is' the count of those values that are greater than the immediately lower interval value and less than the (unspecified) current interval value.'
It is quite possible that a number represented as 6.0 is larger than a number represented as 6.000000. The base 10 numbers we enter into the computer are converted to floating point binary numbers for any calculations (including comparisons), then back to base 10 numbers for display. While the conversion is very precise, it is not exact. There are some values that can be expressed exactly in base 10 that are not possible to express exactly in floating point binary notation.
Heres a simple example of a similar case: The exact value of one seventh can be easily expressed as an exact value using a common fraction, 1/7, but cannot be expressed as an exact value using base 10 decimal notation (and not including the 'repeat' sign).
The error is miniscule, but I suspect that the FPBinary representation of 6.0(base 10) is slightly larger than the FPBinary representation of 6.000000(base 10),
For your situation, there is a simple solution:
You know that the maximum possible score is 6, and that the last interval point below it is 5.4 (or 5.400000). That being the case, ANY score above 5.400000 belongs in the next bin, and NO actual score will be greater than 6.
Just remove the 6.000000 value from J12 (and remove the formula from K13).
Regards,
Barry
