Normality Test| Shapiro-Wilk Test || Data Analysis in MS Excel

Поділитися
Вставка
  • Опубліковано 31 січ 2025

КОМЕНТАРІ • 25

  • @jovitasor5403
    @jovitasor5403 2 роки тому +2

    Amazing work here, sir ram

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

    Thank you Sir Ram for this video!

  • @pszwagierek
    @pszwagierek 11 місяців тому

    Dziękuje, bardzo fajnie wykładasz [thank you, you explain very well] pozdrowienia z Polski :)

  • @КсенияШестакова-я2ф
    @КсенияШестакова-я2ф 8 місяців тому +1

    Благодарим за данное видео! Вы спасли двух студенток из России ❤

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

    Excellent video thank you

  • @TarannumKhandoker
    @TarannumKhandoker 10 місяців тому +1

    Hi, I have 10 Pairs of Land Surface Temperature (LST) data from 10 sites for two years. If I want to conclude that overall T-Test suggests there are significant difference between the two years, do all 10 pairs need to be significant individually? or if majority sites show significant difference, I can conclude that the overall result is significant?

  • @АнжеликаШатохина

    THANK YOU from Russia😁!!!

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

    Thank you! This saved me in my Statistics report 😁

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

    Salamat Sir Ram!

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

    I did everything you said and my info was really weird: For 20 scores:
    W_Numerator: 86516462.4
    W_Denominator: 818.95
    W= 105643.156
    Reference Value: 0.905
    p-value: p>0.05
    Do you think I did something wrong? I swear I followed this video exactly. :(

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

    Any video on calculating the P value using that linear regression formula?!

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

    Hi! Can you please explain why there is a parenthesis of Xi in the numerator of the formula? Thanks!

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

    If we have more than 50 data, how can we find ai values?

    • @moon-bn2lo
      @moon-bn2lo 10 місяців тому

      use Kolmogorov-Smirnov. Shapiro-Wilk tests are more appropriate for small sample sizes (n < 50)

  • @66NotFunny
    @66NotFunny Рік тому +1

    Can someone please explain what is the p1 value in the formula for getting an approximate p-value?

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

    Sir Ram, can you please do the apportionment video in English?

  • @jamesclarkychongullina2115
    @jamesclarkychongullina2115 10 місяців тому

    Hello sir. I would like to ask the link or a copy of the distribution table thank you ❤

  • @VMV2024-i8i
    @VMV2024-i8i 2 місяці тому

    What if sir 100 + Ang respondents ko. Anong gagawin?

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

    Could you explain how the variable a is derived?

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

    Sir can u please explain what should i do i got odd number of samples?
    What should i do with ai

    • @shubhamsd100
      @shubhamsd100 Рік тому +2

      for eg., if 41, then take till 21... 21st value will be zero. So while transforming to the negative values, just leave that zero value and copy-paste the remaining negative values to the ai column,

  • @Lauren-je2mx
    @Lauren-je2mx Рік тому

    Can you share an example file?

  • @johnmarkvalencia-te4vw
    @johnmarkvalencia-te4vw 4 місяці тому

    What if I have 174 samples?

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

      Sample or saple size
      Cuz 174 and according to central limit theeorem it will be normally distributed

  • @matteorossi4729
    @matteorossi4729 8 місяців тому

    Salamat Sir Ram!