Home

frequency distribution

%3CLINGO-SUB%20id%3D%22lingo-sub-848012%22%20slang%3D%22en-US%22%3Efrequency%20distribution%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-848012%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20a%20hard%20time%20figuring%20out%20how%20to%20do%20a%20frequency%20distribution%20in%20excel%2C%20anybody%20know%3F%3C%2FP%3E%3CP%3EI%20am%20doing%20this%20for%20a%20class.%20We%20are%20giving%20a%20list%20of%20featuring%20NFL%2C%20MLB%2C%20MBA%2C%20NHL%2C%20MLS.%20We%20have%20to%20use%20this%20function%20to%20see%20how%20many%20times%20each%20of%20these%20appear%20in%20the%20list.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-848012%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-848083%22%20slang%3D%22en-US%22%3ERe%3A%20frequency%20distribution%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-848083%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F406954%22%20target%3D%22_blank%22%3E%40KROCK89%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFunction%20of%20%3CEM%3E%3CSTRONG%3Efrequency()%3C%2FSTRONG%3E%3C%2FEM%3Eis%20applicable%20for%20numeric%20data.%20You%20can%20use%20countifs()%20function%20to%20achieve%20your%20requirements.%20I%20have%20attached%20a%20sample%20file%2C%20hope%20it%20will%20work%20for%20you%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3ETauqeer%3C%2FP%3E%3C%2FLINGO-BODY%3E
KROCK89
Occasional Visitor

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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies