% Seat % Average Fare Discount Year Quarter Occupancy 1 1 63 21 2 75 34 3 76 18 4 58 26 1 59 18 2 62 40 3 81 25 4 76 30 3 1 65 23 2 70 28 3 78 30 4 69 35 1 59 20 2 61 35 3 83 26 4 71 30 5 1 60 25 2 66 37 3 86 25 74 30
Arrow Air is a regional East Coast airline. It has collected data
for the percentage of available seats occupied on its flights for
four quarters—(1) January–March, (2) April–June, (3)
July–September, and (4) October–December—for the past five
years. The company also has collected data for the average per-
centage fare discount for each of these quarters as follows:
Develop a seasonally adjusted forecast model for seat
occupancy. Forecast seat occupancy for year 6 (using a
linear trend line forecast estimate for seat occupancy in
year 6).
b. Develop linear regression models relating seat occu-
pancy to discount fares to forecast seat occupancy for
each quarter in year 6. Assume a fare discount of 20%
for quarter 1, 36% for quarter 2, 25% for quarter 3, and
30% for quarter 4.
c. Compare the forecasts developed in parts (a) and (b)
and indicate which one appears to be the best.a
![% Seat
% Average
Fare Discount
Year
Quarter
Occupancy
1
1
63
21
2
75
34
3
76
18
4
58
26
1
59
18
2
62
40
3
81
25
4
76
30
3
1
65
23
2
70
28
3
78
30
4
69
35
1
59
20
2
61
35
3
83
26
4
71
30
5
1
60
25
2
66
37
3
86
25
74
30](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F8f2aff72-2ce1-4590-8b94-1a9b36f25f7d%2F2fb9992f-6b5b-4351-ab02-e6a7856e4c7c%2Fcmmiear_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 10 steps with 6 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Algebra: Structure And Method, Book 1](https://www.bartleby.com/isbn_cover_images/9780395977224/9780395977224_smallCoverImage.gif)
![Holt Mcdougal Larson Pre-algebra: Student Edition…](https://www.bartleby.com/isbn_cover_images/9780547587776/9780547587776_smallCoverImage.jpg)
![Glencoe Algebra 1, Student Edition, 9780079039897…](https://www.bartleby.com/isbn_cover_images/9780079039897/9780079039897_smallCoverImage.jpg)
![Algebra: Structure And Method, Book 1](https://www.bartleby.com/isbn_cover_images/9780395977224/9780395977224_smallCoverImage.gif)
![Holt Mcdougal Larson Pre-algebra: Student Edition…](https://www.bartleby.com/isbn_cover_images/9780547587776/9780547587776_smallCoverImage.jpg)
![Glencoe Algebra 1, Student Edition, 9780079039897…](https://www.bartleby.com/isbn_cover_images/9780079039897/9780079039897_smallCoverImage.jpg)
![Mathematics For Machine Technology](https://www.bartleby.com/isbn_cover_images/9781337798310/9781337798310_smallCoverImage.jpg)
![Elementary Geometry For College Students, 7e](https://www.bartleby.com/isbn_cover_images/9781337614085/9781337614085_smallCoverImage.jpg)
![Elementary Geometry for College Students](https://www.bartleby.com/isbn_cover_images/9781285195698/9781285195698_smallCoverImage.gif)