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

HOW I CREATED THIS TUTORIAL (AFFILIATE LINKS)

Software (Microsoft Excel 365 ProPlus)

FOLLOW US

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.

[magictrades]

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

[samwade]

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

[lydiamaree]

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

[PK-twbi]

Thnx for sharing in such a beautiful way

[cococnk]

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

Thanks.

[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

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

[dexmog]

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

[KeyserTheRedBeard]

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

[uini]

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

[Saraljinx]

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

[PiduguVijay]

Hi Steven,

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

[omidhemmati]

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

[jandoubinouha]

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

[anandasatria]

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

[astrnox]

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.

[filiptatarczak]

Does data have to be ranged growingly?

[callipeters]

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

[donuts_are_good]

don't read his intro slide on mushrooms