• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

calculating frequency

S

stuck

New Member
I tried following the description of how to calculate frequency on the site, but when I do so, all I get as an answer is the number within the first band -- it does not fill the column with all the other frequency bands.


Also - is there a way to get the number of the frequency as well as the percentage of the total?


Thanks!
 
Stuck


Firstly, Welcome to the Chandoo.org forums


If your using the Frequency function that is an array formula and has to be entered as such

Example

If you have data in A2:A100

and a list of bins in B2:B5, note this will make 5 bins

Select somewhere else Say C1:C5

Enter =Frequency(A2:A100,B2:B5) CTRL+SHIFT+ENTER


This will make 5 bins with data selected as below

C1 <=B2

C2 >B2 <=B3

C3 >B3 <=B4

C4 >B4 <=B5

C5 >B5


If you only select C1 you will only get the first value of the array
 
Thanks for responding. And thanks for guiding me in the right direction.


I have tried what you just explained any number of times. Just realized that I had to CTRL shift enter on the function argument screen after I enter values in a and b


Is there a way to then convert those frequencies in to percentages of the total without too much more manipulation?
 
You must log in or register to reply here.
Back
Top