Use Excel 2016 to make Frequency distribution and Histogram for quantitative data

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

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

  • @yadyavila5541
    @yadyavila5541 4 ปีที่แล้ว +32

    BEST tutorial ever!! I'd been struggling for hours and this really helped me. I could not have completed my assignment without watching this. Thank you so much!!

  • @markhalter459
    @markhalter459 7 ปีที่แล้ว +83

    Thanks so much. Wish I had found this video first, instead of all the wasted time I spent elsewhere!

  • @viscinityofobscenity
    @viscinityofobscenity 4 ปีที่แล้ว +29

    Wow, you actually show the steps in a way that is very understandable, thank you so much!

  • @edpollard2666
    @edpollard2666 4 ปีที่แล้ว +1

    Honestly, I never make TH-cam comments but this is genuinely the most simple and easiest tutorial for this, been watching so many other videos and just getting confused!! This has helped me millions, thank you.

  • @WilsonMar1
    @WilsonMar1 7 ปีที่แล้ว +7

    This video covers more techniques and in less time than others of the same topic. And the explanation seems more logically sequenced. Bravo, Kwai.

  • @micheleburgos8646
    @micheleburgos8646 5 ปีที่แล้ว +2

    You have really made this much simpler for me. I could not understand anyone before I found this video. Thank God for you

  • @debbiebesley2768
    @debbiebesley2768 4 ปีที่แล้ว +12

    I have struggled with histograms for the last 3 weeks. I am glad that I found your video. You made it seem so easy. Thank you very much.

  • @Danielle.theseer
    @Danielle.theseer 2 ปีที่แล้ว +1

    Thank you!!!! I have a professor that chose to do multiple excel assignments without telling us how to use it! I shouldn’t have to search youtube for hours, but I’m happy I found your page.

  • @roxanamarquez7352
    @roxanamarquez7352 ปีที่แล้ว +3

    Thank you so much. You explained what my instructor could not explain in 90 minutes.

  • @amandac1961
    @amandac1961 4 ปีที่แล้ว

    Thanks Kwai, I keep coming back to your video to remind me how to do this. Your voice is clear, your demo is concise. You have helped me communicate my data better.

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

    Thank you thank you thank you!!!!!! I’ve been searching for this for hours 😭😭 I knew when my professor wanted, but I didn’t know how to do it and couldn’t find any information how to. I’ve been searching the internet just to be frustrated. Finally I found this gem and i can finally finish my assignment. After hours of tears and frustration, I can get things done and rest. THANK YOU!

  • @AlexanderMoen
    @AlexanderMoen 5 ปีที่แล้ว +11

    I've been banging my head against a wall with these other websites that weren't clear and I couldn't get my frequency distributions correct. Thank you so much for such a clear video!

  • @renettahill2816
    @renettahill2816 5 ปีที่แล้ว +21

    Thank you for posting. This video is outstanding. You explained everything with such ease. And the pace that you performed the steps was great. I was able to go step by step along with you and complete my chart just as your completed yours. Great video....Thanks again

  • @tiok163
    @tiok163 3 ปีที่แล้ว +2

    A literal lifesaver. A true Queen. Bless your soul

  • @B0ss7053
    @B0ss7053 3 ปีที่แล้ว

    Currently taking an online data analytics course and this video gave me more insight than my professor could.

  • @__SAK__
    @__SAK__ 4 ปีที่แล้ว +6

    I appreciate the level of detail in this tutorial - this is very useful, thank you.

  • @tokioobsessed1983
    @tokioobsessed1983 7 ปีที่แล้ว +11

    The MOST helpful tutorial I've seen. Thank You!

  • @Chris_slavic_guy
    @Chris_slavic_guy 3 ปีที่แล้ว

    One of the best tutorials on the topic of histograms in excel. Love it!

  • @sussy9ful
    @sussy9ful 2 ปีที่แล้ว

    Thank you so much! I have been trying to figure this out for two days now, and thanks to this tutorial I was able to finish my assignment. Thank you! The best explanation!

  • @tinamarieehenderson8615
    @tinamarieehenderson8615 5 ปีที่แล้ว +11

    Thank you so much for this. The one my prof. gave me was for a different version and it didn't help much. You were a life saver

  • @samgakgimbap9683
    @samgakgimbap9683 7 ปีที่แล้ว +30

    Thank you So much :) So much help for my first university statistics assignment :)))

  • @niro456
    @niro456 4 ปีที่แล้ว

    Best tutor. With one vid I could finish most of my assignment

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

    i have been struggling on this for hours and you have been the only channel to help me. thank you so much!

  • @stash8158
    @stash8158 2 ปีที่แล้ว

    I wasted so much time on this and you made it look so easy seriously thank you for this video!

  • @Martinmr07
    @Martinmr07 4 ปีที่แล้ว +2

    From the bottom of my heart, I want to to thank you!. You helped me so much, thank you!!!.

  • @robertrussell4549
    @robertrussell4549 5 ปีที่แล้ว +3

    Really great tutorial--I have to use this function for a school project, and the tutorial they provided looked like it was using an Excel version that was probably from the 1980's, so a newer video was extremely helpful.

  • @tyronewallace6167
    @tyronewallace6167 4 ปีที่แล้ว +1

    Honestly, thank you so much, you helped me heeeeeeeaps during my Business Anaylitics module for my masters degree !!! greatly appreciated

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

    Thank you Ms. Chan. You are a great teacher. This was a fantastic video, step by step.

  • @jamespardue1467
    @jamespardue1467 4 ปีที่แล้ว +6

    Hey if anyone is having trouble finding the data analysis you need to set it as an add on.
    1. Click the File button in the top left then go down to options
    2. A window should appear then you should see add-ins on the left
    3. Once you click it there should be a box at the bottom with Excel Add-Ins in it. Press the go button next to it
    4. Finally a window should appear with empty checkboxes. You want to check the one that says "Analysis Tool Pack"
    Once you do this the data analysis option should appear on the far right under the data tab like in the video.

  • @MissDem0nic
    @MissDem0nic 10 หลายเดือนก่อน

    bless you kwai, my professors video made it so confusing but you made this so clear

  • @Lyle_Plays
    @Lyle_Plays 3 ปีที่แล้ว

    Thank you so much! Video is short, helpful, clear and concise! You get straight to the point and even give additional tips!! Thank you again

  • @mugenjin205
    @mugenjin205 3 ปีที่แล้ว

    This was very helpful, I liked that she got right to the point every action was clear and understandable. Thank You very much!

  • @ArseniCatnipp
    @ArseniCatnipp 6 หลายเดือนก่อน

    thank you so much!! my professor SUCKS at teaching, this video saved my life!

  • @ProfBoggs
    @ProfBoggs 3 ปีที่แล้ว

    This is a good demonstration. I'd forgotten about the Data Analysis tool. Thank you!

  • @jo3608
    @jo3608 6 ปีที่แล้ว +1

    Thank you so very much for your detailed instructions. I really appreciate you explaining the nuances that are specific to Excel such as how to enter the Bin data. You have really helped me understand how to navigate through this software! Cannot thank you enough! :-)

  • @bpk-dz5qc
    @bpk-dz5qc 4 ปีที่แล้ว

    This is life-saving! Best explanation by far. Thank you!

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

    really nice! easy. there was another guys was use some stupid functions. her videos are much simple and she actually uses the tool that you are looking for. not showing her own ways but universal ways. amazing !

  • @vidvid12345
    @vidvid12345 4 ปีที่แล้ว

    girl.... you saved my whole life.

  • @pin3appl3man
    @pin3appl3man 3 ปีที่แล้ว

    I can't believe my dumb ass just spent the last hour trying to figure out what I was doing wrong, then I watch your video and see I'm just forgetting to hit the Chart Output box. Thanks Kwai!

  • @celiamendez3063
    @celiamendez3063 3 ปีที่แล้ว

    Thank you for being a life save for my college class!

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

    Absolute gold. Perfect how to video. No wasted time, job done! Thanks heaps!

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

    Thank you so much. You saved me with my hw. I wish you were my teacher right now.

  • @Dhardblessed
    @Dhardblessed 4 ปีที่แล้ว

    Thank you so much for this video it helps me sooooooo much, with the step by step. I wouldn't of have complete my homework without your video. Keep up the greatttt work.

  • @tiafalkner8000
    @tiafalkner8000 7 หลายเดือนก่อน

    7 years later and this video actually saved me🙏

  • @ronaldstimphil7039
    @ronaldstimphil7039 4 ปีที่แล้ว

    Thank you Kwai. You helped us greatly my colleagues and me. We are grateful.

  • @stillwaters0502
    @stillwaters0502 7 ปีที่แล้ว +14

    wasted so much time elsewhere, you are awesome!

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

    Best tutorial I have ever had! Could you please make more of this kind of video? Thanks!!!!

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

    Finally a good tutorial. You saved me thanks so much this was exactly what i needed

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

    Great video, I found how to set up everything in Excel, and the process was very straightforward.

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

    Thanks so much you're best programmer of excel I saw kwai

  • @mbaniskitchen1237
    @mbaniskitchen1237 3 ปีที่แล้ว

    the most satisfying video i have watched today. Thankyou so much

  • @stephaniea.jimenezcontrera159
    @stephaniea.jimenezcontrera159 3 ปีที่แล้ว +1

    I had some issues that I didn't know where they were coming from, until now...Cheers from Honduras!

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

    Simple explained yet life saving..Asante😊

  • @jamesperry3837
    @jamesperry3837 5 ปีที่แล้ว +13

    *In this 6 min video u said it all.* 👏 TᕼᗩᑎK YOᑌ💖💖💖

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

    Thank you so much! This helped me way more than the handouts my tutor gave the class!

  • @ajk9420
    @ajk9420 3 ปีที่แล้ว +1

    Thank you so much! Now that most of school is online teachers really slacking... smh Thank you again.

    • @ajk9420
      @ajk9420 3 ปีที่แล้ว

      Had to come back

  • @oliverk1616
    @oliverk1616 3 ปีที่แล้ว

    One of the best tutorial videos!

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

    Great explanation of this topic. It's finally starting to make sense - thank you!

  • @louisvil9683
    @louisvil9683 2 ปีที่แล้ว

    I’ve been struggling with this for a while now
    Thanks🙏

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

    Thank you so much, you helped me get a 100 on my excel assignment!

  • @beanie7872
    @beanie7872 4 ปีที่แล้ว

    Thank you so much! I almost gave up on this assignment. You're awesome!

  • @minhazjisan3074
    @minhazjisan3074 4 ปีที่แล้ว

    Very helpful. Thanks, you're better than my instructor

  • @khairunnisakhairi2735
    @khairunnisakhairi2735 4 ปีที่แล้ว

    I understand your video better and in a simple way! thank you so much!

  • @marvabooker1203
    @marvabooker1203 4 ปีที่แล้ว +1

    This presentation rescued me! Thank you!!!

  • @fredahgabriel6416
    @fredahgabriel6416 4 ปีที่แล้ว +1

    Dear Kwai, thank you so much for the video. It helped me a lot.

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

    Thank you so much. I did not have analysis enabled and was getting super frustrated. Thanks again!

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

    The best tutorial for histogram in excel!

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

    You helped me get my engineering degree!

  • @mychatpalace
    @mychatpalace 7 หลายเดือนก่อน

    well here;s a video i will be watching often. idk how often but enough to remember somewhat.

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

    omg your voice is so cute, thank you so much!

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

    you are amazing, you make it very easy and quite to the point, thank you Best Teacher.

  • @pharma8975
    @pharma8975 2 ปีที่แล้ว

    Simply worked well Ms.Kwai chan

  • @LichaRozeleOfficial
    @LichaRozeleOfficial 2 ปีที่แล้ว

    thank youuuuuuu you have saved my career!

  • @MGBarkell
    @MGBarkell 4 ปีที่แล้ว +1

    Thank you Kwai, very simply done.

  • @TheSilentWalkerz
    @TheSilentWalkerz 5 ปีที่แล้ว +1

    Thank you so much, I wasted so much time but no one did it by range

  • @dinaraperera5825
    @dinaraperera5825 4 ปีที่แล้ว

    Thank you very much for the clear instructions uve given here. God bless you♥️

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

    thanks kwai, you will have a lot snacks in heaven, video helped alot

  • @timothymordechai7038
    @timothymordechai7038 2 ปีที่แล้ว

    thank you so much dear kwai chan, you are a savior

  • @david7508riggins
    @david7508riggins 4 ปีที่แล้ว

    Thank you so much! Your step by step made it very helpful!!

  • @poojaetty3450
    @poojaetty3450 5 ปีที่แล้ว +1

    Thank you so much ma'am.
    You saved my life

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

    Kwai that was a dope video! Thanks for the upload and keep the amazing excel videos coming!

  • @wanovskaya
    @wanovskaya 2 ปีที่แล้ว

    Thank you very much! You helped me out with my statistic project!

  • @sheenarobbie2937
    @sheenarobbie2937 3 ปีที่แล้ว

    Thank you so much!!!! This has helped me with my data analysis homework!!

  • @kingdavidyt3961
    @kingdavidyt3961 3 ปีที่แล้ว

    Thanks for this amazing video.
    Clear and well explained.

  • @jackheavell6318
    @jackheavell6318 3 ปีที่แล้ว

    you saved my life, i am forever in your debt

  • @lubinlewis4047
    @lubinlewis4047 4 ปีที่แล้ว +2

    Awesome. Great Video.

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

    Great! How can I do this with data that keeps being updated? It seems the Data Analysis only happens once. Any tips?

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

    Very well put together, easy to follow. Thank you very Much!

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

    You are wonderful... Explained it so nice and easy!

  • @thomaswilson6775
    @thomaswilson6775 3 ปีที่แล้ว

    Clear and concise -- well done!

  • @gloystar
    @gloystar 2 ปีที่แล้ว

    Well actually had you done it with pivot table it would have saved you a lot of time and effort, but your method is valid too.

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

    Thank you, Mrs. Chan, a very good video indeed!!

  • @andreeaslinger1342
    @andreeaslinger1342 4 ปีที่แล้ว

    Extremely helpful. Thank you so much for this tutorial.

  • @pepeperoni2032
    @pepeperoni2032 2 ปีที่แล้ว

    Thank you so so so so much I learned how to do it!!!!!!!!!!!!

  • @sinthyiaahmed5234
    @sinthyiaahmed5234 4 ปีที่แล้ว

    You are a life savior! Thank you

  • @lalad4671
    @lalad4671 2 ปีที่แล้ว

    You're a LIFESAVER!!! Thank you for explaining and sharing!

  • @mariamcconville2594
    @mariamcconville2594 7 ปีที่แล้ว +1

    Thankssss just wonderful. Better than the book.

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

    This was really helpful. Thank you Ms. Chan!

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

    It is so clear and detailed, thank you very much

  • @hussam710
    @hussam710 3 ปีที่แล้ว

    Very very useful, thank a lot Kwai