Excel Multiple Regression with Real World Examples for Science

Excel Multiple Regression with Real World Examples for Science
How to Use Excel Multiple Linear Regression

This Quick Trainer tutorial walks you thru Mulitiple Linear Regression. It covers the statistics behind MLR. It walks you through activating that "Analysis ToolPak" in Excel. It walks you thru running an MLR analysis in Excel and how to interpret the output tables and graphs. There are three example demonstrations in Excel using MLR: a trip time model with three independent variables, a house price model with 8 independent variables, and a multivariate chemometrics model to profile heroin sources using three indepedent variables. The video is a bit long, coming in at just over one hour. I suggest you use the chapter links below in this description to skip through to the sections that most interest you, and/or play at 2x.

------- Chapter Timestamps (click to jump forward): -----------------------------
00:00:00 - Intro
00:00:33 - What is Multiple Linear Regression (MLR)?
00:07:51 - How to Acivate Aanlysis ToolPak in Excel
00:08:54 - How to Run an MLR Analysis in Excel
00:12:12 - How to Interpret MLR Output Tables in Excel
00:25:15 - How to Interpert MLR Output Graphs in Excel
00:29:13 - Example #1 - Trip Time Model
00:38:40 - Example #2 - House Price Model
00:51:29 - Example #3 - Multivariate Chemometrics in Heroin Profiling
01:01:20 - The End

Kaggle Housing Dataset:

Excellent Statistics Overviews on Multiple Linear Regression:

Excellent Tutorials on Using Excel for Multiple Linear Regression:

Watch related playlist videos:

Background Music (via YouTube "always free" Audio):

#XL #Excel #ExcelTutorial