Scenario: You are working in a municipal planning office and about to embark on a

large project that will include many analyses on Census data to complete. Many in your

office are not familiar with the nuances of Census Survey data and the implications for

analysis. Your boss has asked to you to prepare a ~$2$ page memo based on some

example calculations to illustrate some fundamental concepts to your working group.

Logistics: All of the data and excel templates needed to finish this assignment are

included in the Assignment $1$ folder. In the folder, there is an excel file called

$$assignment$1\_$yourLastName.xlsx$$ file. Rename this file using your last name. Each of

the following questions has a corresponding work sheet in the excel file. Read the

questions carefully and fill in the cells in yellow in excel. Then, write a memo

considering each question and the overall goal of communicating these concepts. Save

the memo as Assignment$1\_$yourLastName.pdf$.$

Final deliverables: The completed excel worksheet $($Assignment$1\_$yourLastName.xlsx$)$

and a technical memo describing your work $($Assignment$1\_$yourLastName.pdf$).$

Question $1$: Analyzing population shifts $[25$pts$]$

Use county level data from $2010($Age$2010$ sheet$)$ and $2015($Age$2015$ sheet$)$ to

complete the highlighted cells in the $$Question $1$ worksheet. Describe how the

proportion of the population under $20$ and above $65$ has changed from $2010$ to from

$2015.$ Below is some guidance on how to proceed.

$$ Step $1$: Calculate the total population under $20$ and above $65$ for year $2010$ and

$2015.$

$$ Step $2$: Calculate percent change in population for the two age groups. Percent

change $=(2015$ data$-2010$ data$)/2010$ data.

$$ Step $3$: Calculate average, median, min, max, and standard deviation of percent

change for the two age groups.

$$ Step $4$: Draw histograms for percent changes in the two groups and determine

whether mean or median is a better measure of central tendency