Module 2: Data Visualization
January 18, 2021
- Review
- Discussion Board
- DataCamp
- Part 1
- Video 2.1: Data Assembly
- Video 2.2: Pivot Tables
- Complete Pivot Tables in Spreadsheets
- Chapter 1 ONLY
- Use a Pivot Table to aggregate GDP and Population by Congressional District
- Video 2.3: Visualizing frequency distributions
- Make a histogram
- Video 2.4: Visualizing bivariate relationships
- Make two scatterplots
- Part 2
- Download US County Dataset
- Create a Pivot Table
- 49 rows and 4 columns
- Each row corresponds to 48 States and Washington DC (Alaska and Hawaii are excluded)
- Each column corresponds to four variables: Population, GDP, Median HH Income, Poverty %
- Calculate the “Sum” for Population and GDP by State
- Calculate the “Average” for Median HH Income and Poverty % by State
- Create graphs (use Insert > Chart)
- Use the resulting State aggregation (from the Pivot table)
- Make four (4) histograms
- (1) Population
- (2) GDP
- (3) Median HH Income
- (4) Poverty %
- Make four (4) scatter plots:
- (1) Population (x) vs GDP (y)
- (2) GDP (x) vs Poverty % (y)
- (3) GDP (x) vs Median HH Income (y)
- (4) Median HH Income (x) vs Poverty % (y)
- All graphs must have axis labels
- All scatter plots must include a “Trendline” along with labels for the “Equation” and “R^2 value”
To submit your assignment in Bb, “Share” your Google Sheets file and copy/paste the link.