Question: Instruction: 1. Use the Boarded column data to make a time series line chart for the Full Fare demand and the Discount Fare demand. Do
Instruction:
1. Use the Boarded column data to make a time series line chart for the Full Fare demand and the Discount Fare demand. Do you see any pattern in the demand? Based on what you see, which of the methods (moving average, exponential smoothing, or Winter's) would you choose for forecasting this demand? Why?
Explanation:
2. Use the method identified in Q1 to forecast the demand of the next flight. You can work on the Data worksheet or create a new worksheet to work on your demand forecasting.
3. Please provide evidence to show that your chosen method perform better than one of the time series methods that you did not choose. Type your explanation below.
Explanation:
Please use Excel to input the numbers below. I was not able to upload my excel file, so I had to write everything out. Also please help with all answers.
Full Coach Fare History
Net Reservation Activity
--Weeks From Event------ |-Months From Event-|
Boarded 1 2 3 4 5 6 7 2 3 4 5 6
34 53 51 37 28 23 16 15 13 8 9 6 5
26 40 40 29 18 16 14 12 10 6 7 5 5
27 42 39 30 22 15 15 13 10 7 6 6 4
36 43 40 28 21 17 11 10 11 6 6 5 4
37 40 39 32 16 13 15 9 8 7 6 4 5
49 61 56 40 28 24 22 16 14 11 10 9 7
60 62 55 43 28 23 17 15 13 10 10 8 6
39 50 47 38 22 17 14 14 13 11 8 7 6
54 60 60 41 29 23 19 14 15 12 9 9 6
59 61 54 48 28 21 20 17 13 13 10 8 6
56 71 69 51 34 30 24 19 16 13 12 9 7
52 65 61 45 33 27 18 16 14 13 11 8 6
22 32 27 27 14 12 8 7 8 5 4 4 3
51 63 63 42 28 23 20 19 14 11 11 8 6
56 61 56 47 31 21 17 16 14 13 10 9 6
56 64 62 43 30 22 22 18 13 14 11 9 6
23 33 28 22 17 13 8 8 9 7 5 4 3
46 51 45 40 26 21 18 15 11 10 8 7 6
52 58 54 44 28 22 19 14 14 11 10 8 6
49 58 57 46 29 20 15 14 12 11 9 7 6
42 58 59 41 26 23 16 16 14 12 10 7 5
55 68 68 46 30 29 22 17 14 12 12 8 6
21 35 34 24 16 13 13 11 9 8 6 4 3
39 42 40 27 23 14 16 10 8 8 6 6 5
39 41 38 27 21 16 13 11 10 8 7 6 4
26 37 36 29 16 14 9 11 7 8 6 4 5
54 72 70 52 32 28 19 20 16 15 11 9 8
41 43 37 34 19 17 12 11 11 8 7 6 4
44 50 45 38 26 21 16 12 11 10 8 7 5
21 37 39 23 19 12 14 11 7 6 6 5 4
58 68 68 49 34 27 24 18 16 13 11 8 8
37 52 53 35 23 21 15 13 13 11 9 6 5
59 77 76 56 40 32 23 21 17 13 13 11 9
47 64 63 47 31 26 19 19 15 12 11 8 5
53 58 54 42 29 24 21 14 14 12 9 8 5
43 43 43 34 21 18 12 13 9 8 7 5 3
39 50 44 40 26 20 14 14 11 8 8 7 5
29 35 29 23 20 11 9 11 6 7 5 4 4
33 42 37 34 18 17 13 11 10 7 7 5 4
40 56 51 38 29 23 15 14 14 12 8 7 7
Discount Fare History
Net Reservation Activity
--Weeks From Event------ |-Months From Event-|
Boarded ==
1 2 3 4 5 6 7 2 3 4 5 6
87 88 90 92 90 84 76 71 59 47 36 24 14
81 85 87 88 87 81 75 67 60 46 34 21 12
65 70 71 73 70 69 67 62 53 41 29 22 16
57 57 58 59 62 58 55 47 38 31 23 16 11
94 99 101 103 104 101 97 87 73 56 40 27 14
69 73 74 76 77 77 71 62 52 39 31 19 14
91 95 97 99 98 97 90 83 70 59 44 30 20
67 71 72 74 75 74 66 57 50 40 28 22 14
66 70 71 73 75 72 68 63 53 40 33 23 13
73 73 74 76 78 73 71 64 54 42 29 18 14
82 84 86 87 88 83 79 69 59 50 40 27 15
82 85 87 88 86 85 80 71 62 50 36 25 13
101 106 108 110 113 108 101 89 77 64 51 38 23
102 106 108 110 108 105 98 88 74 59 42 32 16
97 102 104 106 103 99 94 85 71 55 43 28 19
61 66 67 69 67 65 61 56 48 36 29 21 11
68 70 71 73 73 70 63 54 48 41 30 20 15
86 88 90 92 93 90 87 81 66 52 41 29 18
91 97 99 101 104 99 93 86 73 57 45 32 18
100 105 107 109 110 108 100 88 77 63 49 33 17
82 82 84 85 84 79 72 64 57 43 31 23 12
90 91 93 95 96 90 82 76 62 49 36 26 17
82 86 88 89 89 85 81 70 59 49 35 26 13
74 79 81 82 83 79 71 61 55 44 33 20 12
104 107 109 111 114 111 105 97 81 67 53 38 24
63 69 70 72 74 70 62 53 43 34 23 19 12
89 93 95 97 100 95 88 81 70 56 43 27 15
65 69 70 72 75 72 66 56 47 38 31 24 17
67 69 70 72 74 73 66 56 45 36 25 18 9
104 105 107 109 111 108 100 89 74 57 45 31 17
103 106 108 110 108 102 92 84 73 57 40 25 15
80 86 88 89 87 86 78 71 61 51 40 27 19
61 65 66 68 69 66 59 54 45 34 24 18 9
65 65 66 68 65 64 60 52 42 34 25 19 13
76 79 81 82 83 82 76 71 63 50 35 26 16
66 68 69 71 68 64 62 53 48 40 30 21 13
97 98 100 102 103 99 93 81 68 55 40 25 15
98 101 103 105 107 105 100 88 76 63 48 34 23
100 101 103 105 104 102 95 85 71 57 44 32 21
105 111 113 115 114 110 104 93 79 65 50 32 19
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help