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:

Month Machine Hours Electricity Costs
January 2,700 $ 19,300
February 3,100 $ 22,800
March 2,100 $ 14,400
April 3,300 $ 24,800
May 4,000 $ 29,150
June 3,500 $ 23,800
July 4,300 $ 25,650
August 3,700 $ 23,650
September 2,200 $ 17,300
October 3,900 $ 27,800
November 4,900 $ 32,800
December 4,400 $ 28,650

Summary Output
Regression Statistics
Multiple R 0.954
R Square 0.911
Adjusted R2 0.902
Standard Error 1,645.83
Observations 12.00

Coefficients Standard Error t Stat P-value Lower 95% Upper 95%
Intercept 3,979.06 2,054.03 1.94 0.08 (597.59) 8,555.71
Machine Hours 5.76 0.57 10.11 0.00 4.49 7.03

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 to Expert-Tailored Solutions

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

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

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

Life Audit Journal What Is My Why

Authors: A S

1st Edition

B08F6TXV7Z, 9798672209692

More Books

Students also viewed these Accounting questions

Question

What are the shortcomings of this method?

Answered: 1 week ago