please do 12.28 on excel and show all formulas used and as much excel help as possible , please and thank you so much

12.28. The manager of the Commander Hotel near City Stadium believes that how well the local Blue Sox professional baseball team is playing has an impact on the occupancy rate at the hotel during the summer months. Following are the number of victories for the Blue Sox (in a 162-game schedule) for the past eight years and the hotel occupancy rates: Year Number of Blue Sox Wins Occupancy Rate 1 81% 2 3 70 65 81 88 80 74 83 84 85 4 5 6 7 8 92 83 64 91 88 80 00 Develop a linear regression model for these data, and forecast the occupancy rate for next year if the Blue Sox win 85 games. Does there appear to be a strong relationship between wins and occupancy rate