7. Exercise 5.7The Questor Corporation has experienced the following sales pattern over a 10-year period:Complete the table using a first-order exponential smoothing model with a w = 0.9 to forecast salesin 2017.Sales (Y;) Exponential Smoothing (Ît)(000)Year(w = 0.9)20072032008235203200926520102932011319201234320133652014385201540320164192017*PPPPPPPPL|

A series which is a collection of observation of pre defined data item obtained through repeated…

Answered: 7. Exercise 5.7 The Questor Corporation…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

Historical demand for a product is as follows: DEMAND April 60 May 55 June 75 July 60 August 80 September 75 Using a simple four-month moving average, calculate a forecast for October. Note: Round your answer to 1 decimal place. Using single exponential smoothing with α = 0.2 and a September forecast = 65, calculate a forecast for October. Note: Round your answer to the nearest whole number. Using simple linear regression, calculate the trend line for the historical data. Say the X axis is April = 1, May = 2, and so on, while the Y axis is demand. Note: Round your intercept value to the nearest whole number and slope value to 2 decimal places. Calculate a forecast for October using your regression formula. Note: Round your answer to 2 decimal places.
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.
6
The following table gives the regression results of consumption behaviour between female and male. Consumption (C), in RM Model 1 Model 2 Constant 0.7515 0.6587 (0.024) (0.037) Y 0.8603 0.5442 (0.0301) (0.2881) Gen 0.2001 (0.0004) Y*Gen 0.3105 (0.0076) Adjusted R 0.78 0.78 No. of Observations 47 47 Note: Y=income (RM) Gen= Gender ( It is equal to 1 if person is female; 0 is for male) Figures in the parentheses are p- values a) Identify which are the qualitative, quantitative and interaction variable. Refer to Model 1: b) Write the regression equations for female and male. Draw the regression lines for female and male on the same diagram. What can you c) say? d) Interpret all the estimated slope coefficients. e) Conduct an appropriate test to determine whether variable gender is statistically significant at 5%. Should this variable be dropped from this regression model.
Question-2: The same company decided to improve the forecasting technique. Usually they use exponential smoothing using smoothing constant 0.3. However, they would like to try alternate options: 0.4, 0.6, 0.7. Based on the following data for actual demand in the year of 2022, which smoothing constant they should chose among 0.3, 0.4,0.5 and 0.6. You can use excel/other software to calculate and draw graph. Show your final result with a graph representing the actual demand and forecast for each smoothing constant. Also, calculate the MAPE (mean absolute percentage error) to justify your answer. Period 1 2 3 4 5 6 7 8 9 10 11 12 Actual demand (in thousands) 10 12 14 11 13 18 20 17 13 16 12 19
Use regression analysis on deseasonalized demand to forecast demand in summer 2013. Forecast for summer 2023 ______
REAL CONSUMPTION (Billions of dollars) REAL CONSUMPTION (Billions of dollars) The following graphs show an economy's initial position at point A along its consumption function (C). Suppose tensions in the Middle East lead to a rapid increase in the price of oil, which raises the general price level. On the graph, shift either the consumption curve or the initial point on the consumption function to show the impact of a rise in the price level (Note: In the scenario where the curve shifts, only shift the curve and do not adjust the position of the point.) REAL DISPOSABLE INCOME (Billions of dollars) Now suppose that disposable income suddenly and unexpectedly decreases. A On the following graph, shift either the consumption curve or the initial point on the consumption function to show the impact of a fall in disposable income. (Note: In the scenario where the curve shifts, only shift the curve and do not adjust the position of the point.) REAL DISPOSABLE INCOME (Billions of dollars) C

Recommended textbooks for you

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

Elementary Statistics: Picturing the World (7th E…

Statistics

ISBN:

9780134683416

Author:

Ron Larson, Betsy Farber

Publisher:

PEARSON

The Basic Practice of Statistics

Statistics

ISBN:

9781319042578

Author:

David S. Moore, William I. Notz, Michael A. Fligner

Publisher:

W. H. Freeman

Introduction to the Practice of Statistics

Statistics

ISBN:

9781319013387

Author:

David S. Moore, George P. McCabe, Bruce A. Craig

Publisher:

W. H. Freeman

SEE MORE TEXTBOOKS