Question: Please solve the problems from (a) to (f) with the links. Please put the solution and specific process. Link 1 for Nominal GDP: https://fred.stlouisfed.org/series/GDPA#0 Link
Please solve the problems from (a) to (f) with the links. Please put the solution and specific process.
Link 1 for Nominal GDP: https://fred.stlouisfed.org/series/GDPA#0
Link 2 for Real GDP: https://fred.stlouisfed.org/graph/?graph_id=801124#

1. (Excel Problem) Download annual nominal and real (chain-weighted) GDP for the period 1929-2017 here (a) Create a column for the GDP deflator and plot it against time. (b) Create a column for the inflation rate using the GDP deflator series above and plot this series against time. (c) What is the lowest inflation rate that you observe? From which periods (t to t + 1) did it take place? (d) What is the highest inflation rate that you observe? From which periods (t to t + 1) did it take place? (e) What was the highest rate of inflation after WWII and when did it take place? (f) Calculate the average (geometric) rate of inflation from 1960 to 2019. Plot this number on your inflation graph as a horizontal line from 1960 to 2019. Is current inflation above or below this average
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
