Math Homework

Business Forecasting

From your textbook, Statistics for Management and Economics, complete the following exercises:

 

“Time Series Analysis and Forecasting”: Exercises 20.47, 20.48, 20.49, 20.50, and 20.51

 

Submit your answers in a Microsoft Excel workbook, with each problem on a separate worksheet. Label each tab in the workbook with the exercise number. Highlight the answers in yellow and provide an interpretation in a text box.

 

Submit your workbook to the W5: Assignment 2 Dropbox by Week 5, Day 4.

Cite any sources using the APA format on a separate page.

Assignment 2 Grading Criteria	Maximum Points
Plotted the time series accurately.	5
Discussed why exponential smoothing is not recommended as a forecasting tool in situation.	5
Used regression analysis to determine the trend line.	5
Determined the seasonal indexes accurately.	5
Accurately forecasted revenues for the next four quarters.	10
Presented a structured document free of spelling and grammatical errors.	5
Cited all sources using the APA format.	5
Total:	40

Exercises 20.47–20.51 are based on the following problem.

Xr20-1613 The revenues (in $millions) of a chain of ice cream stores are listed for each quarter during the previous 5 years.

	Year
Quarter	2009	2010	2011	2012	2013
1	16	14	17	18	21
2	25	27	31	29	30
3	31	32	40	45	52
4	24	23	27	24	32

· 20.47 Plot the time series.

·

· 20.48 Discuss why exponential smoothing is not recommended as a forecasting tool in this problem.

· 20.49 Use regression analysis to determine the trend line.

· 20.50 Determine the seasonal indexes.

· 20.51 Using the seasonal indexes and trend line, forecast revenues for the next four quarters