The purpose of this analytical assignment is to allow you an opportunity to demonstrate your fluency with the economic concepts and models that we have covered to date in the class. In particular, this assignment requires you to demonstrate your ability to work with economic data for analysis and inference.

Assignment Expectations:

There are two parts to this Analytical Assignment. Part A and consists of 20 questions based on your calculations in the accompanying workbook (see below). Part B consists of more essay type questions and is worth 20 points. The two combined mean that there are a total of 40 points available for Analytical Assignment #1.

I would highly recommend that you not start either parts of the assignment until you have worked through and completed all the calculations in the workbook. The questions here will not make sense otherwise.

Please make sure that you have downloaded the data that accompanies this assignment Download downloaded the data that accompanies this assignmentand worked through the following workbook before starting the assignment. Please do the calculations in the spreadsheet and enter the solutions in the cell specified in the instructions. Once you have completed the workbook, use that to answer the questions that are posed in both Part A and B of this assignment. There will be an opportunity for you to upload your workbook to demonstrate how you calculated things. Please remember to upload your Excel workbook at the end of Part A when you submit your solutions. I may wish to check your calculations in your spreadsheet if you make errors. If you are working with someone else, make sure to have both your names in the Excel file.

You may use your lecture notes and the textbook for this Assignment.

IMPORTANT: Please make sure to download both of the above and work through them PRIOR to starting and submitting the assignment in Canvas.

Part A:

Questions in Part A of the assignment are arranged as follows (along with the reference to the corresponding worksheet in the AA1_data.xlsx workbook):

Questions 1 - 5: GDP. Please refer to the worksheet 'Growth Rate' in the Excel workbook.

Questions 6 - 10: National Income and Product Accounts. Please refer to the worksheet 'NIPA' in the Excel workbook.

Questions 11 - 15: Labor Markets. Please refer to the worksheet 'Unemployment' in the Excel workbook.

Questions 16 - 20: Price Indices and Inflation. Please refer to the worksheet 'Inflation' in the Excel workbook.

Each question in part A is worth 1 point. You may attempt Part A up to twice and Canvas will keep the highest score.

Can you please tell me what formulas I would use to calculate these?

Annualized Quarter-on- Units: Share of RGDP Quarter Growth Rate Real Nominal C G NX C G Nominal Real C G NX N/A N/A N/A Year Quarter GDP GDP GDP Deflator C G NX 2966.6 789.4 1164.2 16.4 21.294 531.7 168.1 247.9 3.5 1970 Q1 1051.2 1067.4 21.591 641.6 171.5 249.1 5.2 Q2 173.9 254.6 4.1 Q3 1086.1 21.768 653.5 22.056 660.2 166.8 258.7 3 Q4 1088.6 22.391 579.2 189.5 261.9 4.6 1971 Q1 1135.2 266.1 -0.4 Q2 1156.3 22.685 693.2 197.3 1177.7 22.916 705.6 269.8 0.2 Q3 202.1 23.107 721.7 198.4 272.1 -1.9 Q4 1190.3 1972 1230.6 23.458 -3.5 Q1 738.9 213 282.2 Q2 1266.4 23.604 757.4 226.8 286.5 -4.3 Q3 1290.6 23.8 775.8 233.1 284.3 -2.6 Q4 1328.9 24.134 800.5 239.7 291.7 -3.1 24.412 825 254.3 299.6 -1.4 1973 Q1 1377.5 2.5 Q2 24.787 302.7 1413.9 840.5 268.2 25.27 6.4 Q3 1433.8 858.9 264.3 304.2 Q4 1476.3 25.773 873.9 280.9 312.6 9 891.9 324.6 6.4 Q1 1491.2 26.26 268.4 1974 Q2 1530.1 26.88 920.4 277.4 335 -2.7 Q3 1560 27.668 949.3 271 346.7 -7 0 Q4 1599.7 28.482 959.1 281.3 359.2 29.129 985.2 244.3 370.1 16.5 1975 Q1 1616.1 243.3 373.4 21.6 02 1651.9 29.562 1013.6111.473 14266.3 3783.4 3683.1 -633.8 2019 Q1 21098.8 Q2 21340.3 112.188 14511.2 3749.5 3742.3 -662.7 14678.2 3744.6 -653 Q3 21542.5 112.664 3772.8 3698.3 3813.7 -577.9 Q4 21729.1 113.043 14795 3852 -524.7 01 21539.7 3629 2020 113.502 14583.3 Variance Average Share Correlations Consumption Investment Gov't Purchases Consumption Investment Gov't Purchases Net Exports Consumption Investment Gov't Purchases Net Exports