Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hello I need help please show all In excel thanks Case: Fields Inc. Case Consider Fields sales data included, it's a time series data on
Hello I need help please show all In excel thanks
Case: Fields Inc. Case Consider Fields sales data included, it's a time series data on quarterly sales values (in $1,000's) of Fields, Inc. for the last 16 years. Suppose we are interested in forecasting next four quarters' sales, please conduct the following procedures: (1). Plot the TS data (use either Excel or Minitab), and identify any patterns embedded; (2). Use Winters' trend and seasonally adjusted exponential smoothing model to predict the sales values, in so doing, use initial values of: Lo=50147, To=0, S.3=0.84073, S-2=0.85307, S.1=0.99135, So=1.31486, and parameters of a 0.3, B=0.1 and y=0.1 (3). Establish a multiple linear regression model for modeling the seasonality and trend patterns identified (using the 4th quarter as the reference season), write down your model estimate. (4). Compare results of two models constructed above, based on criteria of MSE, which model you consider is the best in fitting the data given. Using the best model you identified, provide an overlay plot of observed Fields sales values vs. predicted sales values. (5). Provide a table which contains your forecast of sales for future four quarters (for Year 17th). Year Quarter Quarter 14 16 Time Sales 50147 49325 57948 76781 48617 50898 58517 77691 50862 53028 58849 79660 51640 54119 65681 85175 17 56405 60031 71486 92183 60800 22 64900 23 76997 24103337 25 67279 26 69869 27 81029 28 107192 29 69110 30 76084 31 87160 32 113829 33 73567 79360 97324 136036 37 78071 18 OWNE WNWNWNIONWNWN CONN 2 7 8 35 Sheet 24299 Mignment 00 3 4 C 13 52 54 55 7 57 - 2 1 1 3 4 2 3 4 1 43 96724 44 140586 45 97015 46 103137 47 114402 48 152135 49 101984 50108562 51 121749 52 160499 53 108152 54 114499 55 127292 56 171965 57 115673 58 125995 59 136255 60 169677 61 111905 62 127872 63 145367 64 188635 15 Case: Fields Inc. Case Consider Fields sales data included, it's a time series data on quarterly sales values (in $1,000's) of Fields, Inc. for the last 16 years. Suppose we are interested in forecasting next four quarters' sales, please conduct the following procedures: (1). Plot the TS data (use either Excel or Minitab), and identify any patterns embedded; (2). Use Winters' trend and seasonally adjusted exponential smoothing model to predict the sales values, in so doing, use initial values of: Lo=50147, To=0, S.3=0.84073, S-2=0.85307, S.1=0.99135, So=1.31486, and parameters of a 0.3, B=0.1 and y=0.1 (3). Establish a multiple linear regression model for modeling the seasonality and trend patterns identified (using the 4th quarter as the reference season), write down your model estimate. (4). Compare results of two models constructed above, based on criteria of MSE, which model you consider is the best in fitting the data given. Using the best model you identified, provide an overlay plot of observed Fields sales values vs. predicted sales values. (5). Provide a table which contains your forecast of sales for future four quarters (for Year 17th). Year Quarter Quarter 14 16 Time Sales 50147 49325 57948 76781 48617 50898 58517 77691 50862 53028 58849 79660 51640 54119 65681 85175 17 56405 60031 71486 92183 60800 22 64900 23 76997 24103337 25 67279 26 69869 27 81029 28 107192 29 69110 30 76084 31 87160 32 113829 33 73567 79360 97324 136036 37 78071 18 OWNE WNWNWNIONWNWN CONN 2 7 8 35 Sheet 24299 Mignment 00 3 4 C 13 52 54 55 7 57 - 2 1 1 3 4 2 3 4 1 43 96724 44 140586 45 97015 46 103137 47 114402 48 152135 49 101984 50108562 51 121749 52 160499 53 108152 54 114499 55 127292 56 171965 57 115673 58 125995 59 136255 60 169677 61 111905 62 127872 63 145367 64 188635 15 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started