Regression Model Evaluation Template (Excel Multiple Linear Regression)

Credits: I got this template and dataset from my friend who goes to business school, who got the files from the business analytics professor. I believe the dataset was fabricated for instructional purposes.

Template: https://docs.google.com/document/d/1tqGzQMTrjJk8JrCoDrvN-Do8z5VLGfcNgmWqHZoL9cQ/edit?usp=sharing ANOVA Table Video: https://odysee.com/@chowderberry:9/read-anova-table-and-find-missing-values:6

Timestamps: 0:00 Theory and Summary 1:00 Install Data Analysis ToolPak 1:52 About the dataset 2:16 Using Filter to Clean the Data 4:00 Using Data Analysis ToolPak Regression 5:55 Making Prerequisite Graphs 8:26 Effect of Switching Binary Variable Representation 11:00 Regression Diagnostics Model 1 14:26 Overall Model Evaluation Model 1 18:31 Individual Variables Model 1 21:07 Satisfaction Model 1 21:33 Dropping Variables to Create Model 2 23:31 Making and Sorting Graphs 25:00 Regression Diagnostics Model 2 27:00 Overall Model Evaluation Model 2 29:24 Individual Variables Model 2 31:38 Satisfaction Model 2 31:48 Concluding Notes

Corrections: At 23:01 I said y^ when I mean ybar

This video is about evaluating the output of a linear regression model as generated by Excel's Data Analysis ToolPak (under the Data tab). In the future I plan on creating linear regression models, so I hope this video will provide some foundation on what the numbers mean.

All of my videos will be uploaded on both Odysee.com and Youtube.

Support me with Monero: 84r3yu7zcuKgZWRti56uBUfLXdED8u7cE6SL2WyYed1NfNZzG4yYeW37ZR4CAHUNQybdnYPeTrfdcNDhwUyiGaEr7say6FR