![]() Run 3-periods and 4-periods moving average forecasts for the above sales data and compare the forecasts using MAD, MAPE, MSE, RMSE. Plot the first differenced series and comment on its stationarity. Draw a table of first differences of the series (Yt-Yt-1). What do the autocorrelation coefficients tell you about the time series. Calculate the autocorrelation coefficients r1, r2, r3, r4, r5, r6, r7 and r8 for the above series and plot the "Correlogram" using Excel. Does it look stationarity and/or Seasonality? Why or why not? 2. Comment on the visible features in the plot. Plot the data using Excel (insert, Chart, scatter, lines.) showing the trend line in the plot. The following data covers 24 periods (could be years or quarters or months) for company ABC's sales in $millions. You must use Excel to solve this numerical problem (project). Must show your work, answer all parts of the question, and write necessary explanations to earn full points. Submit through D2L in Word/Excel format, single or multiple files.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |