## Module 2: Data Visualization

- 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**

- Make a
- Video 2.4: Visualizing bivariate relationships
- Make two
**scatterplots**

- Make two

**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.**