Forum Discussion

KROCK89's avatar
KROCK89
Copper Contributor
Sep 11, 2019

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...
Formulas and Functions
tauqeeracma's avatar
tauqeeracma
Iron Contributor
Sep 11, 2019

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

Resources