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

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

a. What is the regression equation? (5 pts)

b. Use the equation to forecast pool attendance if temperature is 88F. (10 pts)

c. Is the model statistically significant at the 0.05 level? (5 pts)

d. How much is the variability in pool attendance determined by temperature (F)?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Please complete all work in excel. Use excel to make any necessary calculations and be sure to identify your answer, including units (if necessary). A new business is testing out their operating...

HW 4 (50 pts) Please complete all work in excel. Use excel to make any necessary calculations and be sure to identify your answer, including units (if necessary). A manager of a call center has...

HW 5 (50 pts) - Please complete all work in excel. Use excel to make any necessary calculations and be sure to identify your answer, including units (if necessary). 88 1. Main Street is trying to...

Please complete all work in excel. Use excel to make any necessary calculations and be sure to identify your answer, including units (if necessary). The city wants to further develop the model to...

Please complete all work in excel. Use excel to make any necessary calculations and be sure to identify your answer, including units (if necessary). The city is trying to determine future demand for...

-- Please complete all work in excel. Use excel to make any necessary calculations and be sure to identify your answer, including units (if necessary). 1) A manager of a call center has noticed...

Please complete all work in excel. Use excel to make the calculations and be sure to identify your answer, including units. 3. The utilization of a machine is 70 percent. The machine has a design...

HW 1 Part 2- Please complete all work in excel. Use excel to make the calculations and be sure to identify your answer, including units. Given the following sales data: Quarter Year 1 Year 2 1 360...

HW 1 Part 2- Please complete all work in excel. Use excel to make the calculations and be sure to identify your answer, including units. 1. Home sales over a 4-month period were forecasted as...

HW 1 Part 2- Please complete all work in excel. Use excel to make the calculations and be sure to identify your answer, including units. 7) Design Expo is considering new locations for its...

Conduct a Japan macroeconomic analysis. Discuss topics such as economic growth, demography, current economic issues, inflation, and so on.

Fifteen years ago a couple purchased a house for $220 000 by paying a 20% down payment and financing the remaining balance with a 30-year mortgage at 5.06% compounded monthly: (a) Find the monthly...

If $166 was invested when the stock price was $48, the number of shares purchased in Quarter 2 was enter your response here shares.(Round to three decimal places.)

Milano Pizza is a small neighborhood pizzeria that has a small area for in-store dining as well as offering take-out and free home delivery services. The pizzeria's owner has determined that the shop...