Excel Multiple Regression with Real World Examples for Science
Channel: DataResearchLabs
Date: 2021-01-30

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:
- https://www.kaggle.com/c/house-prices-advanced-regression-techniques/data?select=train.csv


Excellent Statistics Overviews on Multiple Linear Regression: 
- Brandon Foltz: https://www.youtube.com/watch?v=dQNpSa-bq4M&list=PLIeGtxpvyG-IqjoU8IiF0Yu1WtxNq_4z-


Excellent Tutorials on Using Excel for Multiple Linear Regression:
- https://www.statology.org/multiple-linear-regression-excel/
- https://www.youtube.com/watch?v=HgfHefwK7VQ


Watch related playlist videos: 
- XL#1 Basic Excel:  https://www.youtube.com/playlist?list=PLVHoUDdbskUQXl0S6nS2QUMB69rrf1zcF
- XL#2 Advanced Excel:  https://www.youtube.com/playlist?list=PLVHoUDdbskUTHC-HjacbwcUFhA4itl3AP


Background Music (via YouTube "always free" Audio):
* "Rewind" by Ofshane:  https://www.youtube.com/channel/UC34Wh4ysdP50H-ThbZFFfsA


#XL #Excel #ExcelTutorial