Normal Probability Plot - Q-Q Plot - Excel

Поділитися
Вставка
  • Опубліковано 16 жов 2024
  • The normal probability plot is formed by plotting the sorted data vs. an approximation to the means or medians of the corresponding order statistics. Done using Excel.

КОМЕНТАРІ • 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

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

  • @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!

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

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

    how did you get the value of x?😅

  • @francoiscloete5720
    @francoiscloete5720 8 років тому +1

    perfect score for making it understandable. Thanks!!

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

  • @TheGAFFIERE
    @TheGAFFIERE 9 років тому

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

  • @AyazSamo
    @AyazSamo 7 років тому +1

    Excellent explanation

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

  • @usmanfarooq7271
    @usmanfarooq7271 5 років тому

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

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

  • @leogaussbell1622
    @leogaussbell1622 4 роки тому

    how he select the pencil in excel and draw

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

  • @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)

  • @zoeali3440
    @zoeali3440 8 років тому

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

  • @Dvich
    @Dvich 7 років тому

    Helped me, thanks.

  • @Metia_9898
    @Metia_9898 4 роки тому

    why is my probability more than 1. :C

  • @thsjthsj
    @thsjthsj 9 років тому

    thank you

  • @philipbrooks7640
    @philipbrooks7640 9 років тому +1

    This dude sounds like David Blaine

  • @ibnelmouata1
    @ibnelmouata1 8 років тому +2

    arrange the data first