Video není dostupné.
Omlouváme se.

Checking for Normality in Excel

Sdílet
Vložit
  • čas přidán 6. 05. 2020
  • Using Excel to verify if a data set is normal.

Komentáře • 29

  • @investire8094
    @investire8094 Před 3 lety

    I am from Brazil, thanks for your class and congratulation for your skills.

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

    Thank you for a FANTASTIC video!

  • @emailmesaleem
    @emailmesaleem Před 3 lety

    wonderful, many thanks it is important to know why we finding out the normality in a data distribution, and this video answers that

  • @sherylleduna5367
    @sherylleduna5367 Před 2 lety

    Thanks so much for this video, Joe. I hope you make new videos soon. God bless! :)

  • @Yellow260
    @Yellow260 Před rokem

    Thank you, this was super helpful!

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

    can we get your notes around 18:59 time stamp when you reviewed?

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

    Thanks for the video. It is pretty sad excel does not have an Anderson-Darling test for normality built in. I’m a retired guy and miss Minitab.

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

      Agreed. It would be nice for more advanced functionality but that is why we teach R Studio once we get past a first course in statistics.

  • @munnabhaimbbs9716
    @munnabhaimbbs9716 Před 3 lety

    Thanks, AWESOME tutorial.

  • @anukumardas7299
    @anukumardas7299 Před 3 lety

    Hello Joe, Thanks for such useful videos in your channel. Please upload a video on constructing a QQ plot for weibull and gumbel distribution.

  • @nakulsharma5108
    @nakulsharma5108 Před 3 lety

    This was amazing! Thank you Joe

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

    So if your mean is somehow equal or roughly equal to the mean, then it’s a normal distribution right?

  • @aaliceabuzaid2621
    @aaliceabuzaid2621 Před 10 měsíci

    why we didnt we follow the nrmal steps for NPP where i-0.5/n ? which brings to second question why did we add 1 although most videos chart NPP without adding 1 to the sample ? thank you so much . apologies if i am lost / confused

  • @JJ_TheGreat
    @JJ_TheGreat Před 2 lety

    Hi,
    Great video! I really feel I am learning about how to check for normality!
    Question: What should we look for with kurtosis for checking for normality?
    Thanks.

  • @Jadd90
    @Jadd90 Před rokem

    Thank you Sir

  • @0495jiju
    @0495jiju Před 2 lety

    My doubt is that do we have to check normality for every question in the questionnaire or it is overall data.

  • @michaelmanias4560
    @michaelmanias4560 Před 3 lety

    you saved me. thank you!

  • @muneerhasham6491
    @muneerhasham6491 Před rokem

    EXECLLENT! Thank you

  • @JJ_TheGreat
    @JJ_TheGreat Před 2 lety

    19:16 So they “have a really good chance to be normal”, but that doesn’t mean that we have proven that the distribution is normal, correct?

  • @wanderlustwernweh5313
    @wanderlustwernweh5313 Před 2 lety

    At what stage shoud we run a normality test ?

    • @joesienaprof9128
      @joesienaprof9128  Před rokem

      I run a normality test if I am about to run a hypothesis test that needs it as an assumption. Also, if we have normality, then probability rules are clearer.

  • @marcuscarter599
    @marcuscarter599 Před 2 lety

    ty dude

  • @pixelsbritt3634
    @pixelsbritt3634 Před rokem

    Hello, im getting an error: #NUM! when i'm calculating the NORM.S.INV part. Do you know how i can fix this?

    • @joesienaprof9128
      @joesienaprof9128  Před rokem

      I am thinking you must have a value that is greater than 1. NORM.S.INV only works for values that represent probabilities. I hope this helps.

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

      ​@@joesienaprof9128 hey thanks. I was also wondering when you should assume that the mean and the median are relatively close or far apart. I have got some doubtful cases.. Is there a percentage or something?

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

      @@pixelsbritt3634 the short answer is it depends on the situation. This video shows us a quick check on normality. If I really want to check I would run a ChiSquare or a Wilks Shapiro. Those are harder to explain so when we first learn about normality, we use these rules. The best thing to do is to have a few of these quick checks to work and that is a nice starting point. I would also make sure the boxplot is "normal" looking for a visual check.

  • @pipo441
    @pipo441 Před 2 lety

    Hi Joe, My Mode: is # N/A however all my cells have values

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

      A mode of #N/A means you have all unique values so hence no mode. The good thing is that for checking normality you want to focus on the mean roughly equal to the median.