frequency distribution

Copper Contributor

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