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

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.