Using quarterly data during the period of December 1960 to December 2022. Download into Excel the following series:

Personal Consumption Expenditures, Billions of Dollars, Quarterly, Seasonally Adjusted Annual Rate

Gross Private Domestic Investment, Billions of Dollars, Quarterly, Seasonally Adjusted Annual Rate

Government Consumption Expenditures and Gross Investment, Billions of Dollars, Quarterly, Seasonally Adjusted Annual Rate

Exports of Goods and Services, Billions of Dollars, Quarterly, Seasonally Adjusted Annual Rate

Imports of Goods and Services, Billions of Dollars, Quarterly, Seasonally Adjusted Annual Rate

Net Exports of Goods and Services, Billions of Dollars, Quarterly, Seasonally Adjusted Annual Rate

Gross Domestic Product, Billions of Dollars, Quarterly, Seasonally Adjusted Annual Rate

Real Gross Domestic Product, Billions of Chained 2017 Dollars, Quarterly, Seasonally

Adjusted Annual Rate

Gross Domestic Product: Implicit Price Deflator, Index 2017=100, Quarterly, Seasonally

Adjusted

Verify that = . Create a new column for Net exports in your Excel file. Produce a FRED line-chart of exports and imports annually during 2010-2022. Add net exports to this graph measured on the secondary (right) axis.

Use I to V above to calculate the nominal GDP. Compare your results with VII. Do you get the same values? Plot your GDP and Fred's GDP in Excel against time.

Add up the four quarters of 2022. Produce a bar chart in Excel that shows the percentage shares of each expenditure component to GDP in 2022.

Use the GDP (VII) and the GDP Deflator (IX) to produce the real GDP given by (VIII). Do you get the same values? Plot the nominal and real GDP in FRED.

In FRED, convert the quarterly data into annual frequency. Produce an Excel line graph with the growth rate in real GDP. Find the long-term growth rate in the US economy using those annual data during 1960-2022. Using the rule of 70, how long does it take the US economy to double? How does this long-term growth rate compare with the five-year average 2018-2022?

Copy your work on 1-5 above into a Word file, convert it into PDF and submit in Canvas.