How To Perform Simple Linear Regression In Excel

Подробнее о видео

✉️ Join my newsletter


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


HOW I CREATED THIS TUTORIAL (AFFILIATE LINKS)
Screen recorder & editor
YouTube SEO
Software (Microsoft Excel 365 ProPlus)

FOLLOW US
Website
Facebook
Twitter

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.