Normal Quantile (Q-Q) Plots In Excel Part 1

[@stephenellis7569]

Finally someone who does not assume everyone is an excel expert. He was great at describing the stats too. THANK YOU.

[@felicciasc]

This is the third video I found on this after looking at the online text, and the first one that made it understandable.

[@josephcsamuel]

Jermaine, you made it so simple and understandable. Really good work.

[@JermaineGordon1]

Glad it was helpful!

[@sararv1]

Easy to follow instruction, I think your video is a great resource.

[@PetStuBa]

best explanation about normal quantile plots you can find on YT ... ty :)

[@bobert4345]

Nice video. Can you please explain the formula in Column I, ie the % for each item (i-0.5/n), why are you using "0.5" - can you provide a reference source

[@PamelaLacayo]

Thank you Mr. Gordon!!!!!

[@JermaineGordon1]

You are welcome

[@MrWahsabii]

Great job!!! Why would one want two or three people who weigh the same and have different probabilities? Consider rows 38-43, and 49-52. Should not they be the same probabilities?

[@JermaineGordon1]

A different way of ranking the values would involve giving the average rank to any ties. That method would be more accurate than this one, but would require some conditional coding for the ranking column. If you are not married to using excel, I have a video showing how to create the quantile plot using desmos.com. kzbin.info/www/bejne/l5fGhJqqlLqfo6c

[@SinatSumAgri-tech]

where 0.5 comes from in percentile?

[@bloom936]

very helpful tutorial.

[@miyoungyoon7133]

It was so good to understand QQplot! thank you!

[@JermaineGordon1]

Glad it was helpful!

[@Dieg657]

Thanks Mr. Gordon! I'm very grateful!

[@JermaineGordon1]

You are welcome.

[@sunilkumarsamji8871]

What actually happens when we choose normal .S. inverse distribution? or how theoretical z is calculated for every percentile or quantile (i-0.5)/57 by excel? Why should this be a straightline?

[@tubuvegogoscholar4676]

Clear explanation. Thank you!

[@JermaineGordon1]

Thanks for watching!

[@sunilkumarsamji8871]

That was a very good explanation and I have a few queries, can you please clarify them Gordon?

[@juliogonzalez-saenz4936]

Many thanks for taking time to explain this subject.

[@yufu7226]

hello, I don't understand why do you use i minus 0.5 ? where's the 0.5 coming from ?

[@JermaineGordon1]

It is to correct or continuity since we are making it discrete.

[@JermaineGordon1]

Look up "continuity correction"

[@yufu7226]

Jermaine Gordon thank you !! I’ll check that

[@mtstans]

thank you!

[@JermaineGordon1]

You're welcome!

[@danielmozart4320]

Really nice vid. Thanks =)

[@JermaineGordon1]

Glad it helped!

[@alriyaad]

INCREDIBLE!!!!!

[@TobiasDettinger]

Formula =(XY-.5)/57 doesn't work. Error.

[@SyedKollol]

You really need to learn excel shortcuts first. Also, people already knows excel's basic functions like sorting , filtering etc; you don't need to make it boring.

[@danielagutierrez-gv9nl]

no we don't

[@maxinegaines6225]

That is an unnecessary criticism!! There are many of us who know nothing about excel and need every step shown!!!

[@juliogonzalez-saenz4936]

I will suggest you prepare one as Mr. Gordon did.. He is considering all the audience. If people is proficient in excel, I am sure they do not need to use YT to figure out things.

[@hellorune2425]

I didnt know any of this so this video helped me quite a bit