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.
Question
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.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 7 steps with 5 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, ai-and-machine-learning and related others by exploring similar questions and additional content below.