All work must be done in excel

98 86 2. Main Street wants to further develop the model to include the weather conditions of rainy, cloudy, or sunny. Event Attendance Temperature (F) Weather Condition 1500 88 Sunny 1200 81 Rainy 1250 80 Cloudy 1300 87 Cloudy 1750 91 Cloudy 1700 97 Sunny 2000 Sunny 1800 Sunny 1650 87 Sunny 1400 82 Sunny 1200 81 Cloudy 900 79 Rainy 1300 86 Rainy 1200 92 Rainy . What is the regression equation? (5 pts) b. Use the equation to forecast event attendance if the temperature is 86F and cloudy. (10 pts) c. Should you keep weather condition in the model? (5 pts)