Lesson 4: Simple Linear Regression
September 3, 2020
Review:
- Attendance
- Scatterplots
- Trendline
Presentation:
- Simple Linear Regression
- Bivariate (2 variables)
- i.e., one x and one y variable
- Demonstrate Estimation with Linear Regression
- Pueblo RE 2014 – 100 rows
- Total SqFt = x/independent/explanatory variable
- Selling Price = y/dependent/response variable
- Generate Scatterplot
- Fit Trendline
- Label with Equation and R²
- Replicate linear equation in spreadsheet
- Estimate Price assuming SqFt = 1200, 1600, 2000
Activity:
- Background
- Use Snowpack n Runoff data
- Source: National Water and Climate Center, USDA
- Snowpack = x/independent/explanatory variable
- Runoff = the y/dependent/response variable
- Generate Scatterplot
- Fit Trendline
- Label with Equation and R²
- Replicate linear equation in Sheets
- Estimate Runoff assuming March Snowpack = 10, 15, 20
Assignment:
- Complete Assignment 3 (same as Tue, duplicated here)
- Video 2.1: Data Assembly
- Video 2.2: Pivot Tables
- Complete Pivot Tables in Spreadsheets
- Chapter 1 ONLY
- Use a Pivot Table to aggregate Colorado Counties by GDP and Population by Congressional District
- Submit your spreadsheet file (.xlsx) on Bb