How To Perform Simple Linear Regression In Excel
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.
Watch video How To Perform Simple Linear Regression In Excel online without registration, duration hours minute second in high quality. This video was added by user Steven Bradburn 08 March 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 445,571 once and liked it 7.9 thousand people.