Please use excel and show all work

#2. The Bayside Fountain Hotel is adjacent to County Coliseum, a 24,000-seat arena that is home to the city's professional basketball and ice hockey teams and that hosts a variety of concerts, trade shows, and conventions throughout the year. The hotel has experienced the following occupancy rates for the past 9 years, since the coliseum opened: Year Occupancy Rate(%) 00aWN- 1 2 3 4 5 6 7 8 9 83 78 75 81 86 85 89 90 86 Compute an exponential smoothing forecast with a = 20, an adjusted exponential smoothing forecast with a = 20 and B = .20, and a linear trend line forecast. Plot all three forecasts