Thanks! Tushar Mehta initially suggested that the problem was perhaps caused
by the internal representation of decimal numbers, and Jerry W. Lewis
specifically suggested that it was my method of creating data (successive
increments of 0.1), rather than the Frequency function itself, that caused
the problem that I noted in my initial posting. Now I no longer view the
Frequency function with skepticism, because I know that I alone was the
culprit.

One suggestion: My original concern resulted from Googling "histogram" +
"Excel" and reading some earlier email correspondence regarding the Excel
Frequency function and the data set (0, 0.1, 0.2, ..., 9.9, 10.0). Others
could easily run across this or similar electronic discussions and might not
be as lucky as I was in finding a comforting answer. Is there perhaps a
communication mechanism that Microsoft could use to correct any similar
misunderstandings, in the community of Excel users, regarding the Frequency
function? Just a thought!

"Jim" wrote:

I am using Excel 2002. There is a problem with the frequency function, which
is used for histograms. The frequency counts for some (not all) bins is
incorrect. The case that I learned of in another posting involves 101 data
values: 0, 10, and values in between that are created by using an increment
of 0.1. The frequency value for the first bin is (correctly) 11, and most of
the other bins have the correct frequency (10). However, the bin
representing the interval from 1 to 2 has a frequency of 9, which the bin
representing the interval from 4 to 5 has a frequency of 11! I have also
used the "Better Histrogram" downloadable file for this same problem, but
apparently the "Better Histogram" procedure starts with the Frequency
function, as it ends up with a histogram with the same results. Any
suggestions for correctly calculating all bin frequencies?
--
Jim