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?

CIVPOP U3rate Ubrate RGDP EMPL UNEMPL LF LFPR EPOP (percent) Year Quarter (billions) (thousands) (thousands) (thousands) (percent) (thousands) (percent) (percent) 1970 Q1 4936.6 71311 3430 82210 60.5 52.48 1.17 71167 82565 60.4 Q2 3929 70978 4296 82912 60.3 Q3 Q4 70574 4855 83498 60.4 1971 Q1 70844 4959 83676 60.2 71179 1968 83929 60.0 Q2 Q3 71434 5070 84581 60.1 Q4 71866 5090 85318 60.3 Q1 72678 4995 86208 60.3 1972 Q2 73463 4935 86810 60.4 Q3 74038 4900 87351 60.5 Q4 74972 4673 87675 60.4 1973 75972 4391 88232 60.4 Q1 Q2 76663 4384 89181 60.8 Q3 77119 4320 89650 60.8 Q4 77853 4343 90579 61.1 1974 Q1 78217 4670 91379 61.3 Q2 78512 4750 91584 61.2 Q3 78622 5174 92253 61.3 Q4 78182 6100 92688 61.3 1975 Q1 76953 7666 93023 61.2 02 76535 8288 93619 61.3 Q3 77050 7993 94128 61.3 Q4 77747 7812 94309 61.1 1976 Q1 78789 7363 95049 61.3 Q2 79327 7235 95826 61.5 Q3 79714 7463 96626 61.7 Q4 80200 7532 97102 61.8 1977 Q1 81023 7343 97703 61.8 Q2 82101 7035 98696 62.2 03 83147 6835 99244 62.2 Q4 84128 6655 100294 62.6 4070 Growth Rate NIPA Unemployment Inflation (+