three month weighted average using 0.60 for the prior month , 0.30 for two months prior and 0.10 for three months prior be:-
MONTH | DATA |
3 YEARS WEIGHTED MOVING AVERAGE ( weights 0.10 , 0.30, 0.60 respectively) |
January | 19 | |
February | 18 | |
March | 15 | |
April | 20 | (0.10*19)+(0.30*18)+(0.60*15) = 16.3 |
May | 18 | (0.10*18)+(0.30*15)+(0.60*20) = 18.3 |
June | 17 | (0.10*15)+(0.30*20)+(0.60*18) = 18.3 |
July | 19 | (0.10*20)+(0.30*18)+(0.60*17) = 17.6 |
August | 22 | (0.10*18)+(0.30*17)+(0.60*19) = 18.3 |
September | 23 | (0.10*17)+(0.30*19)+(0.60*22) = 20.6 |
October | (0.10*19)+(0.30*22)+(0.60*23) = 22.3 |
*** if you face any trouble to understand the answer to the problem please mention it in the comment box.if you are satisfied, please give me a LIKE if possible.
help with D July August September October 19 22 23 17.50 18.50 19 20.25 15+20+18-17=70/4-17.50 20+18+17+19=74/4-18.50...
Week
Sales (100s of gallons)
1
18
2
22
3
19
4
24
5
17
6
16
7
21
8
19
9
23
10
21
11
15
12
21
a. using a weight of 1/2 for the most recent observation, 1/3
for the second most recent observation, and 1/6 for the third most
recent observation, compute a three-week weighted moving average
for the time series (to 2 decimals). Enter negative values as
negative numbers.
b. compute the MSE for the...
AutoSaveff File Home InsertPage Layout Formulas Da D1 1 Year Month 2 1 13 17 1 January February 15 4 1 March 511 April 6 1 May 12 32 15 June 1 July 91 August 17 101 September33 15 October 12 1 November34 December 21 14 2 January26 15 2 February10 13 1 162 March 17 2 April 18 2 May 14 19 17 14 27 30 222 September25 June 21 2 23 2 25 27 3 29 3 August...
Sales (1000s of gallons) 18 Week 19 23 17 16 20 17 23 19 10 12 a. Compute four-week and five-week moving averages for the time series. If required, round your answers to two decimal places. 4 Period Period Moving ge Average Moving Averag WeekSales 18 19 23 17 16 19.6x 20.25 V 1911 19.4| 20 19.2x 19.25x 23 18.81 × 1019 1918.8 19.2x 11 14 20 ]X 18.75 12 b. Compute the MSE for the four-week and five-week moving...
Assignment 2.2: Forecasting Problem A Rio Farm Implements Inc. sells Commercial Rider Mowers. Monthly sales for a nine-month period were as follows Commercial Rider Mower Sales MONTH 19 January 18 February 15 March 20 April 18 May 17 June 19 July 22 August 23 September Forecast October sales using (SHOW YOUR WORK): a) the Naive approach b) A four-manth moving average c)a stx-month moving average d) a three-month weighted average using.60 for the prior manth .30 for the next prior...
11. June 17: Cash of $9,600 was paid for rent for June, July, August and September. Put the total amount into the Prepaid Rent account. 12. June 17: Received a bill of $450 from the local newspaper for advertising. 13. June 21: Billed various miscellaneous local customers $4,100 for consulting services performed. 14. June 21: A fax machine for the office was purchased for $775 cash. 15. June 21: Accounts payable in the amount of $400 were paid. 16. June...
11. June 17: Cash of $9,600 was paid for rent for June, July, August and September. Put the total amount into the Prepaid Rent account. 12. June 17: Received a bill of $450 from the local newspaper for advertising. 13. June 21: Billed various miscellaneous local customers $4,100 for consulting services performed. 14. June 21: A fax machine for the office was purchased for $775 cash. 15. June 21: Accounts payable in the amount of $400 were paid. 16. June...
17 18 19 Direction of disk rotation 14 15 19 20 21 22 23 24 Figure on the right shows the tracks and sectors on a disk. The size of File A, B, and C is 1028 bytes, 2521 bytes, and 8211 bytes respectivelv. Answer the following questions. 17 18 1 27 28/29 2212324252 If data block size is 1KB, how many data blocks does this disk contain? Answer: How many data blocks does File A take? Answe How many...
Please write in the answer clear. Will leave like if its
correct
.
Age
Gen
Sibs
Work
Exercise
Units
Mom
18
M
1
20
10
15
6
17
F
3
0
7
15
14
23
M
3
20
5
13
8
20
M
2
0
5
15
16
18
F
4
22
6
16
9
20
F
2
11
7
20
20
34
F
1
48
10
10
18
22
F
3
37
13
13
18
19
M
3
0...
2. Consider the following time series data: 2Month Value 20 15 23 6 4 13 6 18 25 10 8 10 9 24 12 10 21 13 19 14 15 la. Use a α # 0.25 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for Month 12. b. Compare the two-month moving average forecast with the exponential smoothing forecast using a 0.25. Which appears to 17 provide the better forecast based on MSE?...
The past sales history for Store 6 is provided in the table below. Adjust this data using the seasonality index determined using the initial 2 years. Report the re-seasonalized forecast period 36. Month Year Period Store 6 January 1 1 56602 February 1 2 72016 March 1 3 104245 April 1 4 100981 May 1 5 95962 June 1 6 83167 July 1 7 62842 August 1 8 60116 September 1 9 41353 October 1 10 34862 November 1 11...