How To Perform Descriptive Statistics In Excel (Very Easy!)

Sdílet
Vložit
  • čas přidán 14. 07. 2024
  • In this tutorial, I'll show you how to perform descriptive statistics by using Microsoft Excel. You can perform some descriptive statistics really easy in Excel by using the data Analysis ToolPak.
    VIDEO CHAPTERS
    00:00 Intro
    00:32 Installing the data Analysis ToolPak
    01:17 Performing the descriptive statistics
    02:51 Interpreting the results
    07:45 Wrapping up
    ONLINE GUIDE
    toptipbio.com/descriptive-sta...
    HOW I CREATED THIS TUTORIAL (AFFILIATE LINKS)
    Screen recorder & editor techsmith.z6rjha.net/c/198849...
    CZcams SEO www.tubebuddy.com/SHTeach
    Software (Microsoft Excel 365 ProPlus)
    FOLLOW US
    Website toptipbio.com/
    Facebook / toptipbio
    Twitter / toptipbio
    AFFILIATE DISCLAIMER
    Some of the above links are affiliate links, meaning I will earn a commission if a sale is made after clicking on the link.
  • Jak na to + styl

Komentáře • 48

  • @StevenBradburn
    @StevenBradburn  Před 2 lety +1

    ONLINE GUIDE
    toptipbio.com/descriptive-statistics-excel/

    • @user-ew7be1fc9b
      @user-ew7be1fc9b Před 3 měsíci

      @StevenBradburn My output gives a mode value of #N/A. Why is that?

  • @thekingwoman__
    @thekingwoman__ Před rokem +12

    For an absolute novice in Data analysis. This was super helpful

  • @melg.7587
    @melg.7587 Před 9 měsíci +1

    Was going crazy when I couldn't find the Data Analysis, didn't know it was an add on! Thank you so much for the help!

  • @wagnermedeiros8955
    @wagnermedeiros8955 Před rokem +3

    Ow aleluia, you save my scientific project man, thanks! Very useful.

  • @nikitasanze5004
    @nikitasanze5004 Před rokem +1

    This video just met my need. Thank you 😊

  • @najmaleley1489
    @najmaleley1489 Před 2 lety +2

    Very helpful video, thank you very much!

  • @vicentmoyo2109
    @vicentmoyo2109 Před 9 měsíci +3

    Useful indeed, thank you

  • @williamnash9806
    @williamnash9806 Před 2 lety +1

    Great, great video!! Helped me out big time!

  • @user-bg3bv2fn8l
    @user-bg3bv2fn8l Před 8 měsíci

    This was super helpful for me!

  • @samueljames9270
    @samueljames9270 Před rokem

    Great video helped me a lot !

  • @dr.tanushreedutta4861
    @dr.tanushreedutta4861 Před 5 měsíci

    Very nicely explained. Thank you sir.

  • @Vivifarma
    @Vivifarma Před měsícem

    Great video! Congrats!

  • @theIsayevs
    @theIsayevs Před 28 dny

    thank you!

  • @priyanshijoshi1394
    @priyanshijoshi1394 Před 2 měsíci

    Very good work. Keep it up

  • @mubarakhassan4533
    @mubarakhassan4533 Před 5 měsíci

    great tutorial

  • @moses3224
    @moses3224 Před 11 měsíci

    Love this

  • @katherinepaciera9213
    @katherinepaciera9213 Před 4 měsíci

    so glad you speak English!

  • @rockybhala3924
    @rockybhala3924 Před 9 měsíci

    very help much good

  • @felsal20
    @felsal20 Před 2 měsíci

    Thanks!

  • @damarispitts2470
    @damarispitts2470 Před 6 měsíci

    THANK YOU! Could not find the Data Analysis option. I had yet to learn it was an add-in!

  • @abirkhechiba8547
    @abirkhechiba8547 Před 2 lety

    Thank you very much

  • @QuelMiddleton
    @QuelMiddleton Před 4 měsíci

    thank you

  • @johnkupa8885
    @johnkupa8885 Před rokem

    Thanks

  • @chomphunuchsongsiriritthig8424

    Thanks for your helpful demo. Can one perform PCA by using excel, please?

  • @brightbentil6598
    @brightbentil6598 Před 11 měsíci

    can you please do one for grouped data

  • @Veenamega
    @Veenamega Před 2 lety +1

    Hi ,i have a doubt I got to work with 4 Diff companies stock price should we project descriptive statistics individually .or once

  • @NANAKOFIWOOD
    @NANAKOFIWOOD Před 19 dny

    Genius😅

  • @rahulchowdhury1839
    @rahulchowdhury1839 Před rokem

    best

  • @soleblessings8275
    @soleblessings8275 Před 7 měsíci +1

    🐐

  • @brentortman99
    @brentortman99 Před rokem +3

    What am I supposed to do when I don't have those options on my chromebook?

  • @Shubhamsingh-to7ju
    @Shubhamsingh-to7ju Před 7 měsíci

  • @oxygen2.781
    @oxygen2.781 Před rokem

    I followed these steps the tools showed up for a while then disappeard and can't be installed again!! do you have any idea??
    please I need my work to be done

  • @muhammadusmansarwar3196
    @muhammadusmansarwar3196 Před 3 měsíci

    Isn't kurtosis supposed to be 3 for normal distribution?, does excel already subtract 3 and provide excess kurtosis?

  • @daisydudu
    @daisydudu Před 7 měsíci

    I dont have the file option in my excel what do i do?

  • @rubengonzalez-cq2mf
    @rubengonzalez-cq2mf Před 4 měsíci

    When I filter my table the descriptive statistics go away. How do those values update with the filtered table?

  • @areeshasiddique4592
    @areeshasiddique4592 Před 8 měsíci

    In my excel there is no option of addins... What should I do

  • @tianavstheworld
    @tianavstheworld Před rokem +11

    i don’t have any of these options….. there’s nothing that pops up after options. theres no data analysis tool pack

    • @pieceshy
      @pieceshy Před 7 měsíci +1

      Click the file (right click) then you will see an customize ribbon then click then it will show something like in the video just click the ads in then, manage (excel add ins) then click go, after that choose the analysis tool pack, after that "data analysis" will show in data.

    • @panmaximus9504
      @panmaximus9504 Před 3 měsíci +2

      Woman moment

    • @rahularora4458
      @rahularora4458 Před 2 měsíci

      Setting> add ins > go tick all columns

    • @ath9558
      @ath9558 Před měsícem

      @@panmaximus9504here’s a loser who doesn’t get chicks lmao

    • @kokainum
      @kokainum Před měsícem

      ​@@rahularora4458Nothing like that in online version. :(

  • @robloxcentral3005
    @robloxcentral3005 Před rokem

    I keep getting errors

  • @TerraAventurineStudios

    The Volume is too low.