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
https://toptipbio.com/qq-plot-excel/
HOW I CREATED THIS TUTORIAL (AFFILIATE LINKS)
Screen recorder & editor https://techsmith.z6rjha.net/c/198849...
YouTube SEO https://www.tubebuddy.com/SHTeach
Software (Microsoft Excel 365 ProPlus)
FOLLOW US
Website https://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.
Watch video How To Create A QQ Plot In Excel online without registration, duration hours minute second in high quality. This video was added by user Steven Bradburn 24 September 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 55,521 once and liked it 831 people.