SOM 307 - Data Analysis and Modeling » Fall 2021 » ma.mad.ts.mse

Need help with your exam preparation?

Existing Quiz Clients Login here
Question #1
Given the attached data. Answer the following questions for a 8 period moving average. t At 1 15699 2 2655 3 4164 4 5785 5 15783 6 6786 7 4042 8 13586 9 17105 10 12290 11 14714 12 9875 13 15772 14 1665 15 10242 16 8370 17 9371 18 7020 19 3998 20 6325 21 2957 22 15931 23 12685 24 10227 25 12884 26 11302 27 9349 28 9535 29 18479 30 5019 31 2352 32 7524 33 10307 34 4140 35 11249 36 5910 37 9100 38 9737 39 13129 40 11676 41 10948 42 13087 43 4630 44 3826 45 8386 46 11611 47 13200 48 3274 49 12066 50 7341 MAD = Average(|A-F|) TS =SUM(A-F)/MAD MSE = Average(A-F)2 Compute the MAD value for period 50.
A.   3892.54 units.
B.   2798.06 units.
C.   2128.08 units.
D.   4148.4 units.
E.   3205.7 units.
Question #2
Given the attached data. Answer the following questions for a 8 period moving average. t At 1 15699 2 2655 3 4164 4 5785 5 15783 6 6786 7 4042 8 13586 9 17105 10 12290 11 14714 12 9875 13 15772 14 1665 15 10242 16 8370 17 9371 18 7020 19 3998 20 6325 21 2957 22 15931 23 12685 24 10227 25 12884 26 11302 27 9349 28 9535 29 18479 30 5019 31 2352 32 7524 33 10307 34 4140 35 11249 36 5910 37 9100 38 9737 39 13129 40 11676 41 10948 42 13087 43 4630 44 3826 45 8386 46 11611 47 13200 48 3274 49 12066 50 7341 MAD = Average(|A-F|) TS =SUM(A-F)/MAD MSE = Average(A-F)2 Compute standard deviation of forecast for period 51.
A.   4866 units.
B.   4007 units.
C.   2660 units.
D.   4161 units.
E.   498 units.
Question #3
Given the attached data. Answer the following questions for a 8 period moving average. t At 1 15699 2 2655 3 4164 4 5785 5 15783 6 6786 7 4042 8 13586 9 17105 10 12290 11 14714 12 9875 13 15772 14 1665 15 10242 16 8370 17 9371 18 7020 19 3998 20 6325 21 2957 22 15931 23 12685 24 10227 25 12884 26 11302 27 9349 28 9535 29 18479 30 5019 31 2352 32 7524 33 10307 34 4140 35 11249 36 5910 37 9100 38 9737 39 13129 40 11676 41 10948 42 13087 43 4630 44 3826 45 8386 46 11611 47 13200 48 3274 49 12066 50 7341 MAD = Average(|A-F|) TS =SUM(A-F)/MAD MSE = Average(A-F)2 Compute the TS value for period 50.
A.   -0.2.
B.   2.3
C.   0
D.   -2
E.   1.9
Question #4
Given the attached data. Answer the following questions for a 8 period moving average. t At 1 15699 2 2655 3 4164 4 5785 5 15783 6 6786 7 4042 8 13586 9 17105 10 12290 11 14714 12 9875 13 15772 14 1665 15 10242 16 8370 17 9371 18 7020 19 3998 20 6325 21 2957 22 15931 23 12685 24 10227 25 12884 26 11302 27 9349 28 9535 29 18479 30 5019 31 2352 32 7524 33 10307 34 4140 35 11249 36 5910 37 9100 38 9737 39 13129 40 11676 41 10948 42 13087 43 4630 44 3826 45 8386 46 11611 47 13200 48 3274 49 12066 50 7341 MAD = Average(|A-F|) TS =SUM(A-F)/MAD MSE = Average(A-F)2 Compute the MSE value for period 50.
A.   21687584 units.
B.   15948260 units.
C.   13546074 units.
D.   11645593 units.
E.   24540365 units.
Question #5
Given the attached data. Answer the following questions for a 8 period moving average. t At 1 15699 2 2655 3 4164 4 5785 5 15783 6 6786 7 4042 8 13586 9 17105 10 12290 11 14714 12 9875 13 15772 14 1665 15 10242 16 8370 17 9371 18 7020 19 3998 20 6325 21 2957 22 15931 23 12685 24 10227 25 12884 26 11302 27 9349 28 9535 29 18479 30 5019 31 2352 32 7524 33 10307 34 4140 35 11249 36 5910 37 9100 38 9737 39 13129 40 11676 41 10948 42 13087 43 4630 44 3826 45 8386 46 11611 47 13200 48 3274 49 12066 50 7341 MAD = Average(|A-F|) TS =SUM(A-F)/MAD MSE = Average(A-F)2 Compute the standard deviation of demand for period 51 using MSE.
A.   2505 units.
B.   3413 units.
C.   4657 units.
D.   3680 units.
E.   3994 units.

Need help with your exam preparation?

Existing Quiz Clients Login here