How To Create A QQ Plot In Excel

In this tutorial, I'll show you how to create a QQ (quantile-quantile) plot by using Microsoft Excel. Creating a QQ plot is a great way to visually inspect the distribution of your data. It's particularly useful to see if your data has a normal (Gaussian) distribution.
VIDEO CHAPTERS
00:00 Intro
00:18 Example data
00:33 Step 1: Rank your data
02:23 Step 2: Calculate the percentiles
03:23 Step 3: Calculate the normal theoretical quantiles
04:05 Step 4: Calculate the data Z-scores
05:21 Step 5: Create the QQ plot
07:35 How to interpret a QQ plot
08:18 Wrapping up
ONLINE GUIDE
toptipbio.com/qq-plot-excel/
HOW I CREATED THIS TUTORIAL (AFFILIATE LINKS)
Screen recorder & editor techsmith.z6rjha.net/c/198849...
RUclips SEO www.tubebuddy.com/SHTeach
Software (Microsoft Excel 365 ProPlus)
FOLLOW US
Website toptipbio.com/
Facebook / toptipbio
Twitter / toptipbio
AFFILIATE DISCLAIMER
Some of the above links are affiliate links, meaning I will earn a commission if a sale is made after clicking on the link.

[@StevenBradburn]

ONLINE GUIDE
toptipbio.com/qq-plot-excel/

[@ahmedkabir6212]

Cf DCh koaqoqa can bcc go

[@magictrades159]

Best tutorial on RUclips for this plot. Really helpful, thanks

[@samwade4380]

Great tutorial, clear, correct, and using current version of excel. Great help!

[@lydiamaree44]

this was so easy to follow!! thank you so much you saved me

[@cococnk388]

I can now say I have understood not only how to display a QQ plot but the concept behind.
Thanks.

[@PiduguVijay]

As usual Great tutorial

[@greenlantern6665]

Great tutorial,tysm ❤️

[@santoshchhatkuli]

I am teaching Statistician and I am very much impressed by way you explain the topic making my understanding topic even better. How QQ plot differ from PP plot, please make a video of it. I have a slight confusion over it. Thanks

[@ditya3548]

very clear, thanks!

[@PK-tw2bi]

Thnx for sharing in such a beautiful way

[@jwang_]

Best explanation

[@Saraljinx]

Thank you so much, you really saved me for my assignment. I appreciate you so much

[@StevenBradburn]

Very welcome!

[@dexmog]

thank you so much I needed this to answer my gf's assignments.

[@Forvanced-bs8kk]

Спасибо!

[@taemi5507]

thanks a lot!

[@mathiasmajslott9363]

thank you

[@MusafirHoonYaro]

Thank you very much for the video. Very lucidly explained. Do you have tutorials for how to read plots of "residuals versus fitted values" and "residuals versus regressors"? Thank you.

[@KeyserTheRedBeard]

nice video Top Tip Bio. I killed the thumbs up on your video. Maintain up the quality work.

[@uini7599]

Great tut. Why did you minus 0.5 at the percentile?

[@PiduguVijay]

Hi Steven,
can you please make a tutorial on AUC and ROC curves ? thanks

[@pocharampavani5176]

Really helpful vedio

[@StevenBradburn]

Thanks :)

[@omidhemmati7611]

at the step 2, why you distract 0.5? where is it come from?

[@youwanderer7597]

i mean when i=n, if you don't distract 0.5, the pencentile would be 1, and in normal distribution you would get a infinite number i guess that's why

[@anandasatria7734]

what if the data is gamma distributed? would it be the same way?

[@jandoubinouha3562]

hi, for the percentile, why do you do -05? i used to do -1. thank you

[@astr0nox]

The trendline is the wrong thing to use here as it is the OLS best fit line for the data. What you want instead is a line that represents y = x.

[@filiptatarczak5106]

Does data have to be ranged growingly?

[@L0RDI007]

I know you have probably this figured otu by now but i had the same question and have also figured out the answer is no :)

[@callipeters8551]

What if i keep getting the #NUM error message for my z-score data?

[@tolulopeaniyikaiye2039]

Tutor Steven please we need response to this question.

[@donuts_are_good]

don't read his intro slide on mushrooms