Sep 10 2019 08:52 PM
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.
Sep 10 2019 11:27 PM
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