Module 2: Data Visualization

March 15, 2021

• Review
  • Discussion Board
  • DataCamp

• Watch this Video first!

• DataCamp: Introduction to Pivot Tables for Google Sheets

• Part 1
  • Video 2.1: Data Assembly
    • Compile a Colorado County Data Set
    • Download population data for all US counties
    • Download County GDP from the Bureau of Economic Analysis
    • Look up Congressional Districts for each Colorado County
  • 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, please “Share” your Google Sheets file and copy/paste the link.