Excel 2013: Frequency Function & Creating Histograms

แชร์
ฝัง
  • เผยแพร่เมื่อ 23 ต.ค. 2024

ความคิดเห็น • 226

  • @xokferg894
    @xokferg894 8 ปีที่แล้ว +121

    Thank you from Statistics students everywhere

  • @Troyboi18
    @Troyboi18 10 ปีที่แล้ว +20

    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
    @gregchiasson4269 10 ปีที่แล้ว +9

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

  • @aforgot1
    @aforgot1 7 ปีที่แล้ว

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

  • @InspiredCreationsVivi
    @InspiredCreationsVivi 10 ปีที่แล้ว +1

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

  • @emmad3567
    @emmad3567 7 ปีที่แล้ว

    You saved our lives, and we are eternally grateful

  • @Thardy12
    @Thardy12 ปีที่แล้ว

    Thank you for how simple this is even 10 years later

  • @MoniqueWillisms6willis
    @MoniqueWillisms6willis 5 ปีที่แล้ว

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

  • @readthisman
    @readthisman 9 ปีที่แล้ว +5

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

  • @bradleyabbeduto7258
    @bradleyabbeduto7258 9 ปีที่แล้ว

    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.

  • @ruszakirov6759
    @ruszakirov6759 8 ปีที่แล้ว +2

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

  • @jennifer15497
    @jennifer15497 6 ปีที่แล้ว

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

  • @tokioobsessed1983
    @tokioobsessed1983 9 ปีที่แล้ว

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

  • @erinware8402
    @erinware8402 10 ปีที่แล้ว

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

  • @bengisubektas5277
    @bengisubektas5277 5 ปีที่แล้ว

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

  • @jonathancain3801
    @jonathancain3801 9 ปีที่แล้ว

    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

  • @paulbucknall1064
    @paulbucknall1064 8 ปีที่แล้ว

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

  • @Mizrachi.x
    @Mizrachi.x 7 ปีที่แล้ว

    YOU SAVED MY EXAM AND MY LIFE THANK YOU.

  • @bruswane9771
    @bruswane9771 8 ปีที่แล้ว

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

  • @NZVWNUT
    @NZVWNUT 10 ปีที่แล้ว

    Thanks a lot for this - good tutoring.

  • @dasrotrad
    @dasrotrad 6 ปีที่แล้ว

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

  • @casrochin8989
    @casrochin8989 9 ปีที่แล้ว

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

  • @kellerkahn
    @kellerkahn 5 ปีที่แล้ว

    Excellent job. Extremely detailed presentation.

  • @saraheawoolsey1222
    @saraheawoolsey1222 8 ปีที่แล้ว

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

  • @brianluu1965
    @brianluu1965 9 ปีที่แล้ว

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

  • @sohomaroanie156
    @sohomaroanie156 7 ปีที่แล้ว

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

  • @deloresafful5590
    @deloresafful5590 7 ปีที่แล้ว

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

  • @RedEyeschannel
    @RedEyeschannel 9 ปีที่แล้ว

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

  • @Annmiie
    @Annmiie 10 ปีที่แล้ว

    Best explanation on TH-cam!

  • @ckong25
    @ckong25 5 ปีที่แล้ว

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

  • @hcoloverxoxo616
    @hcoloverxoxo616 8 ปีที่แล้ว

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

  • @auroraautumn8764
    @auroraautumn8764 8 ปีที่แล้ว

    An extra 3 points on my homework. Thank you.

  • @Avacallender
    @Avacallender 6 ปีที่แล้ว

    You made this SOOOO easy! Thank you!

  • @carl6991
    @carl6991 10 ปีที่แล้ว

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

  • @slumdogmillionaire01
    @slumdogmillionaire01 5 ปีที่แล้ว

    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!

  • @RBRB431
    @RBRB431 9 ปีที่แล้ว

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

  • @daniazaidi659
    @daniazaidi659 7 ปีที่แล้ว

    Thank you so much saved my life for this assignment

  • @everythingismediocre
    @everythingismediocre 9 ปีที่แล้ว

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

  • @priestof1
    @priestof1 10 ปีที่แล้ว

    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.

  • @amandasandoval7481
    @amandasandoval7481 8 ปีที่แล้ว

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

  • @o0Jade960o
    @o0Jade960o 10 ปีที่แล้ว

    Thank you for doing a 2013 version! Very helpful!

  • @kiwiinbristol
    @kiwiinbristol 9 ปีที่แล้ว

    Nice one, clear and easy to understand. Thanks

  • @brittneymedina6960
    @brittneymedina6960 6 ปีที่แล้ว

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

  • @lsoto1304
    @lsoto1304 7 ปีที่แล้ว

    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.

  • @Hadronifix
    @Hadronifix 7 ปีที่แล้ว

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

  • @roseharris6846
    @roseharris6846 7 ปีที่แล้ว

    Thanks so much! Very clear explanations.

  • @cmueller61
    @cmueller61 9 ปีที่แล้ว

    Nicely explained. Brief and to the point. Thanks.

  • @MixedTornado15
    @MixedTornado15 9 ปีที่แล้ว

    Really nice video ! You explained everything thoroughly and easily

  • @JohnCBriggs
    @JohnCBriggs 8 ปีที่แล้ว

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

  • @skyangel153
    @skyangel153 8 ปีที่แล้ว

    Thank you so much for this.So easy to do

  • @Harabusa200
    @Harabusa200 9 ปีที่แล้ว

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

  • @tererachie
    @tererachie 9 ปีที่แล้ว

    so helpful and much simpler to understand

  • @clemsonmagic60
    @clemsonmagic60 9 ปีที่แล้ว +1

    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?

  • @CruxialExpression
    @CruxialExpression 8 ปีที่แล้ว

    Thanks, man. This video saved my rear!

  • @sonwabisesons9546
    @sonwabisesons9546 7 ปีที่แล้ว

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

  • @marygmaz2013
    @marygmaz2013 9 ปีที่แล้ว

    You saved my life in college, during finals.

  • @emadezzeldin1422
    @emadezzeldin1422 10 ปีที่แล้ว

    Thanks a ton. We Appreciate your time.

  • @winmyanmarlay1664
    @winmyanmarlay1664 6 ปีที่แล้ว

    Thank you. Awesome and clear explanations

  • @Sameerrane1979
    @Sameerrane1979 8 ปีที่แล้ว

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

  • @rugeethaanasohan6768
    @rugeethaanasohan6768 8 ปีที่แล้ว

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

  • @chantelporretta9028
    @chantelporretta9028 9 ปีที่แล้ว +1

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

  • @euclidpb
    @euclidpb 9 ปีที่แล้ว

    Great teacher!

  • @LuisMolina-pk5ot
    @LuisMolina-pk5ot 10 ปีที่แล้ว

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

  • @wesley_b
    @wesley_b 8 ปีที่แล้ว

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

  • @kellyk6257
    @kellyk6257 7 ปีที่แล้ว

    Great example. Thank you.

  • @ryanpark5483
    @ryanpark5483 10 ปีที่แล้ว

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

  • @constancegm29
    @constancegm29 10 ปีที่แล้ว

    thanks guy you have save my time!

  • @ksoprock
    @ksoprock 7 ปีที่แล้ว

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

  • @beckyb8929
    @beckyb8929 7 ปีที่แล้ว

    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!

  • @liyaa_foxx
    @liyaa_foxx 7 ปีที่แล้ว

    Thank you so much for posting this!!!

  • @212madeline
    @212madeline 9 ปีที่แล้ว

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

  • @cavetrollcob
    @cavetrollcob 7 ปีที่แล้ว

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

  • @angusmatthews1772
    @angusmatthews1772 9 ปีที่แล้ว +9

    saved my ass, huge help. you lord

  • @Jack-px9mh
    @Jack-px9mh 7 ปีที่แล้ว +3

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

  • @madmatto9264
    @madmatto9264 10 ปีที่แล้ว

    Nice presentation, I have shared it with my colleagues.

  • @Maxxx20
    @Maxxx20 10 ปีที่แล้ว

    Thank you so much for this video!

  • @Chymai
    @Chymai 9 ปีที่แล้ว

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

  • @tokioobsessed1983
    @tokioobsessed1983 9 ปีที่แล้ว

    Very Helpful. Thank you!!!

  • @大强喵咪
    @大强喵咪 7 ปีที่แล้ว

    Love your voice!!!

  • @xavierlarason4894
    @xavierlarason4894 5 ปีที่แล้ว

    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

  • @sophie1541
    @sophie1541 8 ปีที่แล้ว +2

    tears of joy

  • @lindahuang647
    @lindahuang647 8 ปีที่แล้ว

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

  • @taraalma2
    @taraalma2 8 ปีที่แล้ว

    Thank you. Really useful.

  • @aswathica508
    @aswathica508 7 ปีที่แล้ว

    Thankyou! It was a clear explanation.

  • @p1sces.g1rl
    @p1sces.g1rl 5 ปีที่แล้ว

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

  • @MrSupernova111
    @MrSupernova111 9 ปีที่แล้ว

    Awesome job! Thanks!!

  • @tjhanson9075
    @tjhanson9075 9 ปีที่แล้ว

    thank you Kevin Olson you know what a histogram is

  • @DaBraumaBull
    @DaBraumaBull 8 ปีที่แล้ว

    Thanks, this is incredibly helpful.

  • @wolfpackncsu2
    @wolfpackncsu2 6 ปีที่แล้ว

    Dude you the man, thanks so much!!!

  • @williamsonz5228
    @williamsonz5228 8 ปีที่แล้ว

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

  • @serialcode8030
    @serialcode8030 6 ปีที่แล้ว

    This was so helpful, thank you!

  • @DeathCon88
    @DeathCon88 10 ปีที่แล้ว +4

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

  • @heih3088
    @heih3088 9 ปีที่แล้ว

    Super helpful thanks so much!

  • @nathanmcintyre694
    @nathanmcintyre694 9 ปีที่แล้ว

    This video saved my life. thanks man!

  • @aishadanielle3552
    @aishadanielle3552 8 ปีที่แล้ว

    Thank You! This was great!

  • @madman9850
    @madman9850 9 ปีที่แล้ว

    How to do the interval column?
    When I did mine, 1-3,4-6,7-9,10-12, they change it to date 1/March, 4/June, 7/September, 10/December.
    What must I do to prevent the interval change to date?

  • @cooldudeyoucanhaveit
    @cooldudeyoucanhaveit 9 ปีที่แล้ว

    What if i have a smaller range of data sets? then haw would i arrange the numbers? Excel keeps telling me that my formula is insufficient.

  • @MistressAcid
    @MistressAcid 9 ปีที่แล้ว

    Thank you so much for this video!!

  • @g-mari9659
    @g-mari9659 10 ปีที่แล้ว

    that's genius buddy good work I love it!

  • @Adriana-qv7ej
    @Adriana-qv7ej 5 ปีที่แล้ว

    Thank you for this. I love you