Question
Data (shown in below table) for the past 8 quarters at the Port of Vancouver has unloaded large quantities of Wheat grain from the cargo
Data (shown in below table) for the past 8 quarters at the Port of Vancouver has unloaded large quantities of Wheat grain from the cargo ship MV Ocean Breeze. The port operation manager wants to test the use of exponential smoothing method to see how well the technique works in predicting tonnage unloaded. He guesses that forecast of grain unloaded in the first quarter was 175 tons. Two values of are to be examined: = 0.10and = 0.50.
Quarter | Actual Tonnage Unloaded |
1 | 180 |
2 | 168 |
3 | 159 |
4 | 175 |
5 | 190 |
6 | 205 |
7 | 180 |
8 | 182 |
9 | ? |
Question1. Compare the actual data with the data we forecast (using of the twovalues)
Question 2. By using of the twovalues, find the mean absolute deviation and MADs. On the basis of this comparison of the two MADs, which value is preferred?
Question 3. From the above table compute the MSE (Mean Squared Error) (use the same forecast data for = 0.10.Provide justification for your answer of MSE good or bad?
Question 4. Now calculate the MAPE (Mean Absolute Error) when = 0.10
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