Normal Probability Plot - Q-Q Plot - Excel

[@Rongwa]

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]

I'm learning for my postgraduate stats exam :(

[@cindyduke4657]

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]

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

[@idjr2654]

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

[@vidyasagarballeda]

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]

perfect score for making it understandable. Thanks!!

[@joshp244]

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]

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

[@abdulhamidhajkhalil2168]

Merci beaucoup vous êtes magnifiques

[@AyazSamo]

Excellent explanation

[@rajeevgopinath6010]

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

[@girishghadge8460]

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

[@ahmadsyukri387]

how did you get the value of x?😅

[@chiyuileong5401]

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

[@NuM83RN1N3]

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]

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

[@TheGAFFIERE]

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

[@usmanfarooq7271]

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

[@zoeali3440]

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

[@vuenick_9265]

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

[@simranarora9525]

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

[@leogaussbell1622]

how he select the pencil in excel and draw

[@Dvich]

Helped me, thanks.

[@isaurawhite3300]

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

[@Rosielx]

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

[@Metia_9898]

why is my probability more than 1. :C

[@thsjthsj]

thank you

[@ibnelmouata1]

arrange the data first

[@philipbrooks7640]

This dude sounds like David Blaine