Clough Company Is Interested in Establishing the Relationship Between Utility

question 118

Essay

Clough Company is interested in establishing the relationship between utility costs and machine hours.Data have been collected and a regression analysis prepared using Excel.The monthly data and the regression output follow:
$\begin{array}{|l|r|r|}\hline \text { Month } & \text { Machine } & \text { Electricity } \\& \text { Hours } & \text { Costs } \\\hline \text { January } & 3,250 & 22,080 \\\hline \text { February } & 3,770 & 25,200 \\\hline \text { March } & 2,470 & 16,200 \\\hline \text { April } & 4,030 & 27,600 \\\hline \text { May } & 4,940 & 33,900 \\\hline \text { June } & 4,290 & 26,400 \\\hline \text { July } & 5,330 & 29,700 \\\hline \text { August } & 4,560 & 27,300 \\\hline \text { September } & 2,600 & 18,600 \\\hline \text { October } & 4,810 & 31,200 \\\hline \text { Nowember } & 6,110 & 37,200 \\\hline \text { December } & 5,460 & 33,300 \\\hline\end{array}$


Required:
(a. )What is the equation for utility costs using the regression analysis?
(b. )Does the variable "machine hours" have statistical significance? Explain.(c. )Prepare an estimate of utility costs for a month when 3,000 machine hours are worked.

---

Definitions:

Cyclopentane

A cyclic alkane with the formula C5H10, characterized by a ring of five carbon atoms.

Boiling Point

The temperature at which a substance changes from a liquid to a gas.

Alkanes

Hydrocarbons consisting entirely of single-bonded carbon and hydrogen atoms and are the simplest form of hydrocarbons.

Dimethylpropyl

A hydrocarbon group or moiety consisting of a propyl backbone with two methyl substituents.