Lesson 3: Simple Linear Regression
January 22, 2018
Review:
- Scatterplots
- Correlation
- Slack … okay, fine
Presentation:
- Simple (bivariate…that means 2 variables) Linear Regression
- Fitting Lines to Data (video)
- Demonstrate Linear Regression in Google Sheets
- Use Pueblo RE 2014 – 100 rows
- Line fit with Scatter Plot
- XL Miner Add-On
- New “Statistics” Add-On
- Prepare summary in Slides
Assignment:
- Background
- Use Snowpack n Runoff (source: National Water and Climate Center, USDA) data in Sheets
- Snowpack (H2O equivalent) = the “x”, “independent”, “explanatory” variable
- Runoff (Stream volume) = the “y”, “dependent”, “response” variable
- Generate Scatterplot
- Fit Trendline
- Label with Equation and R²
- Use XL Miner Add-On to run Linear Regression
- Use Statistics Add-On to run Linear Regression
- Prepare summary page
- Copy regression outputs
- Scatterplot (with labels)
- Output from XL Miner
- Output from Statistics Add-On
- Paste into Google Slides
- Arrange and label for clarity
- Add your name and section (11:15 or 1:00)
- Print 1 page (yes, ONLY 1 page … with everything on it)
- Copy regression outputs
- Bring summary page to submit in class on Wed