Normal Probability Plot - Q-Q Plot - Excel

แชร์
ฝัง
  • เผยแพร่เมื่อ 5 พ.ย. 2024

ความคิดเห็น • 29

  • @Rongwa
    @Rongwa 3 ปีที่แล้ว +13

    It's 1:09am, In South Africa, Cape Town. It's a day before my birthday, I'm doing a Stats assignment for my postgraduate diploma and you are the only person who perfectly explained this to me! Thank you!

    • @aphiwemagaya3279
      @aphiwemagaya3279 3 ปีที่แล้ว

      I'm learning for my postgraduate stats exam :(

  • @cindyduke4657
    @cindyduke4657 6 ปีที่แล้ว +2

    Brilliant - you have made the process of establishing Q-Q plots rather simple...I was scratching my head and only 24hrs until my assessment was due. Fingers Crossed I am on the right track. Thanks Again

  • @majkly0
    @majkly0 5 ปีที่แล้ว +4

    Hello. To everyone I recommend sorting values first! The video confused me untill 8:20, when he finally sorted the data...

  • @idjr2654
    @idjr2654 10 ปีที่แล้ว

    Thank you for posting this Jalayer, much faster in R, but useful to know how to do this in excel. Many thanks!

  • @vidyasagarballeda
    @vidyasagarballeda 7 ปีที่แล้ว +3

    I am new to this topic can you please explain me why you calculate formula {i-0.5)/n ? Can you please help me ... and one more question what is difference between {i-0.5)/n and standardized x value ..?

  • @francoiscloete5720
    @francoiscloete5720 8 ปีที่แล้ว +1

    perfect score for making it understandable. Thanks!!

  • @AyazSamo
    @AyazSamo 7 ปีที่แล้ว +1

    Excellent explanation

  • @TheGAFFIERE
    @TheGAFFIERE 10 ปีที่แล้ว

    Helpful. But standard Normal has SD=1, while the sample may not. Shouldn't you calculate the standard deviation of the sample before comparing to a standard normal? this topic is sending me mad...

  • @joshp244
    @joshp244 3 ปีที่แล้ว +1

    what do you do, open to anyone, if you have many mutiple/repeated data values in the original data set using this method, the qq plot formed looked odd and didn't appear to follow a straight line

    • @hillaryclinton9203
      @hillaryclinton9203 3 ปีที่แล้ว

      Hello Josh,
      My name is Hillary Clinton and my husband is a sex offender.
      Kind Regards,
      Hilldog1337

  • @zoeali3440
    @zoeali3440 8 ปีที่แล้ว

    that was awesome, thank you very much. how about t.distribution?

  • @usmanfarooq7271
    @usmanfarooq7271 5 ปีที่แล้ว

    What software do you use to draw on screen???

  • @rajeevgopinath6010
    @rajeevgopinath6010 8 ปีที่แล้ว +1

    Why is i-.5/count in the second columns? DId not understand? Please explain.

    • @girishghadge8460
      @girishghadge8460 3 ปีที่แล้ว

      In this case we standardized the x scale were as in the Z score case we standerdised the x Vals

  • @vuenick_9265
    @vuenick_9265 9 ปีที่แล้ว

    Jalayer Academy Shouldn't we have x values on x-axis and z-values on y-axis? Am i wrong?

    • @simranarora9525
      @simranarora9525 5 ปีที่แล้ว

      to show the values are in the normal distribution curve, z is always on horizontal axis. Thats how a curve would be made.

  • @ahmadsyukri387
    @ahmadsyukri387 10 หลายเดือนก่อน

    how did you get the value of x?😅

  • @chiyuileong5401
    @chiyuileong5401 9 ปีที่แล้ว +9

    Why is the probability equal to (i - 0.5) / n ?

    • @NuM83RN1N3
      @NuM83RN1N3 9 ปีที่แล้ว

      Chiyui Leong i'd like to know it too, but i think it's just a way to divide the values from 0 to 1 with equal intervals

    • @MrsXmas1
      @MrsXmas1 4 ปีที่แล้ว

      I am guessing that the confidence level is 95% and the 0.5 represents the a value

  • @Dvich
    @Dvich 7 ปีที่แล้ว

    Helped me, thanks.

  • @leogaussbell1622
    @leogaussbell1622 4 ปีที่แล้ว

    how he select the pencil in excel and draw

  • @isaurawhite3300
    @isaurawhite3300 4 ปีที่แล้ว

    Buen video, pero no tengo la opcion en excel de "Norm.s.inv". Como podria solucionarlo?

    • @Rosielx
      @Rosielx 4 ปีที่แล้ว +1

      en español la funcion es: =INV.NORM.ESTAND(probabilidad)

  • @thsjthsj
    @thsjthsj 9 ปีที่แล้ว

    thank you

  • @philipbrooks7640
    @philipbrooks7640 9 ปีที่แล้ว +1

    This dude sounds like David Blaine

  • @Metia_9898
    @Metia_9898 4 ปีที่แล้ว

    why is my probability more than 1. :C

  • @ibnelmouata1
    @ibnelmouata1 8 ปีที่แล้ว +2

    arrange the data first