Question

Carlson Mining, Inc. has 12 large pumps that pump water from the mines it operates. Management...

Carlson Mining, Inc. has 12 large pumps that pump water from the mines it operates.
Management has been concerned lately about the amount of money required to
repair malfunctioning pumps. These costs are sums over and above the amounts
spent for routine maintenance. When asked what factors they thought might affect
the mean monthly repair costs, employees suggested the age of the pumps and the
number of hours of operation. The following information was collected.
Choose the relevant Summary Output to answer the questions. Note that the
mean monthly repair costs are in dollars, so when questions ask about repair
costs, make sure that your answers reflect that.
Mean Weekly Hours of Operation over Past Year Age of Pump at First of Year (months) Mean Monthly Repair Costs over Past Year
28 80 $1,049
26 48 $1,095
15 27 $882
12 2 $447
16 13 $715
21 55 $542
13 30 $415
21 35 $454
16 36 $495
12 13 $370
18 28 $448
18 49 $509
Develop an estimated regression equation to predict mean monthly repair costs with
both the mean weekly hours of operation and the age of the pumps as the
explanatory variables.
According to your equation, holding the mean weekly hours of operation constant,
for every additional month of age, the mean monthly repair costs (increase / do not
change / decrease) by _____. ROUND APPROPRIATELY AND INCLUDE
THE UNITS!

Homework Answers

Answer #1

Excel:

Data --> Data analysis --> Regression

Coefficients Standard Error t Stat P-value
Intercept -87.70037103 261.5249413 -0.33534 0.745051
Mean Weekly Hours of Operation over Past Year 45.09732343 21.8704701 2.062019 0.069253
Age of Pump at First of Year (months) -3.047157232 5.329493207 -0.57175 0.581485

Ans :

(i) yhat = -87.7004+45.0973(Mean Weekly Hours of Operation)-3.0472(Age of Pump at First of Year)

(ii) Decrease by 3.0472 dollars

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Carlson Mining, Inc. has 12 large pumps that pump water from the mines it operates. Management...
Carlson Mining, Inc. has 12 large pumps that pump water from the mines it operates. Management has been concerned lately about the amount of money required to repair malfunctioning pumps. These costs are sums over and above the amounts spent for routine maintenance. When asked what factors they thought might affect the mean monthly repair costs, employees suggested the age of the pumps and the number of hours of operation. The following information was collected. Choose the relevant Summary Output...
Carlson Mining, Inc. has 12 large pumps that pump water from the mines it operates. Management...
Carlson Mining, Inc. has 12 large pumps that pump water from the mines it operates. Management has been concerned lately about the amount of money required to repair malfunctioning pumps. These costs are sums over and above the amounts spent for routine maintenance. When asked what factors they thought might affect the mean monthly repair costs, employees suggested the age of the pumps and the number of hours of operation. The following information was collected. Choose the relevant Summary Output...
Delta airlines case study Global strategy. Describe the current global strategy and provide evidence about how...
Delta airlines case study Global strategy. Describe the current global strategy and provide evidence about how the firms resources incompetencies support the given pressures regarding costs and local responsiveness. Describe entry modes have they usually used, and whether they are appropriate for the given strategy. Any key issues in their global strategy? casestudy: Atlanta, June 17, 2014. Sea of Delta employees and their families swarmed between food trucks, amusement park booths, and entertainment venues that were scattered throughout what would...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT