Excel to Python 08: OLS in Excel and Python
Вставка
- Опубліковано 16 вер 2024
- This video shows how we do a basic (one independent variable) OLS model in both Excel and Python.
In Excel, we collect csv data from online (links below) and use Text to Columns to get it in a usable format. I explain how to enable the Data Analysis toolpack in Excel if it's not already installed and we run a simple regression.
In Python, we build the same model twice: once manually using the statistical formulas for regression coefficients to see what's happening under the hood of the premade, "black box" formulas and functionality within Python's statsmodels module.
Links:
Textbook and Python Scripts:
upfie.net/
Data Source for Excel model:
github.com/spr... - which will lead you to the csv:
raw.githubuser...
8:30 p value explanation (weakly statistically significant, statistically significant, strongly statistically significant)