Please complete all work in excel. Use excel to make any necessary calculations and be sure to identify the answer, including units (if necessary). Answers that need formulas must have them within the answer cell. City wants to further develop the model to include the weather conditions of rainy, cloudy, or sunny. Pool Attendance Temperature (°F) Weather Condition 150 89 Sunny 100 82 Rainy 125 81 Cloudy 130 86 Cloudy 155 93 Cloudy 170 98 Sunny 200 99 Sunny 180 87 Sunny 190 88 Sunny 140 83 Sunny 120 82 Cloudy 90 81 Rainy 130 87 Rainy 120 93 Rainy What is the regression equation? Use the equation to forecast pool attendance if the temperature is 88°F and sunny.

Please complete all work in excel. Use excel to make any necessary calculations and be sure to identify the answer, including units (if necessary). Answers that need formulas must have them within the answer cell. City wants to further develop the model to include the weather conditions of rainy, cloudy, or sunny. Pool Attendance Temperature (°F) Weather Condition 150 89 Sunny 100 82 Rainy 125 81 Cloudy 130 86 Cloudy 155 93 Cloudy 170 98 Sunny 200 99 Sunny 180 87 Sunny 190 88 Sunny 140 83 Sunny 120 82 Cloudy 90 81 Rainy 130 87 Rainy 120 93 Rainy What is the regression equation? Use the equation to forecast pool attendance if the temperature is 88°F and sunny.

Pool Attendance	Temperature (°F)	Weather Condition
150	89	Sunny
100	82	Rainy
125	81	Cloudy
130	86	Cloudy
155	93	Cloudy
170	98	Sunny
200	99	Sunny
180	87	Sunny
190	88	Sunny
140	83	Sunny
120	82	Cloudy
90	81	Rainy
130	87	Rainy
120	93	Rainy