Please complete all work in excel. Use excel to make any necessary calculations and be sure to identify your answer, including units (if necessary).

1. The city is trying to determine future demand for their pool to help with staffing decisions. The city thinks that demand could be related to temperature in Fahrenheit. Below is the most recent data from the last two weeks.

Pool Attendance	Temperature (F)
140	85
110	80
135	90
120	80
165	85
180	85
210	90
190	85
170	95
130	80
140	85
80	75
120	90
100	85

1. What is the regression equation? (5 pts)
2. Use the equation to forecast pool attendance if temperature is 88F. (10 pts)
3. Is the model statistically significant at the 0.05 level? (5 pts)
4. How much is the variability in pool attendance determined by temperature (F)? (10 pts)