Forum Discussion
EXCEL FREQUENCY FUNCTION
I am trying to calculate the frequency of the first digits of a set of normally distributed numbers. I generated a random set of number that are normally distributed by which I then generated the fi...
I fixed the problem converting the LEFT(D1,1) to a number e.g.
=NUMBERVALUE(LEFT(D1,1)
It appears the the LEFT(D1,1) had a format that the Frequency function did not recognize even though the field was formatted as a number and the field appear to be a number, e.g. =LEFT(D1,1)+1 gives D1 + 1.
Thanks to anyone who looked at my problem.
Bill Mostia