Room registrations in the Toronto Towers Plaza Hotel have been recorded for the past nine years. To project future occupancy, management would like to determine the mathematical trend of guest registration. This estimate will help the hotel determine whether future expansion will be needed. Using EXCEL solve the following: a. Given the following time-series data, develop a linear regression equation relating registration to time. Then forecast 2025 registrations

\f