Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

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: Electricity Machine Month Hours Costs January 2,900 $19,400 February 3,300 $23,000 March 2,300 $14,500 April 3,500 $25,000 May 4,200 $29,250 June 3,700 $24,000 July 4,500 $25,750 August 3,900 $23,750 September 2,400 $17,500 October 4,100 $28,000 November 5,400 $33,000 December 5,000 $28,750 Summary Output Regression Statistics Multiple R R Square Adjusted R2 Standard Error Observations Intercept Machine Hours 0.945 0.892 0.882 1,809.89 12.00 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% 4,788.52 5.19 2,207.13 0.57 2.17 9.11 0.06 0.00 (129.26) 3.92 9,706.31 6.46 Based on the results of the regression analysis, the estimate of electricity costs in a month with 2,600 machine hours would be: (rounded to the nearest whole dollar)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions