Thane Company Is Interested in Establishing the Relationship Between Electricity

question 17

Multiple Choice

Thane Company is interested in establishing the relationship between electricity 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}{lll}\text {Month}&\text {Machine Hours}&\text {Electricity Costs}\\\text { January } & 2,500 & \$ 18,400 \\\text { February } & 2,900 & 21,000 \\\text { March } & 1,900& 13,500 \\\text { April } & 3,100 & 23,000 \\\text { May } & 3,800& 28,250 \\\text { June } & 3,300& 22,000 \\\text { July } & 4,100 & 24,750\\\text { August } & 3,500 & 22,750 \\\text { September } & 2,000 & 15,500 \\\text { October } & 3,700 & 26,000 \\\text { November } & 4,700 & 31,000 \\\text { December } & 4,200 & 27,750\end{array}$



$$\begin{array}{c} { \text { Summary Output } } \\ { \text { Regression Statistics } } \\\begin{array}{ | l | c | } \hline \text { Multiple R } & 0.965 \\\hline \text { R Squuare } & 0.932 \\\hline \text { Adjusted R } ^2 & 0.925 \\\hline \text { Standard Error } & 1,425.18 \\\hline \text { Observations } & 12.00 \\\hline\end{array}\end{array}$$

$\begin{array}{|l|r|r|r|r|r|r|}\hline && \text { Standard } & && \text { Lower } & \text { Upper } \\&\text { Coefficients } & \text { Error } & \text { t Stat } & \text { P-value } & 95 \% & 95 \% \\ \hline \text { Intercept } & 3,726.88 & 1,682.82 & 2.21 & 0.05 & (22.69) & 7,476.45 \\\hline \text { Machine } & 5.77 & 0.49 & 11.7 & 0.00 & 4.67 & 6.87 \\\text { Hours } & & & & & \\\hline\end{array}$


-
Based on the results of the regression analysis, the estimate of electricity costs in a month with 2,200 machine hours would be: (rounded to the nearest whole dollar)

• A) $3,727.
• B) $16,421.
• C) $15,180.
• D) $22,825.

---

Definitions:

Tissues

Groups of cells with similar structure and function that work together to perform specific activities in the body.

Organs

Structures made up of different tissues that perform specific functions within an organism.

Molecules

The smallest units of a chemical substance that can exist independently while retaining the composition and chemical properties of the substance.

Thrombophlebitis

Inflammation of a vein caused by a blood clot.