Business Forecasting With Excel

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


Meet your deadlines with our essay writing service and let our professional writers take care of it!
Create your project now and start getting help in 2 minutes
Just from $12/Page
Place an Order


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.

Get Assignment Writing Help

Our experts are ready to complete your assignment, course work. essay, test, dissertation, research paper, quiz

Get Started


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.




9. Use exploratory data analysis to determine whether there is a trend and/or seasonality in mobile home shipments (MHS). The data by quarter are shown in the following table:



On the basis of your analysis, do you think there is a significant trend in MHS? Is there seasonality? What forecasting methods might be appropriate for MHS according to the guidelines in Table 2.1?




10. Home sales are often considered an important determinant of the future health of the economy. Thus, there is widespread interest in being able to forecast total houses sold (THS). Quarterly data for THS are shown in the following table in thousands of units:







a. Prepare a time-series plot of THS. Describe what you see in this plot in terms of trend and seasonality.


b. Calculate and plot the first twelve autocorrelation coefficients for PHS. What does this autocorrelation structure suggest about the trend?


c. De-trend the data by calculating first differences: DTHSt  THSt  THSt1 Calculate and plot the first eight autocorrelation coefficients for DTHS. Is there a trend in DTHS?



11. Exercise 8 of Chapter 1 includes data on the Japanese exchange rate (EXRJ) by month. On the basis of a time-series plot of these data and the autocorrelation structure of EXRJ, would you say the data are stationary? Explain your answer. (c2p11

Needs help with similar assignment?

we are available 24x7 to deliver the best services and ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Order Over WhatsApp Place an Order Online

"Do you have an upcoming essay or assignment due?

Get any topic done in as little as 6 hours

If yes Order Similar Paper

All of our assignments are originally produced, unique, and free of plagiarism.

Stuck with a Question?

Get it solved from our top experts within 8 hrs!

Ask Your Question Now!