Question: Can someone answer this using EXCEL and the Regression tool in Data Analysis? If you have other software, please don't answer. I need to know

Can someone answer this using EXCEL and the Regression tool in Data Analysis? If you have other software, please don't answer. I need to know how to code the weather conditions and see if they are statistically significant.
Thank you.
2. Main Street wants to further develop the model to include the weather conditions of rainy, cloudy, or clinnu a. Should you keep weather condition in the model? ( 5 pts ) b. What is the regression equation? (5 pts) c. Use the equation to forecast event attendance if the temperature is 84F and sunny. (10 pts)Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
