✉️ Join my newsletter
https://steven-bradburn.beehiiv.com/subscribe
In this video tutorial, I’m going to show you how you can perform a simple linear regression test by using Microsoft Excel. Not only will I show you how to perform the linear regression, but I’ll show you how to analyse the outputs of the regression test.
VIDEO CHAPTERS
00:00 Intro
00:22 My example data
00:54 Installing Analysis ToolPak
01:32 Performing linear regression
04:01 Summary output table
06:05 ANOVA table
07:04 Coefficients table
09:04 Residuals
10:58 Residual plot
11:43 Standardized residuals
12:21 Line fit plot
13:31 Normal probability plot
14:27 Summary
ONLINE GUIDE
https://toptipbio.com/linear-regression-excel/
HOW I CREATED THIS TUTORIAL (AFFILIATE LINKS)
Screen recorder & editor https://techsmith.z6rjha.net/c/1988496/506622/5161
YouTube SEO https://www.tubebuddy.com/SHTeach
Software (Microsoft Excel 365 ProPlus)
FOLLOW US
Website https://toptipbio.com/
Facebook https://www.facebook.com/TopTipBio/
Twitter https://twitter.com/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.