Business Forecasting with Excel

. CoastCo Insurance, Inc., is interested in forecasting annual larceny thefts in the United States using the following data:




a. Prepare a time-series plot of these data. On the basis of this graph, do you think there is a trend in the data? Explain.


b. Look at the autocorrelation structure of larceny thefts for lags of 1, 2, 3, 4, and 5. Do the autocorrelation coefficients fall quickly toward zero? Demonstrate that the critical value for rk is 0.417. Explain what these results tell you about a trend in the data.


c. On the basis of what is found in parts a and b, suggest a forecasting method from Table 2.1 that you think might be appropriate for this series.


Do you need a similar assignment written for you from scratch? We have qualified writers to help you. You can rest assured of an A+ quality paper that is plagiarism free. Order now for a FREE first Assignment! Use Discount Code "FREE" for a 100% Discount!

NB: We do not resell papers. Upon ordering, we write an original paper exclusively for you.

Order New Solution