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

Поділитися
Вставка
  • Опубліковано 24 лип 2016

КОМЕНТАРІ • 328

  • @viscinityofobscenity
    @viscinityofobscenity 4 роки тому +27

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

  • @AlexanderMoen
    @AlexanderMoen 5 років тому +9

    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!

  • @yadyavila5541
    @yadyavila5541 3 роки тому +28

    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 років тому +80

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

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

  • @edpollard2666
    @edpollard2666 4 роки тому +1

    Honestly, I never make UA-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.

  • @tokioobsessed1983
    @tokioobsessed1983 7 років тому +11

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

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

  • @micheleburgos8646
    @micheleburgos8646 5 років тому +1

    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 3 роки тому +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.

  • @amandac1961
    @amandac1961 3 роки тому

    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.

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

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

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

  • @__SAK__
    @__SAK__ 4 роки тому +6

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

  • @Chris_slavic_guy
    @Chris_slavic_guy 2 роки тому

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

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

  • @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! :-)

  • @B0ss7053
    @B0ss7053 2 роки тому

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

  • @bpk-dz5qc
    @bpk-dz5qc 4 роки тому

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

  • @mattfyfield
    @mattfyfield 5 років тому

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

  • @tiok163
    @tiok163 3 роки тому +2

    A literal lifesaver. A true Queen. Bless your soul

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

  • @samgakgimbap9683
    @samgakgimbap9683 7 років тому +30

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

  • @amandacummings3217
    @amandacummings3217 5 років тому

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

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

  • @tyronewallace6167
    @tyronewallace6167 4 роки тому +1

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

  • @Martinmr07
    @Martinmr07 4 роки тому +2

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

  • @VonGilletteFitness
    @VonGilletteFitness 5 років тому

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

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

  • @katherinelholloway
    @katherinelholloway 6 років тому

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

  • @firespirit81
    @firespirit81 6 років тому

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

  • @roxanamarquez7352
    @roxanamarquez7352 9 місяців тому

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

  • @tracygraham6529
    @tracygraham6529 Рік тому

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

  • @niro456
    @niro456 3 роки тому

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

  • @ProfBoggs
    @ProfBoggs 3 роки тому

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

  • @ronaldstimphil7039
    @ronaldstimphil7039 4 роки тому

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

  • @marvabooker1203
    @marvabooker1203 3 роки тому +1

    This presentation rescued me! Thank you!!!

  • @beanie7872
    @beanie7872 4 роки тому

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

  • @stash8158
    @stash8158 2 роки тому

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

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

  • @dinaraperera5825
    @dinaraperera5825 4 роки тому

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

  • @vidvid12345
    @vidvid12345 4 роки тому

    girl.... you saved my whole life.

  • @MissDem0nic
    @MissDem0nic 6 місяців тому

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

  • @carlos75224
    @carlos75224 6 років тому

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

  • @ronjohnson2719
    @ronjohnson2719 6 років тому

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

  • @celiamendez3063
    @celiamendez3063 2 роки тому

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

  • @summerxia7474
    @summerxia7474 Рік тому

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

  • @stillwaters0502
    @stillwaters0502 7 років тому +14

    wasted so much time elsewhere, you are awesome!

  • @BrianHarig
    @BrianHarig 6 років тому

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

  • @khairunnisakhairi2735
    @khairunnisakhairi2735 4 роки тому

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

  • @madaris0083
    @madaris0083 5 років тому

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

  • @tiafalkner8000
    @tiafalkner8000 3 місяці тому

    7 years later and this video actually saved me🙏

  • @jamespardue1467
    @jamespardue1467 4 роки тому +5

    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.

  • @tahraqapie4783
    @tahraqapie4783 6 років тому

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

  • @minhazjisan3074
    @minhazjisan3074 4 роки тому

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

  • @mbaniskitchen1237
    @mbaniskitchen1237 2 роки тому

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

  • @andreeaslinger1342
    @andreeaslinger1342 4 роки тому

    Extremely helpful. Thank you so much for this tutorial.

  • @dontjudgeme58
    @dontjudgeme58 4 роки тому

    This was really helpful. Thank you Ms. Chan!

  • @jamesperry3837
    @jamesperry3837 5 років тому +13

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

  • @louisvil9683
    @louisvil9683 2 роки тому

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

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

  • @ArseniCatnipp
    @ArseniCatnipp 2 місяці тому

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

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

  • @Lycheeee11
    @Lycheeee11 6 років тому

    The best tutorial for histogram in excel!

  • @eminguney8325
    @eminguney8325 4 роки тому

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

  • @MGBarkell
    @MGBarkell 3 роки тому +1

    Thank you Kwai, very simply done.

  • @david7508riggins
    @david7508riggins 3 роки тому

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

  • @oliverk1616
    @oliverk1616 3 роки тому

    One of the best tutorial videos!

  • @yiqingwang7591
    @yiqingwang7591 5 років тому

    It is so clear and detailed, thank you very much

  • @kirimcfarland8817
    @kirimcfarland8817 5 років тому

    Thank you so much for this, it was awesome and exactly what I needed :)

  • @poojaetty3450
    @poojaetty3450 4 роки тому +1

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

  • @fredahgabriel6416
    @fredahgabriel6416 3 роки тому +1

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

  • @kingdavidyt3961
    @kingdavidyt3961 3 роки тому

    Thanks for this amazing video.
    Clear and well explained.

  • @AlvorReal
    @AlvorReal 3 роки тому +1

    Absolute godsend. Thank you so, so, so much.

  • @wanovskaya
    @wanovskaya 2 роки тому

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

  • @jacobslade3482
    @jacobslade3482 Рік тому

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

  • @bbc34
    @bbc34 6 років тому

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

  • @mariamcconville2594
    @mariamcconville2594 7 років тому +1

    Thankssss just wonderful. Better than the book.

  • @sheenarobbie2937
    @sheenarobbie2937 3 роки тому

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

  • @peters1521
    @peters1521 7 років тому

    I really appreciate your video, thanks for helping me out

  • @TheSilentWalkerz
    @TheSilentWalkerz 5 років тому +1

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

  • @sammiekayfoxx
    @sammiekayfoxx 5 років тому

    thank you so so much this was extremely helpful. It made perfect sense:)

  • @sinthyiaahmed5234
    @sinthyiaahmed5234 4 роки тому

    You are a life savior! Thank you

  • @EvatheDiva00
    @EvatheDiva00 7 років тому +4

    this was so helpful! thank you!

  • @fruitpunch-mouth
    @fruitpunch-mouth 3 місяці тому

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

  • @eugenielagrange7803
    @eugenielagrange7803 5 років тому

    This helped me so much. Thank you!

  • @pin3appl3man
    @pin3appl3man 2 роки тому

    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!

  • @maheshwarbanuk4389
    @maheshwarbanuk4389 4 роки тому

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

  • @thomaswilson6775
    @thomaswilson6775 3 роки тому

    Clear and concise -- well done!

  • @martintraseas7514
    @martintraseas7514 Рік тому +1

    Simple explained yet life saving..Asante😊

  • @elianniel5586
    @elianniel5586 3 роки тому +1

    Thank you for this video! It truly helped me

  • @bing434
    @bing434 6 років тому

    Thank you so much. I was wondering why my data wasn't being represented properly in the frequency table (it always missed the top row of data), and it was because I wasn't selecting 'Labels' and then including the labels for the data set and the bin range.

  • @radiowalker88
    @radiowalker88 6 років тому

    Thank you so much. Greetings from Peru

  • @babakjahed
    @babakjahed 4 місяці тому

    Thank you so much, your explanation is lovely.

  • @lalad4671
    @lalad4671 2 роки тому

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

  • @junjie2525
    @junjie2525 4 роки тому

    Brillant! You're a lifesaver!

  • @quinnquynguyen8129
    @quinnquynguyen8129 5 років тому

    You helped me get my engineering degree!

  • @ivanmurdock7328
    @ivanmurdock7328 5 років тому

    This is a great format and easy - Thank you