Question: 5). Example Question 5 10 pts An Apple Store in Northridge uses the exponential smoothing method to forecast its revenue per month. The following table

5).

5). Example Question 5 10 pts An Apple Store inExample

5). Example Question 5 10 pts An Apple Store in

Question 5 10 pts An Apple Store in Northridge uses the exponential smoothing method to forecast its revenue per month. The following table shows their actual sales and forecasts in the past few months. Month Jan Feb March April May Actual sales 20 34 25 34 32 Forecasted sales 19 33 33 36 29 Please calculate the MSE value of the forecasting method. keep two decimals if not exact, either round up or down is ok. For example, for 0.1346, (0.13 or .13) and (0.14 or .14) are correct. Expert Answer Anonymous answered this 4,706 answers Was this answer helpful? B1 o Answer: MSE value of the forecasting method= 35.25 Explanation: MSE is calculated using the formula MSE = ? n-1 We can calculate the values as below. Month e2 actual sales Forecasted sales Error(e)=Actual- forecast Jan 20 15 5 25 Feb 29 20 9 81 Mar 25 20 5 25 Apr 35 36 -1 1 May 32 29 3 9 Here n=5 as there are values for five months. MSE= (25+81+25+1+9)/(5-1) = 141/4 = 35.25 Comment >

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!