Calculating Mean, Median, Mode, & Standard Deviation in Excel

Поделиться
HTML-код
  • Опубликовано: 22 авг 2024

Комментарии • 273

  • @femiairboy94
    @femiairboy94 8 лет назад +242

    You just saved 3 hours of my life, God bless you.

    • @dallasoscar2159
      @dallasoscar2159 3 года назад +1

      I know im asking randomly but does anyone know a trick to get back into an instagram account..?
      I somehow forgot my login password. I love any tricks you can give me!

    • @duncanjaxson8422
      @duncanjaxson8422 3 года назад

      @Dallas Oscar Instablaster =)

    • @dallasoscar2159
      @dallasoscar2159 3 года назад

      @Duncan Jaxson i really appreciate your reply. I got to the site on google and im in the hacking process atm.
      Takes a while so I will reply here later when my account password hopefully is recovered.

    • @dallasoscar2159
      @dallasoscar2159 3 года назад +1

      @Duncan Jaxson it worked and I finally got access to my account again. I'm so happy!
      Thank you so much you really help me out !

    • @duncanjaxson8422
      @duncanjaxson8422 3 года назад

      @Dallas Oscar You are welcome :D

  • @tawniabailey7509
    @tawniabailey7509 3 года назад +31

    You just saved me ! I started applied statistics and I am so in the world of the unknown for excel. Great video it turned out to be a simple way to get those. Other videos were very hard to understand.

  • @lavenvideos
    @lavenvideos 7 лет назад +20

    Thank you!!!! I've spent hours upon hours on my statistics assignments doing them all by hand!!! I don't know why it didn't occur to me sooner to do it in Excel! Thank you for this video!

  • @tsanders6876
    @tsanders6876 2 года назад +10

    OMG!!! You just helped me soooooooo much! Thank you!!! I just learned something in 5 minutes that my professor hasn't been able to show me in 5 weeks.

  • @deebrantley4933
    @deebrantley4933 8 лет назад

    DO NOT LISTEN TO ANYONE WHO TELLS YOU THIS DIDN'T HELP THEM!! I LOVE YOU AND DON'T KNOW YOU! YOU HAVE SAVED ME IN STATISTICS AND I APPRECIATE IT SO VERY MUCH. You are a blessing!

  • @reginaldshields5445
    @reginaldshields5445 6 лет назад +3

    I have been terrified of statistics for a few years, in fact i took the class 2 years ago and dropped it, had a teacher with a serious foreign accent and he was monotone, I SUFFERED!! I'M JUST TAKING THE CLASS AGAIN AND YOU MAKE IT SO SIMPLE, I AINT SCARED NO MORE!!! (SLANG TERM) LOL

  • @ricksterzx
    @ricksterzx 8 лет назад +9

    Dan,
    Just a note to say thank you for the excellent video this is put together made simple and user friendly. Thank You and Thank You again

  • @thenitcomestobe7828
    @thenitcomestobe7828 4 года назад +1

    Or: File -> Options -> Add-ins: enable analysis toolpak. Ok. -> Data -> Data Analysis -> Descriptive Stats -> enable Summary Stats, Ok. Now you don't even need the formulas, and it automatically populates into a formatted table. This saved me during grad stats and research methods.

  • @franbrisco2134
    @franbrisco2134 7 лет назад +1

    I truly love you! You have no idea what you have done for me. Bless you!

  • @nigelparish2631
    @nigelparish2631 8 лет назад

    Really very very good. My heart usually sinks when I look at these kind of tutorials because they are dull. The subject matter is dull. The presenter is dull. The monotone voice is dull. Even the language is dull.
    However this video just hits the right tone throughout. Very well presented, crystal clear instructions too.
    Thank you Dan

  • @vanessaburgess3534
    @vanessaburgess3534 8 лет назад +8

    I'm really happy his picture is in the corner because it was nice to finally understand something and have acute guy watch me while I do it too

    • @ilsabelle
      @ilsabelle 4 года назад

      lol.... that too!

  • @gentlefistinfinity9780
    @gentlefistinfinity9780 4 года назад +6

    Thank you man, I really appreciate this. I am now learning Biostatistics and I needed to learn how to do this.

  • @dr.winstonsmith
    @dr.winstonsmith 6 месяцев назад

    Very well explained and straight to the point. Thank you!

  • @chocolateluvable
    @chocolateluvable 8 лет назад +1

    Used to be freaked out about the word 'excel', this video was very helpful. Thank you so much.

  • @johndurocher9571
    @johndurocher9571 11 лет назад +1

    thank you, I have looking for help with this for 4 hours. you are the first one I found to explain it in a way I understand. I might just pass my statistics class.

  • @aarontraub2596
    @aarontraub2596 9 лет назад +5

    beat excel tutorial ive ever seen. thanks Dan!

  • @laishamoodley966
    @laishamoodley966 8 лет назад

    Excellent! Now I don't need to pay consultants for such simple stats! I just tested it on my data, thank you very much!

  • @samiullafarhat9029
    @samiullafarhat9029 3 года назад +5

    This is fantastic mate - definitely a thousand times better than slogging books and articles. Hope you publish more useful videos like this.

  • @valeriereid2337
    @valeriereid2337 Год назад

    Your video was very helpful. Clear, concise, straightforward.

  • @sandavijithmini3463
    @sandavijithmini3463 2 года назад

    Very helpful and very clear. As an asian, Love your accent as well 😍

  • @alishakingston4343
    @alishakingston4343 3 года назад +1

    Thank you a million. Wanted a quick refresher and this did it just fine.

  • @elizabethatoyebi6856
    @elizabethatoyebi6856 3 года назад

    I had watched many videos, but this one makes it simple, and clear to understand. Thanks

  • @NicholasNormile
    @NicholasNormile 8 лет назад +12

    Very helpful. This is a massive time and mistake saver for me : )

  • @syafinazramli4841
    @syafinazramli4841 3 года назад

    you just saved my life and upgrade my excel skills. Thank you, God bless you

  • @0verIOrd
    @0verIOrd 4 года назад +1

    Ur a life saver dude god bless u

  • @heez4023
    @heez4023 2 года назад +1

    Thanks for this, doing an assignment and this got me an easy 3 marks with your info, life saver

  • @Aileenwasright
    @Aileenwasright 2 года назад

    omg I saw someone do this before but had forgotten. Thank you so much, this will save me so much time.

  • @corymartin8158
    @corymartin8158 6 лет назад

    Missed one class and it just so happen to be the class where he taught all the formulas for this. Next class I was stuck on excel like WHAAAAAT!!! Got it now! Thanks!

  • @Rootemusbob
    @Rootemusbob 9 лет назад +20

    Thank you God! Finally! Something I can understand. You saved me! :)

    • @danrott1469
      @danrott1469 9 лет назад +1

      You are welcome, glad it was helpful!

    • @yulisingles
      @yulisingles 8 лет назад

      +Dan Rott Same here! Thanks)))

  • @muhammadjaved9169
    @muhammadjaved9169 8 лет назад +1

    Sir u r great. May Allah give u more and more knowledge and heaven.

  • @jalen7690
    @jalen7690 8 лет назад +28

    Currently in Business Statistics. Thanks!!!!!

  • @shiladityamisra3829
    @shiladityamisra3829 2 года назад

    Seriously thank you.. You saved a lot of my time..

  • @noelkaupa6532
    @noelkaupa6532 3 года назад +1

    This video really help me in completing my assignment, thank you more.

  • @harrypertzel6698
    @harrypertzel6698 9 лет назад

    i have a statistics project on excel and i had no idea how to do this thank you so much you are a legend

  • @getrudenamonje5915
    @getrudenamonje5915 3 года назад +1

    Thanks very much, this video has been very helpful. 👌👌👌

  • @diegolovon1504
    @diegolovon1504 5 лет назад +1

    good bless you bro, you just saved 2 hours of my life

  • @laurascap74
    @laurascap74 9 лет назад

    Loved the yellow circle! Helpful!

  • @sumitjadhav5084
    @sumitjadhav5084 2 года назад

    Thank you so much!... You just saved my valuable time and money too!.... God bless you! 🙏🏻

  • @ilsabelle
    @ilsabelle 4 года назад

    Thank you so much! My classmates and I are forever thankful to you!!!

  • @ricksorkin2522
    @ricksorkin2522 3 года назад

    Very well explained and quick
    Thx for posting the video

  • @archersunshine8890
    @archersunshine8890 2 года назад +1

    Thank you so much for this video! You’ve certainly taught me some things in a way that’s easy to understand.

  • @juliahossain
    @juliahossain 3 года назад

    Thank you..you made it so easier for me..I was doing compensation benefit calculation all by hand...

  • @vthefashionista
    @vthefashionista 7 лет назад +1

    This was amazing! And just in time for my meeting! The 25 people who downvoted you are clearly haters.

  • @julianacardon8869
    @julianacardon8869 4 года назад

    Bless you. You just made my soil homework so much easier

  • @johannaguzman9521
    @johannaguzman9521 3 года назад

    You are my hero right now, thank you.

  • @connorbell9893
    @connorbell9893 3 месяца назад

    god bless you dan, hope lifes good man!

  • @Zero
    @Zero 9 лет назад

    This video was a great help on a Home Work assignment , Thank You

  • @princesingla6533
    @princesingla6533 5 лет назад +2

    Skip to 1:48 for you problem and save time

  • @galaxygamers7492
    @galaxygamers7492 Год назад

    straight to the point, thank you

  • @jasminemurphy4749
    @jasminemurphy4749 4 года назад

    I literally could hug you right now thank you!

  • @7mood3ido22
    @7mood3ido22 2 года назад

    Ty sm bro this was very helpful n straight to thr point, big love🤞

  • @AscensionINC-zi1jz
    @AscensionINC-zi1jz 5 лет назад

    Nice concise video more clear than some lectures at university lol.

  • @ottothomsen4186
    @ottothomsen4186 7 лет назад

    youre an heaven sent! :) you just saved me a whole lot of errors and time. Now i can study for my other class. thank you!

  • @sheenamaedearca5960
    @sheenamaedearca5960 3 года назад

    Amazing!!! Now I know how to answer my Assignment 😍Thank you.

  • @miraj6272
    @miraj6272 3 года назад

    Goddamit youtube tutorials are better than uni lectures

  • @alishalalljee2280
    @alishalalljee2280 2 года назад

    You are a genius
    God bless you

  • @umarg06
    @umarg06 7 лет назад

    You have just got me a pass on my degree, god bless you mate thanks !

  • @Erbil1980
    @Erbil1980 7 лет назад

    So professional of you, you made my day.

  • @pranavprameshgandhi9392
    @pranavprameshgandhi9392 3 года назад

    Thankyou bro...u saved a lot of my time

  • @FaisalFaisal-xg3ld
    @FaisalFaisal-xg3ld 4 года назад

    thank you so much this helped a lot. From a typical statistical point of view which STD option would be more accurate.

  • @theodorehagan8732
    @theodorehagan8732 4 года назад

    YES You just saved me an entire day. Great video

  • @s.mohansundar1038
    @s.mohansundar1038 3 года назад

    WAS STRUGGLING WITH THIS FOR LONG DAYS THQQQ SOO MUCHHHH GOD BLESS U

  • @ronquindoza4716
    @ronquindoza4716 3 года назад

    thank you sir for this video, this is very helpful for beginners in excels just like me.

  • @udawa
    @udawa 4 года назад

    Excellent sir..! keep it up..!

  • @elliottsquire2440
    @elliottsquire2440 2 года назад

    very helpful !! thank you so much I finally kinda can get my head round this now !

  • @marinatheresedelatorre657
    @marinatheresedelatorre657 9 лет назад +1

    thank u so much. using this for my data analysis, chapter 3 in thesis

    • @edken45
      @edken45 9 лет назад

      Same here. Ever need a study buddy through skype or something please let me know

  • @harkorede5601
    @harkorede5601 3 года назад

    God bless you I have been struggling with this for so long😭😭🙏

  • @yemiola7581
    @yemiola7581 2 года назад

    I am impressed, very easy! Thanks.

  • @mrRobinPollard
    @mrRobinPollard 6 лет назад

    Great Video, really straight forward and to the point.

  • @rosellarose2085
    @rosellarose2085 2 года назад

    Thank you sir, you saved my life

  • @lalruatmawiihnamte9389
    @lalruatmawiihnamte9389 3 года назад

    It helps me a lot..... Thank you so much

  • @bharadwajvemavarapu6539
    @bharadwajvemavarapu6539 8 лет назад

    Thanks a lot ,its very useful...and saved a lot of time.

  • @LAFONESS
    @LAFONESS 9 лет назад +5

    THANK YOU, YOU MADE MY DAY!

  • @shaykashif
    @shaykashif 2 года назад

    video is 8 years old. Still works.

  • @karenh2661
    @karenh2661 6 лет назад

    thank you so much for an easy to follow example!

  • @nadyaomar9155
    @nadyaomar9155 8 лет назад

    thank u . ur way in explaining the method it is great.

  • @j3musicals
    @j3musicals 3 года назад

    Subscribed and shared

  • @BigJackkkt
    @BigJackkkt 3 года назад

    Lifesaver, thank you man!

  • @stellalee6976
    @stellalee6976 6 лет назад +1

    Thank you ! You saved my final project xD

  • @javedmalik1922
    @javedmalik1922 Год назад

    Nice way of delivering 👌🏻

  • @CPRJnuski
    @CPRJnuski 3 года назад

    you looked out for us then good shit 💯

  • @miranda5237
    @miranda5237 3 года назад

    Thank you so much! so helpful for Uni assignment

  • @gumamelaflower7629
    @gumamelaflower7629 7 лет назад

    Thank you so much! You are a big HELP!

  • @morobl350
    @morobl350 8 лет назад

    Thank you so much! Clear and simple video, I love it.

  • @FamousAmos2000
    @FamousAmos2000 5 лет назад

    Thank you, so much!! Quick and easy to understand!

  • @durgadevi9548
    @durgadevi9548 7 лет назад

    Thank you. The video was so useful for me.

  • @mohamedabdelfattah2624
    @mohamedabdelfattah2624 2 года назад

    Thank you for the great video! I am wondering if there is a mean between how often two or more numbers have been selected when the dataset is skewed.

  • @joarsal4126
    @joarsal4126 2 года назад

    The first shortcut of 1, 2, 3 and bam! here i hit the subscribe button

  • @bdrllc3301
    @bdrllc3301 9 лет назад

    Great job, thank you very much. Easy to follow instructions

  • @shannonbass5202
    @shannonbass5202 4 года назад

    You somehow managed to make computing in excel fun!

  • @tsun4ami
    @tsun4ami 2 года назад

    you are an angel...thank you...sm...

  • @thelmasantos4841
    @thelmasantos4841 4 года назад

    Thanks. May I use this for my class. Will acknowledge your work.

  • @kingsiver8662
    @kingsiver8662 3 года назад

    thank you so much this is very helpful

  • @volkertlopes8768
    @volkertlopes8768 9 лет назад

    This was extremely helpful and very easy to understand. Thanks alot!!

  • @ranjeetmishra3778
    @ranjeetmishra3778 3 года назад

    Now, I understand how we can use Excel. As statistics

  • @johnmanohar5680
    @johnmanohar5680 2 года назад

    I have been trying this for a very long time but in vain.
    Your video lecture has helped me in understanding the concepts and how to calculate the MEAN, MEDIAN, MODE and STD. DEVN.
    However, now I am stuck with STANDARD ERROR OF SKEWNESS and STANDARD ERROR OF KURTOIS.
    Can you suggest your video if any on the above?

  • @PabloBussin
    @PabloBussin 4 года назад

    great vid, you clutch asf my boy

  • @ImPacmanOnYoutube
    @ImPacmanOnYoutube 7 лет назад

    Thank you! Simple and short! 👏👏👏

  • @gelilawitasefa6247
    @gelilawitasefa6247 2 года назад

    This is so brilliant! Thank you

  • @fadfadsfaefew
    @fadfadsfaefew 8 лет назад

    Dan, Perfectly explained! thx