Download the Excel spreadsheet Week3TutorialData.xlsx. This file contains annual data from 1952 through 2019 for USA, Australia,
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/66750b87b9bb2_69566750b8768030.jpg)
Download the Excel spreadsheet "Week3TutorialData.xlsx". This file contains annual data from 1952 through 2019 for USA, Australia, China and India. For each country, the data set includes data for real GDP, real aggregate consump- tion and each economy's population. Your task is to do the following:
(a)For each country, construct a column featuring the annual growth rate of GDP for each year starting in 1953 and ending in 2019.
(b)For the USA, China and India, produce a separate plot consisting of the time-series of real GDP growth rates along with a time-series plot for Australia's real GDP growth rate. How do the growth rates in real GDP compare for Australia versus the USA, China and India?
As an example of what you should aim to produce, here is an example using a different set of countries.
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/66750b884092a_69666750b881d511.jpg)