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

image text in transcribedimage text in transcribed

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: Machine Electricity Month Hours Costs January 2,400 $19,150 February 2,800 $22,500 March 1,800 $14,250 April 3,000 $24,500 May 3,700 $29,000 June 3,200 $23,500 July 4,000 $25,500 August 3,400 $23,500 September 1,900 $17,000 October 3,600 $27,500 November 4,600 $32,500 December 4,100 $28,500 Summary Output Regression Statistics Multiple R 0.957 R Square 0.915 Adjusted R2 0.907 Standard Error 1,600.66 Observations 12.00 Coefficients Intercept Machine Hours 5,472.38 5.76 Standard Error t Stat 1,836.37 2.98 0.55 10.40 P-value Lower 95% 0.01 1,380.70 Upper 95% 9,564.07 0.00 4.52 6.99 The correlation coefficient for the regression equation for electricity costs is:

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

College Accounting A Practical Approach Chapters 1-25

Authors: Jeffrey Slater

13th Edition

9780133791006

Students also viewed these Accounting questions

Question

Be able to calculate cost of sales for a manufacturing business.

Answered: 1 week ago