Forum Discussion
frequency distribution
I am having a hard time figuring out how to do a frequency distribution in excel, anybody know?
I am doing this for a class. We are giving a list of featuring NFL, MLB, MBA, NHL, MLS. We have to use this function to see how many times each of these appear in the list.
1 Reply
hi KROCK89
Function of frequency() is applicable for numeric data. You can use countifs() function to achieve your requirements. I have attached a sample file, hope it will work for you,
Thanks
Tauqeer
