Fill in the table by preparing forecasts based on a five-year moving average, a three-year moving average, and exponential smoothing (w = 0.9 and¹ Ŷt + 1 = Yt.)W = 0.3). (Note: The exponential smoothing forecasts may be begun by assumingYear Actual Demand200020012002200320042005200620072008200920101,4001,4351,4601,4751,4801,4751,4601,5101,5501,580Year20052006200720082009*RMSEMoving Average(5-year)1,4501,4651,4701,4801,4951,515(5-year)625251,6004,9007,225Moving Average2The following table shows the square errors, (Yt -Ỹt-1)², for forecasts from 2005 through 2009.Fill the table by calculating the root mean square error (RMSE) for each of the methods.(3-year)Square Error(3-year)92891,4444,6245,3291,4321,4571,4721,4771,4721,4821,5071,547Three-year moving averageExponential smoothing (w = 0.3)Five-year moving averageExponential Smoothing(W = 0.9)(W = 0.3)Exponential smoothing (w = 0.9)1,4001,400Exponential Smoothing(W = 0.9)(W = 0.3)1648422502,3042,5002,0255,6251,1566,724Based on the RMSE criterion, which of the forecasting methods is the most accurate?

Answered: Fill in the table by preparing…

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

Describe the patterns in quantity sold and own and rival prices during this time period using basic descriptive statistics. Graphs are welcome as well. Take the logs of the variables, and estimate the demand function. Interpret the R-square. Interpret the coefficients for logP and logPsub Interpret the p-values associated with each independent variable Are consumers price sensitive? Why or why not? (be as precise as you can – you have estimates!). Does this price sensitivity make sense given the good we are examining? How sensitive are our consumers to changes in the rival good’s price? Explain in detail. Suppose we decide to charge a per ounce price of $2, while at the same time our rival charges a price of $2.15. All else equal, what would you expect sales to be? How confident are you in your forecast? Suppose we are charging a price of $2 and our current marginal cost is $1.50 Are we maximizing profits at this price? If not, should we raise or lower price? Why?
Given the number of calls per week received by a dental clinic, what is the forecasted number of calls for week 12 considering that the forecast for week 1 was 47 and a smoothing constant a -0.2? CALLS 52 35 25 36 45 35 44 WEEK 1 2 3 4 5 6 7 869 10 34 calls 35 calls 33 calls 38 calls 30 35 25
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.
The Jersey Dairy Products Company produces cheese, which it sells to supermarkets and foodprocessing companies. Because of concerns about cholesterol and fat in cheese, the company has seen demand for its products decline during the past decade. It is now considering introducing some alternative low-fat dairy products and wants to determine how much available plant capacity it will have next year. The company has developed an exponential smoothing forecast with a = .40 to forecast cheese demand. The actual demand and the forecasts from the model are as follows:Assess the accuracy of the forecast model by using MAD and cumulative error. If the exponential smoothing forecast model does not appear to be accurate, determine whether a linear trend model would provide a more accurate forecast.
please answer these two correctly;
Illustration 12.2. The sale of a commodity in tonnes varied from January 1961 to December 1961 in the following manner: 280 300 280 280 270 240 230 230 220 200 210 200 Fit a trend by the method of semi-average.
China had a population in 2008 of about 1.14 billion people. The populaton is growing by about 1.34% each year. If this trend continues, when will China's population reach 1.2 billion.
The following are historical demand data: ACTUAL YEAR 2011 SEASON DEMAND Spring 201 Summer 142 Fall 380 Winter 578 2012 Spring 469 Summer 273 Fall Winter 683 963 Use regression analysis on deseasonalized demand to forecast demand in summer 2013. (Do not round intermediate calculations. Round your answer to the nearest whole number.) Forecast for summer 2013
An entrepreneur who owns and operates two businesses (A and B) would like to analyze their profitability. They would like your help in the analysis. They give you the annual net profit (in thousands of $) for each business from 2008-2020. Table 1: Annual Net Profits for Businesses A and B Business Year Profit Business Year Profit 2008 -50 2008 -10 2009 57 2009 30 2010 71 2010 27 2011 64 2011 22 2012 60 2012 21 2013 50 2013 20 A 2014 41 2014 24 2015 59 2015 24 2016 71 2016 32 2017 71 2017 36 2018 74 2018 37 019 81 20 40 2020 97 2020 49 a. Suppose you want to graph the distribution of profits. Explain why using only one stem- plot might not be optimal for the analysis. b. Describe the correct stemplot to use. Generate this stemplot. Explain your steps. What can you say about the distribution from this stemplot? c. When are stemplots useful? And why is that? d. Suppose that instead of having 26 observations you have 200 observations. What graph should you generate? e. What other type of…
Use regression analysis on deseasonalized demand to forecast demand in summer 2013. Forecast for summer 2023 ______
Using exponential smoothing, calculate the forecasts for months 2, 3, 4, 5, and 6. Thesmoothing constant is 0.2, and the old forecast for month 1 is 245.

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