Excel 2013: Frequency Function & Creating Histograms

Goal: Use the frequency function to determine the classes of a data set and create a histogram based on the frequency data.
Skills Needed: None
Requirements: Excel 2013

[@xokferg894]

Thank you from Statistics students everywhere

[@Troyboi18]

Really Confused by all the mean comments on here. Don't know why being gay has anything to do with the information being presented. Thanks for the video, it was a HUGE help for my math lab!

[@gregchiasson4269]

you sir, deserve all praise. you saved me big time.

[@aforgot1]

OMG!!! I freaking LOVE U!!!! After 3 hours of watching videos on how to construct a histogram your video is the ONLY one that actually worked. U FREAKING ROCK!!!

[@MoniqueWillisms6willis]

I've been searching for 24hrs (sleep in between) for the simplest explanation for using frequency w/grades...Thank You-Thank You-Thank You

[@InspiredCreationsVivi]

I have been racking my head all day. Thank you so much for making this simple to follow. Sincerely appreciate it.

[@jennifer15497]

OH MY GOD THANK YOU. THANK YOU. This helped so much for my exam. My professor didn't even explain this as well as you did. She just said to literally select the bins and insert graph -__-

[@Thardy12]

Thank you for how simple this is even 10 years later

[@readthisman]

Thank you, I needed this for my stat class. Saved my life~

[@tokioobsessed1983]

Even though I'm still working with Excel 2010, and things were a wee bit different, this was still extremely helpful. Thanks again.

[@bradleyabbeduto7258]

THANK you for doing the intervals. My instructor insisted on intervals and no other youtube videos or my online instructor would explain HOW to get such intervals in the data set.

[@bengisubektas5277]

Oh my god I have been trying to figure out how to do this for the past hour your video was the only one that actually helped and i finally figured it out! thank you!!!

[@everythingismediocre]

Kevin, don't mind the haters. Trolls are a dime a dozen. Thank you very much for this fantastic video. Saved my life.

[@emmad3567]

You saved our lives, and we are eternally grateful

[@RedEyeschannel]

i pass literally all night yesterday trying to understand wat bins are, thank you, you relly help me a lot

[@bruswane9771]

Wow informations is so clear even computer dummies like me can follow. Thanks dude this vid saved my grades...

[@Annmiie]

Best explanation on RUclips!

[@ruszakirov6759]

Great video bud! Detailed and clear explanations. Thx, helped me with my statistics project!

[@deloresafful5590]

Thanks...you're awesome!. Took me four painful days to come across this

[@RBRB431]

This was the first question on my assignment and I got stuck right there! Thank you so much! worked perfectly!

[@paulbucknall1064]

Absolutely brilliant!!! A gift from the statistics gods!!! Cheers Mate!

[@jonathancain3801]

Excellent video you made it clear and my histogram is now done after having no idea what to do. This is a huge relief thanks a bunch

[@marygmaz2013]

You saved my life in college, during finals.

[@Mizrachi.x]

YOU SAVED MY EXAM AND MY LIFE THANK YOU.

[@slumdogmillionaire01]

thanks so much for this video!! i tried playing around with the histogram chart feature and was v unsuccessful so your video saved my day!

[@dasrotrad]

Very nice explanation and example of the Frequency function. Thank you Kevin.

[@brianluu1965]

Great alternative to the data analysis toolpak method! Tutorial was simple and clear to follow!

[@erinware8402]

Great tutorial! Thanks for posting. I will use your tutorials for all of my Excel 2013 needs in the future.

[@DeathCon88]

Histograms involve frequency density. This shows frequency. I don't get it.

[@JohnCBriggs]

Awesome. I always remember how to do the old school DataAnalysis histogram, but I forget about the Frequency function which is much better IMHO.

[@casrochin8989]

Thank you so much Kevin. Easy instructions. I look forward to many more of your videos.

[@brittneymedina6960]

I couldn't get how to do it for the life of me! Thank you so much!

[@sohomaroanie156]

Thank you so much for the video. It really helped me! Your instructions were very clear and easy to follow.

[@angusmatthews1772]

saved my ass, huge help. you lord

[@ckong25]

This helped me a lot with my Statistics homework. Thank you!

[@elzz3]

Why does this sound like a video game walkthrough? Good shit though, needed this.

[@saraheawoolsey1222]

Thanks you so much for this tutorial. I had seen another one that just didn't work... love it!

[@auroraautumn8764]

An extra 3 points on my homework. Thank you.

[@v3gancheese]

almost started crying in the school library lol thank u for this video

[@rugeethaanasohan6768]

GOD BLESS YOUR SOUL AND THOSE OF YOUR FAMILY AND LOVED ONES. THANK YOU

[@kellerkahn]

Excellent job. Extremely detailed presentation.

[@hcoloverxoxo616]

Thanks you SO much for this. Only video that I fully understood

[@carl6991]

Fantastic tutorial, I was able to simply follow step by step. Thanks!

[@nicholasduenas6912]

i rate this video 8/8 it was gr8 m8

[@chantelporretta9028]

thank you so much! you're a great teacher, I appreciate you uploading this! :)

[@o0Jade960o]

Thank you for doing a 2013 version! Very helpful!

[@sophie1541]

tears of joy

[@MixedTornado15]

Really nice video ! You explained everything thoroughly and easily

[@ryanpark5483]

Well done sir and thank you much. Very concise and simple to understand.

[@Avacallender]

You made this SOOOO easy! Thank you!

[@Hadronifix]

Thank you! You are succinct, efficient and right on the money. Good job!

[@CruxialExpression]

Thanks, man. This video saved my rear!

[@daniazaidi659]

Thank you so much saved my life for this assignment

[@lsoto1304]

Thank You!! It help me add an additional element of distribution to my annual report for the student's certification performance in my lab program.

[@sonwabisesons9546]

Thank you very much...this is excellent it helped me with my exam preparation.

[@madmatto9264]

Nice presentation, I have shared it with my colleagues.

[@priestof1]

THANK YOU, I NEEDED THIS TO DO SOME WORK GREAT JOB. If you would explain the process of getting the formulas down or slow down so we could see what you click would be absolutely grade a work.

[@LuisMolina-pk5ot]

Very helpful, really appreciate the work that you put into making it. Thanks for everything it saved me

[@tererachie]

so helpful and much simpler to understand

[@cmueller61]

Nicely explained. Brief and to the point. Thanks.

[@wesley_b]

Excellent. This is precisely what I was looking to do! Stoked. :D

[@amandasandoval7481]

Thank you for posting this video. Helped me a lot.

[@Sameerrane1979]

Thank u So much... U explained it simplest way

[@emadezzeldin1422]

Thanks a ton. We Appreciate your time.

[@nathanmcintyre694]

This video saved my life. thanks man!

[@cavetrollcob]

Thanks for the vid, you do a better job then my teacher in explaining how to do these =D

[@tjhanson9075]

thank you Kevin Olson you know what a histogram is

[@Jack-px9mh]

What if you get #NAME ? I did everything according to the video. Did I miss something ?

[@kiwiinbristol]

Nice one, clear and easy to understand. Thanks

[@constancegm29]

thanks guy you have save my time!

[@roseharris6846]

Thanks so much! Very clear explanations.

[@Chymai]

Thank you so very much for this tutorial!!!! You saved my project

[@EduardoOrlandoLizarragaGarcia]

thank you
I was having troubles doing my statistics homework

[@karag1116]

Great explanation! Thank you so much, incredibly helpful to have a histogram for my project!

[@winmyanmarlay1664]

Thank you. Awesome and clear explanations

[@oktafianflonsia6022]

Mantap om bule

[@wolfpackncsu2]

Dude you the man, thanks so much!!!

[@user-cw1zw1nk3v]

Love your voice!!!

[@kellyk6257]

Great example. Thank you.

[@euclidpb]

Great teacher!

[@panosmichael4534]

YOU ARE THE MAAAAN

[@g-mari9659]

that's genius buddy good work I love it!

[@cyearly9426]

I was getting #NAME, too until I noticed the simple solution. Highlight all the cells you want to use the frequency formula in BEFORE you create it for the first cell. Video does highlight the range but does not mention it verbally.

[@liyaa_foxx]

Thank you so much for posting this!!!

[@mayraloredo3251]

Please continue making more

[@clemsonmagic60]

Thanks! This helped alot! But, one question, my computer only fills out the frequencies of the row I am on, any clue why? Does it matter that I am using excel online?

[@skyangel153]

Thank you so much for this.So easy to do

[@prodchrised]

Thanks mate your a legend

[@Maxxx20]

Thank you so much for this video!

[@proud_muslimah8860]

IT IS VERY HELPUL IN MY WORD GOOD JOB

[@NZVWNUT]

Thanks a lot for this - good tutoring.

[@mastersoanes]

Dude! thanks for this Video, it helped me loads!

[@212madeline]

Thank you so much! Your video was very helpful!!

[@taraalma2]

Thank you. Really useful.

[@phucho5702]

THANK YOU SO MUCH YOU SAVE MY LIFE

[@KevFresh]

great video man helped alot!!

[@phiskibiski]

Thank you so much. Such a great tutorial!

[@DaBraumaBull]

Thanks, this is incredibly helpful.

[@MrSupernova111]

Awesome job! Thanks!!

[@ReconGhost19]

This helped a lot! Thank you so much!