how do i count the freqency of values between certain ranges?
 

i have a set of 10 bin ranges i need to calculate the frequnecy that a set of
numbers occur, i tried using the freqency function but cant get it to work
correctly

how do i count the freqency of values between certain ranges?
 

Here is an example using equally spaced bins. Say we have values from 0 thru
99 in column A in cells A1 thru A1000 and the bins a

0-9 1
10-19 2
20-29 3
30-39 4
40-49 5
50-59 6
60-69 7
70-79 8
80-89 9
90-99 10

In B1 enter:
=ROUNDDOWN(A1/10,0)+1 and copy down
each value in A has the bin number next to it.

In C1 enter:
=COUNTIF(B1:B1000,ROW()) and copy down thru C10
C1 thru C10 tell you how many values are in each bin.

--
Gary''s Student - gsnu200769


"Paul" wrote:

i have a set of 10 bin ranges i need to calculate the frequnecy that a set of
numbers occur, i tried using the freqency function but cant get it to work
correctly

how do i count the freqency of values between certain ranges?
 

It is always better to give the formula that you used to let people see what
you ahve tried ang also give the results that you got. *can't get it to
work* is not very helpful.


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Paul" <Paul @discussions.microsoft.com wrote in message
...
i have a set of 10 bin ranges i need to calculate the frequnecy that a set
of
numbers occur, i tried using the freqency function but cant get it to work
correctly