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

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

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
 
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 are:

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.
 
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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top