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:MonthMachine HoursUtilityCostsJanuary3,250$22,080 February3,770 25,200 March2,470 16,200 April4,030 27,600 May4,940 33,900 June4,290 26,400 July5,330 29,700 August4,550 27,300 September2,600 18,600 October4,810 31,200 November6,110 37,200 December5,460 33,300 SUMMARY OUTPUTRegression StatisticsMultiple R96.5%R Square93.2%Adjusted R-Square92.5%Standard Error1,710.21 Observations12.00  CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Intercept4,472.262,019.392.210.051-27.238971.74Machine

Hours5.3290.45511.703.69E-074.3146.343Required:(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.

What will be an ideal response?


(a.)
$4,472.26 + ($5.329 × machine hours)
(b.)
Yes, the t-stat of 11.70 exceeds the general rule of thumb of 2.
(c.)
$4,472.26 + ($5.329 × 3,000) = $20,459.26

Business

You might also like to view...

Implied authority can be best described as a situation where:

A) The conduct of two parties indicate that they are acting in a principal and agent capacity. B) The principal and agent undertake actions in accordance with their earlier agreement that one act as agent for the other. C) The principal has made representations to a third party that someone is to act as her agent. D) The agent has made representations to a third party that he is acting as an agent for another. E) Both B and C

Business

Researchers used meta-analysis to examine the levels of transformational leadership in 18 countries. These researchers found that

a. transformational leadership was negatively correlated with Gross Domestic Product (GDP) b. transformational leadership was not correlated with Gross Domestic Product (GDP) (i.e., the correlation was roughly zero). c. transformational leadership was positively correlated with Gross Domestic Product (GDP) d. transformational leadership was curvilinearly related to Gross Domestic Product such that highest levels of GDP occurred with moderate levels of transformational leadership

Business

One of the assumptions made in forecasting financial requirements based on the forecasted income statement is that:?

A. ?costs in the next year will remain the same as the previous year. B. ?costs will increase at the same rate as sales. C. ?costs in the next year will be an average of the costs of the three previous years. D. ?costs will move in the opposite direction of sales. E. ?costs will be according to the industry standards.

Business

Industry profits decline during the market maturity stage, due to

A. declining competition and declining manufacturing costs. B. increased competitive pressure to cut prices. C. mismanaged budgets and price stabilization. D. the sale of shoddy varieties of the original product. E. declining sales and dipping promotion costs.

Business