Check File uploaded
(1) Check Econ Instruction file.
(2) I completed the data spreadsheet
The assignment is to populate an Excel Spreadsheet with charts and write no more than two pages related to the data. Namely, identify any economic trends (desirable or undesirable and write what the team would do to enhance or reverse the trends. Do not describe the data as that would be redundant since the charts are available. Also, do not write about a topic other than what is derived from the charts.
Grading will be based on how well each team follows instructions as well as on spelling, grammar, logic and the ability to be concise. (This is not a political exercise so it will not matter should a position lean one direction or another.)
This is a team exercise and will require each student to confer with the team to meet the assignment. It is up to each team to determine when and how to meet outside of class. Please advise should a team require support with technology or accessibility.
An Excel Spreadsheet Template with Charts will be provided for each team to populate.
Assignment:
1. Populate the attached excel spreadsheet displaying the GDP of the US for each year since 1900 (total government spending – federal, state and local)
2. Add the total government expenditures
3. Add the values of the
total expenditures for defense, education, entitlements (pensions, healthcare, and welfare)
4. Add the total interest on the debt
5. Add the gross public debt
6. Add the unemployment rates since 1948 and inflation rate (CPI) since 1913
7. Ensure that the populated data is displayed on the charts on the tabs
8. Create any other charts that may support your summary
9. Review the Excel data and write
no more than
two pages on what you perceive as the largest problems/opportunities and your proposed solutions in
Microsoft Word
10. Turn in the package on the date due (
staple the Microsoft Word portion in front of the Excel Spreadsheet and Charts) as well as sending me
one
email with the package (one
Microsoft Word and
Microsoft Excel) attached. I will deduct 5 points for late emails and 10 points for missing email packages –
any portion
.
Spending data is to be taken from:
For spending – select $ bln 2017, select years
1900 to 2022, you can add up to 5 categories, select total, and then download CVS file or download tabbed and copy values into spreadsheet. Continue until all categories are complete.
Employment and CPI data is to be taken from:
For unemployment, go to Data Tools, select “Top Picks, under “Unemployment”, Select
“Labor Force Statistics including the National Unemployment Rate”, Select “Unemployment Rate (Seasonally Adjusted) – LNS14000000”, then select “retrieve data”. Then select
1948 to 2022 in output options and select “go”. You will need to annualize the data.
Participation rate is also found on this website – search participation and retrieve data as you did for unemployment - LNS11300000.
On the CPI link, go to Data Tools, select “Top Picks – All Urban Consumers”, under “Consumer Price Index”, check “U.S. All items, 1982-84=100 – CUUR0000SA0”, then select “retrieve data”. Then select
1913 to 2022 in output options and select “go”. You will need to annualize the data.
Note – all percentages of spending to GDP will be populated automatically
