Question (2): Referred to your understanding about forecasting, solve the following problem: (10 marks) Room registration in the Towers Plaza hotel have been recorded for the past 9 years. To project future occupancy, management would like to determine the mathematical trend of guest registration. The estimate will help the hotel determine whether future expansion will be needed. Given the following time-series data, develop a Linear trend equation to forecast year 2010. Show your work inside the table X? XY ml Year X 1 2 3 4 5 6 7 8 9 Total Average Registrants Y 17 16 16 21 20 20 23 25 24