Checking for Normality in Excel

Поделиться
HTML-код
  • Опубликовано: 6 май 2020
  • Using Excel to verify if a data set is normal.

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

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

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

  • @jacobnielsen3261
    @jacobnielsen3261 2 месяца назад

    Thank you for a FANTASTIC video!

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

    This was amazing! Thank you Joe

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

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

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

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

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

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

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

    Thanks, AWESOME tutorial.

  • @Yellow260
    @Yellow260 10 месяцев назад

    Thank you, this was super helpful!

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

    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.

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

    you saved me. thank you!

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

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

  • @vincedavis5326
    @vincedavis5326 2 года назад +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  2 года назад +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.

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

    Thank you Sir

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

    ty dude

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

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

  • @aaliceabuzaid2621
    @aaliceabuzaid2621 9 месяцев назад

    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

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

    EXECLLENT! Thank you

  • @0495jiju
    @0495jiju 2 года назад

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

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

    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?

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

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

    • @joesienaprof9128
      @joesienaprof9128  2 года назад +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.

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

    At what stage shoud we run a normality test ?

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

      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.

  • @pixelsbritt3634
    @pixelsbritt3634 11 месяцев назад

    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  10 месяцев назад

      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 8 месяцев назад

      ​@@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  7 месяцев назад

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