Answered step by step
Verified Expert Solution
Question
1 Approved Answer
To answer the following questions, download the CSV file and import it into your data software. The file is a monthly times series from January
To answer the following questions, download the CSV file and import it into your data software. The file is a monthly times series from January 1950 to December 2019. Organize your dataset as a time series and assume if needed that the series is a flow variable. a. What is the average of the series over the whole period? Year Month Value Round your answer to the nearest rst decimal. 1950 1 5911 746-5 1950 2 50.6 b. Create a monthly growth rate series. Then, compute the 1950 3 49'4 average monthly growth rate over the whole period in 1950 4 58'1 percentage. Round your answer to the nearest second 195 5 54.3 decimal. 1950 6 58.0 Number 1950 7 53.9 1950 a 59.1 c. Create an annualized monthly growth rate series using the 1950 9 54.3 exact formula. Then, compute the average monthly 1950 10 50.9 annualized growth rate over the whole period in 1950 11 53.3 percentage. Round your answer to the nearest second 1950 12 59.4 decimal. 1951 1 50.0 Number 1951 2 59.2 d. Construct an index base 100 = May 1968. Then compute the 1951 3 60'2 average of all indices from November 2001 to February 1951 4 54's 2005. Round your answer to the nearest second decimal. 1951 5 53'4 Number 1951 6 55.7 1951 7 58.4 e. Using the log approximation, compute the average 1951 a 60'? anualized growth rate in percentage from July 1951 tojune 1951 9 503 1955. Round your answer to the nearest second decimal. 195. 10 5919 Number 1951 11 57.3 Hint: first, create the monthly growth rate using the log 1951 12 59.3 approximation, then annualize the rate using the exact 1952 1 59.9 formula) 1952 2 61.7
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started