25. Consider the following time series data: a. b. Quarter 1 2 3 4 Year 1 4 4235 2 3 5 Year 2 6 3 5 7 Year 3 7 6 6 8 Construct a time series plot. What type of pattern exists in the data? Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Qtr1 = 1 if Quarter 1, 0 otherwise; Qtr2 = 1 if Quarter 2, 0 otherwise; Qtr3 = 1 if Quarter 3, 0 otherwise. c. Compute the quarterly forecasts for next year.

25. Consider the following time series data: a. b. Quarter 1 2 3 4 Year 1 4 4235 2 3 5 Year 2 6 3 5 7 Year 3 7 6 6 8 Construct a time series plot. What type of pattern exists in the data? Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Qtr1 = 1 if Quarter 1, 0 otherwise; Qtr2 = 1 if Quarter 2, 0 otherwise; Qtr3 = 1 if Quarter 3, 0 otherwise. c. Compute the quarterly forecasts for next year.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
Please do not give solution in image format thanku
Global Bikes Inc. (a bicylce manufacturing firm) collected the following data during a study of consumer buying patterns. Observation 1 2 3 4 5 6 7 y= X y 15 70 28 79 38 89 35 86 49 97 42 97 30 82 y = Observation 0.721 + 1890123 a. Create a linear regression line (equation) for the data.(Round your Intermediate calculations and final answers to 3 decimal places.) X 14 16 14 24 21 29 63.229 X y 82 70 68 84 83 91 b. Use the equation determined in part b to predict the expected value of y for x = 49. (Round your Intermediate calculations and final answers to 3 decimal places.)
Sales for the past 6 months at Dalworth Company are given in the following table: Month Sales July 52 August 61 September 53 October 35 November 31 December 28 What is the Mean Absolute Deviation (MAD) for August through December forecasts produced by using exponential smoothing with α = 0.4? (Note: Do not round the forecasts, and choose the closest answer.) Multiple Choice 39.64 8.75 15.28 11.94
Mark Gershon, owner of a musical instrument distributorship, thinks that demand for guitars may be related to the number of television appearances by the popular group Maroon 5 during the previous month. Gershon has collected the data shown in the following table: Maroon 5 TV Appearances 3 4 8 6 7 7 Demand for Guitars 4 6 7 5 10 6 This exercise contains only parts b, c, and d. Part 2 b) Using the least-squares regression method, the equation for forecasting is (round your responses to four decimal places): Y = enter your response here + enter your response herex
Develop a forecast for the next month using a four-month moving average method. Use the Excel Functions SLOPE and INTERCEPT to write the linear regression prediction equation with Months as the independent variable and sales as the dependent variable. Use the prediction equation to estimate the number of sales in month 9.
The following table shows the past two years of quarterly sales information. Assume that there are both trend and seasonal factors and that the seasonal cycle is one year. QUARTER 1 2 5678AWN 3 4 8 SALES 219 237 208 171 169 Quarter 9 10 11 12 192 157 132 Use regression and seasonal indexes to forecast quarterly sales for the next year. Note: Do not round intermediate calculations. Round your answers to the nearest whole number. Forecast
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working
second answer of part b
(Use an excel file to show formulas used)
7