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 | |||||||
orchestra answered 2 years agoRelated 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
Latest Questions
- You must evaluate a proposal to buy a new milling machine. The base price is $175,000,...
- “Triangle Guessing” game in Python The program accepts the lengths of three (3) sides of a...
- THIS PROGRAM HAS TO BE WRITTEN IN C Single function to perform the parity computation on...
- Consider a buffer system consisting of Benzoic acid (pKa = 4.20) and sodium benzoate, a) Would...
- Decision Variables S T Minimize 1.8S + 2.20T Subject to: Potassium 5S + 8T >= 200...
- A neurologist needs to counsel a stroke victim and her husband about possible outcomes, treatment options,...
- Case Study: Personal Beliefs in the Workplace Don Shakow was a prominent professional who worked in...
ADVERTISEMENT