Week $1$ Case Study $-$ Pivot Tables in Excel $($Case Study #$1)$

Due Sunday by $11$:$59$ pm Points $100$ Submitting a file upload

File Types $xsx$ and $xs,$ Available Jan $1$ at $12$am $-$ Feb $25$ at $11$:$59$pm

Case Study #$1$ is intended to test your knowledge of how to summarize data using pivot tables in Excel using the data file, including using filters and interpreting the results $2021.$xIsx darr $).$

The data file contains US Census Bureau $($USCB$)$ population counts for $2010$ and $2019$ for each of the $50$ US states, along with the District of Columbia $($DC$),$ with both statewide totals and county level totals, as applicable. The data fields included are as follows:

Region $-$ Per the USCB the US is carved into distinct geographic regions

Division $-$ Each USCB Region is further carved into distinct geographic divisions

State Code $-$ The USCB assigns a unique numeric code for each state and DC

County Code $-$ The USCB assigns a unique numeric code for each county within a state

County Codes may be duplicated amongst different states

County Code $=0$ indicates total statewide population from all counties

State Name