Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You are given the data in file Coca_Cola_Dividends.txt - Quarterly Dividend data starting from July 1995. Read in the text file and create the required
You are given the data in file "Coca_Cola_Dividends.txt" - Quarterly Dividend data starting from July 1995.
- Read in the text file and create the required "Date" Field.
- Obtain a plot the series.
- Using the Autocorrelation Function Plot and the White Noise Test Plot evaluate if the series represents White Noise? Why or Why Not? Please explain in detail.
- Using SAS Time Series Forecasting System Module estimate the following two models:
i. Random Walk (Hint: Hint: Use Fit ARIMA Models Option)
ii. Random Walk with Drift (Hint: Use Fit ARIMA Models Option)
Evaluate which model provides a better fit using Root Mean Square Error and Mean Absolute Percent Error.
- Using the Coefficient estimates and test statistics provided, evaluate if the Drift Component is statistically significant in the Random Walk with Drift model.
- Obtain 3 Period Ahead Forecasts from each Model. Which model among the two will you select as the model you want to use for forecasting coca cola dividends? Please explain your reasoning.
Step by Step Solution
★★★★★
3.42 Rating (133 Votes )
There are 3 Steps involved in it
Step: 1
Creating the Date Field To create the Date field we need to know the starting date and the frequency of the data From the given information we know th...Get Instant Access with AI-Powered 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