Lesson 3: Visualizing Bivariate Relationships with Scatterplots
September 1, 2020
Review:
- Attendance
- Histograms
- DataCamp
Presentation:
- Scatterplots
- Examples
- Correlation
- Positive and Negative
- Strong, moderate, weak
- Pearson Correlation Coefficient
- -1 < r < 1
- Trendline
- Linear equation (y = ax + b)
- r2
Activity:
- Create Scatterplots
- Use this data set: Pueblo RE 2014 – 100 rows
- Beds (x) vs Selling Price (y)
- Baths (independent) vs Selling Price (dependent)
- Total SqFt (explanatory) vs Selling Price (response)
- Identify the strongest correlation
- Beds, Baths or Total SqFt
Assignment:
- 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)