How To Create A QQ Plot In Excel

In this tutorial, I&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&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.