What is the regression equation?  Use the equation to forecast pool attendance if temperature is 88°

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter4: Linear Programming Models
Section4.8: Data Envelopment Analysis (dea)
Problem 41P
icon
Related questions
Question

Please complete all work in excel.  Use excel to make any necessary calculations and be sure to identify your answer, including units (if necessary). Answers that need formulas must have them within the answer cell to receive full credit.

 

  1. City is trying to determine future demand for their public pool in order to help with staffing decisions. 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)

150

89

100

82

125

81

130

86

155

93

170

98

200

99

180

87

190

88

140

83

120

82

90

81

130

87

120

93

  1. What is the regression equation? 
  2. Use the equation to forecast pool attendance if temperature is 88° 
Expert Solution
steps

Step by step

Solved in 5 steps with 4 images

Blurred answer
Knowledge Booster
Inventory management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
MARKETING 2018
MARKETING 2018
Marketing
ISBN:
9780357033753
Author:
Pride
Publisher:
CENGAGE L