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