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
(4) October€“December€”for the past five years.
The company also has collected data for the average percentage fare discount for each of these quarters as follows:

a. 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 occupancy 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.

Transcribed Image Text:

ve lis 21 34 18 26 18 40 25 30 23 28 30 35 20 35 26 30 25 37 25 30 76 58 59 62 81 76 65 70 78 69 59 61 71 60 86 74 ar 1 2 3 4 1 2 3 4 1 2 3 12341234