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.

[@InspiredCreationsVivi]

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

[@readthisman]

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

[@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!!!

[@ruszakirov6759]

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

[@RBRB431]

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

[@tokioobsessed1983]

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

[@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

[@erinware8402]

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

[@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!!!

[@paulbucknall1064]

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

[@emmad3567]

You saved our lives, and we are eternally grateful

[@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

[@sohomaroanie156]

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

[@Thardy12]

Thank you for how simple this is even 10 years later

[@LuisMolina-pk5ot]

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

[@carl6991]

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

[@nathanmcintyre694]

This video saved my life. thanks man!

[@chantelporretta9028]

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

[@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 -__-

[@Hadronifix]

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

[@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.

[@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!

[@Annmiie]

Best explanation on KZbin!

[@brianluu1965]

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

[@saraheawoolsey1222]

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

[@Mizrachi.x]

YOU SAVED MY EXAM AND MY LIFE THANK YOU.

[@dasrotrad]

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

[@Avacallender]

You made this SOOOO easy! Thank you!

[@casrochin8989]

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

[@RedEyeschannel]

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

[@Chymai]

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

[@clotz15]

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

[@ryanpark5483]

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

[@MixedTornado15]

Really nice video ! You explained everything thoroughly and easily

[@CruxialExpression]

Thanks, man. This video saved my rear!

[@phiskibiski]

Thank you so much. Such a great tutorial!

[@bruswane9771]

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

[@wesley_b]

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

[@kellerkahn]

Excellent job. Extremely detailed presentation.

[@everythingismediocre]

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

[@hcoloverxoxo616]

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

[@nicholasduenas6912]

i rate this video 8/8 it was gr8 m8

[@erkoabdurahman5093]

Dude Thanks so much, this helped a lot :D

[@amandasandoval7481]

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

[@karag1116]

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

[@o0Jade960o]

Thank you for doing a 2013 version! Very helpful!

[@Jack-px9mh]

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

[@roseharris6846]

Thanks so much! Very clear explanations.

[@constancegm29]

thanks guy you have save my time!

[@mastersoanes]

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

[@g-mari9659]

that's genius buddy good work I love it!

[@deloresafful5590]

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

[@ReconGhost19]

This helped a lot! Thank you so much!

[@auroraautumn8764]

An extra 3 points on my homework. Thank you.

[@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?

[@wolfpackncsu2]

Dude you the man, thanks so much!!!

[@brittneymedina6960]

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

[@euclidpb]

Great teacher!

[@winmyanmarlay1664]

Thank you. Awesome and clear explanations

[@Jdance161]

This was amazing! Thank you!

[@liyaa_foxx]

Thank you so much for posting this!!!

[@cmueller61]

Nicely explained. Brief and to the point. Thanks.

[@daniazaidi659]

Thank you so much saved my life for this assignment

[@user-cw1zw1nk3v]

Love your voice!!!

[@212madeline]

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

[@emadezzeldin1422]

Thanks a ton. We Appreciate your time.

[@xavierlarason4894]

Thank you very much, I am running into issue and that my idk if my mac doesn't have a true enter button however is their a way to do it manually

[@kellyk6257]

Great example. Thank you.

[@DaBraumaBull]

Thanks, this is incredibly helpful.

[@kiwiinbristol]

Nice one, clear and easy to understand. Thanks

[@fomalhautb14]

thank you! it was really useful!

[@MrSupernova111]

Awesome job! Thanks!!

[@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.

[@KevFresh]

great video man helped alot!!

[@serialcode8030]

This was so helpful, thank you!

[@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.

[@Sameerrane1979]

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

[@lindahuang647]

thanks for the video, it really helps me a lot!

[@Maxxx20]

Thank you so much for this video!

[@skyangel153]

Thank you so much for this.So easy to do

[@taraalma2]

Thank you. Really useful.

[@heih3088]

Super helpful thanks so much!

[@beckyb8929]

thanks but what if you have a whole bunch of columns... can you drag across or do you have to do this one at a time. I did this a long time ago and don't remember if I found a quick way or not.... thank you!

[@NZVWNUT]

Thanks a lot for this - good tutoring.

[@sonwabisesons9546]

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

[@cavetrollcob]

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

[@prodchrised]

Thanks mate your a legend

[@marygmaz2013]

You saved my life in college, during finals.

[@nishantsharma7596]

+Kevin Olson Could you help me with using Histogram chart type and continuous intervals?

[@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.

[@aishadanielle3552]

Thank You! This was great!

[@lupitaquintana1725]

Big Help! Thank you

[@sophie1541]

tears of joy

[@Harabusa200]

great video, one question is there a quick way to introduce a lot of data... for example 100 test grades

[@NicovanderVeen001]

Super tips!

[@williamsonz5228]

How did you select the second (grades) and third (bins) columns like that?

[@luffymonkey3201]

hey hey i have a question how did u get that data array for frequency i cant get it on excel 2013 @kevin olson