Hello,
Can you please help me on this one?
I have this table to wicj I apply the frequency function
(=FREQUENCY(B7:B13,D7:D10) ), which is ok.
Age # of People Bin Frequency
33 6 10 0
34 25 15 1
14 9 20 2
17 6 30 1
29 16 3
20 4
35 1
Now, I want to calculate the frequency based on the number if people I have
in that age. For instance, the frequency of 15 should be 9 and not 1 (there
are 9 persons with 14 yrs of age); the freq of 20 should be 10 and so on.
How can I do it?
Than you,
Bookmarks