Question

In: Statistics and Probability

Use the following time-series data to answer the given questions. Time Period Value 1 27 2...

Use the following time-series data to answer the given questions. Time Period Value 1 27 2 30 3 58 4 63 5 59 6 67 7 70 8 86 9 101 10 97 a. Develop forecasts for periods 5 through 10 using 4-month moving averages. b. Develop forecasts for periods 5 through 10 using 4-month weighted moving averages. Weight the most recent month by a factor of 4, the previous month by 2, and the other months by 1. c. Compute the errors of the forecasts in parts (a) and (b) and observe the differences in the errors forecast by the two different techniques. (Round your answers to 3 decimal places.) a. Time Period Value 4-Month Moving Average Forecast 1 27 - 2 30 - 3 58 - 4 63 - 5 59 6 67 7 70 8 86 9 101 10 97 b. Time Period Value 4-Month Weighted Moving Average Forecast 1 27 - 2 30 - 3 58 - 4 63 - 5 59 6 67 7 70 8 86 9 101 10 97 c. Time Period Value Forecast Error, 4-Month Moving Average Forecast Error, 4-Month Weighted Moving Average Differences in error 1 27 - - - 2 30 - - - 3 58 - - - 4 63 - - - 5 59 6 67 7 70 8 86 9 101 10 97 In each time period, the four-month moving average produces errors of forecast than the four-month weighted moving average.

Solutions

Expert Solution

Time Period Value 4 Month MA 4 Month WMA Error 4 MMA Error 4MWMA Differnce in Error_1 Difference in Error_2
1 27
2 30
3 58
4 63
5 59 45.25 54 13.75 5 8.75 0.636363636
6 67 53.5 56.875 12.5 9.125 3.375 0.27
7 70 62 63.125 8 6.875 1.125 0.140625
8 86 64.75 66.875 21.25 19.125 2.125 0.1
9 101 70.25 76.125 30.75 24.875 5.875 0.191056911
10 97 80.75 89 16.25 8 8.25 0.507692308
4 month Moving Average at time (i)=(value(i-1)+value(i-2)+value(i-3)+value(i-4))/4
4 Month Weighted moving avergae at time(i)=(4*value(i-1)+2*value(i-2)+value(i-3)+value(i-4))/8
Error 4 MMA at time(i)=value(i)-4 Month MA(i)
Error 4 MWMA at time(i)=value(i)-4 Month WMA(i)
Differnce in Error_1=Error 4MMA(i)-Error 4MWMA(i)
Differnce in Error_2=(4MMA(i)-Error 4MWMA(i))/Error 4MMA(i)
We can easily see that Weighted Moving average Yield less error

Related Solutions

Use the following time-series data to answer the given questions. Time Period Value 1 27 2...
Use the following time-series data to answer the given questions. Time Period Value 1 27 2 30 3 58 4 63 5 59 6 67 7 70 8 86 9 101 10 97 a. Develop forecasts for periods 5 through 10 using 4-month moving averages. b. Develop forecasts for periods 5 through 10 using 4-month weighted moving averages. Weight the most recent month by a factor of 4, the previous month by 2, and the other months by 1. c....
Use the following time-series data to answer the given questions. Time Period Value 1 26 2...
Use the following time-series data to answer the given questions. Time Period Value 1 26 2 30 3 57 4 62 5 58 6 65 7 70 8 86 9 101 10 97 a. Develop forecasts for periods 5 through 10 using 4-month moving averages. b. Develop forecasts for periods 5 through 10 using 4-month weighted moving averages. Weight the most recent month by a factor of 4, the previous month by 2, and the other months by 1. c....
Use the following time-series data to answer the given questions. Time Period Value 1 -25 2-...
Use the following time-series data to answer the given questions. Time Period Value 1 -25 2- 32 3 -59 4- 62 5- 59 6 -65 7 -70 8 -86 9 -101 10- 97 a. Develop forecasts for periods 5 through 10 using 4-month moving averages. b. Develop forecasts for periods 5 through 10 using 4-month weighted moving averages. Weight the most recent month by a factor of 4, the previous month by 2, and the other months by 1. c....
Use the following time-series data to answer the given questions. Time Period Value 1 25 2...
Use the following time-series data to answer the given questions. Time Period Value 1 25 2 31 3 58 4 62 5 59 6 66 7 72 8 86 9 101 10 97 a. Develop forecasts for periods 5 through 10 using 4-month moving averages. b. Develop forecasts for periods 5 through 10 using 4-month weighted moving averages. Weight the most recent month by a factor of 4, the previous month by 2, and the other months by 1. c....
) Answer the following questions regarding time series: If the exports ($ millions) for the period...
) Answer the following questions regarding time series: If the exports ($ millions) for the period 1997 through 2001 were $878, $892, $864, $870, and $912 respectively, what are these values called? A time series is a collection of data that: For an annual time series extending from 1993 through 2001, how many years would be lost in a five-year moving average? For a three-year moving average, how many values will be lost at the beginning and end of the...
Consider the following daily time series for days 1-14. Use this information to answer the questions...
Consider the following daily time series for days 1-14. Use this information to answer the questions below. Day Daily Steps 1 2270 2 3869 3 3285 4 4598 5 3539 6 2474 7 2246 8 4800 9 3696 10 4817 11 3261 12 1839 13 5121 14 2800 Step 1 of 7: What is the 3-day Moving Average forecast for time period 4? Round to the nearest whole number. Step 2 of 7: What is the 3-day Moving Average forecast...
Use alpha= 0.05 to test the following time series for positive autocorrelation. Period   Sales 1   2...
Use alpha= 0.05 to test the following time series for positive autocorrelation. Period   Sales 1   2 2   5 3   9 4   6 5   6 6   9 7   10 8   12 9   10 10   13 11   18 12   11 13   13 14   13 15   14 a) Determine the​ Durbin-Watson statistic. ​(Round to two decimal places as​ needed.) b) Identify the critical values. dL= dU= ​(Round to two decimal places as​ needed.)
Use the data given in the table to answer the following questions. The data represents the...
Use the data given in the table to answer the following questions. The data represents the average number of miles that a salesperson travels in a day verses the number of sales made each month. Miles, x 24 32 75 41 76 107 32 46 112 Sales, y 76 58 190 112 141 235 24 147 188 (a) What is the value of the correlation coefficient for this set of data? Round to 3 decimal places. (b) What is the...
Use the following data set – Pain Relief Study - to answer this series of questions....
Use the following data set – Pain Relief Study - to answer this series of questions. Participant Before Treatment After Treatment 1 90 80 2 70 50 3 60 60 4 90 70 5 70 60 6 50 40 7 70 60 Patients in a drug trial rate their pain before treatment and after treatment. Higher scores equate to higher levels of reported pain with a maximum possible score of 100. 11.1 Calculate MD for the Pain Relief Study 11.2...
Given the attached data. Answer the following questions for a 6 period moving average. MAD =...
Given the attached data. Answer the following questions for a 6 period moving average. MAD = Average(|A-F|) TS =SUM(A-F)/MAD MSE = Average(A-F)2 1. Compute your forecast for period 51. The potential answers are: A: 4414 units. B: 10290.67 units. C: 8020.83 units. D: 6324.8 units. E: 6351.86 units. 2. Compute the MAD value for period 50. The potential answers are: A: 2655.35 units. B: 3753.86 units. C: 3892.54 units. D: 3732.56 units. E: 3205.7 units. 3. Compute standard deviation of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT