Question: collect a time series variable as the methods we are using this week do not work with other types of data. It must be a
collect a time series variable as the methods we are using this week do not work with other types of data. It must be a time series with at least monthly observations. That is annual data is not sufficient for this weeks work. Complete these steps with your variable using the Excel forecasting tools:
Plot your data. Comment on what you see. Do you see any trend andor seasonality?
Given what you found in step and what you know about the various forecasting models discussed in the text, what forecasting model do you think will fit your data best? Be specific and defend your choice.
Using the forecasting tools found in Excel, actually forecast your series. What model was best? Does it match with what you expected to find in step
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
