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,600 $ 19,250
February 3,000 $ 22,700
March 2,000 $ 14,350
April 3,200 $ 24,700
May 3,900 $ 29,100
June 3,400 $ 23,700
July 4,200 $ 25,600
August 3,600 $ 23,600
September 2,100 $ 17,200
October 3,800 $ 27,700
November 4,800 $ 32,700
December 4,300 $ 28,600

Summary Output
Regression Statistics
Multiple R 0.955
R Square 0.912
Adjusted R2 0.904
Standard Error 1,630.46
Observations 12.00

Coefficients Standard Error t Stat P-value Lower 95% Upper 95%
Intercept 4,476.65 1,979.98 2.26 0.05 64.99 8,888.32
Machine Hours 5.76 0.56 10.20 0.00 4.50 7.01

The correlation coefficient for the regression equation for electricity costs is:

Multiple Choice

  • 0.955.

  • 0.912.

  • 0.904.

  • 0.962.

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

Cost Accounting Foundations and Evolutions

Authors: Michael R. Kinney, Cecily A. Raiborn

9th edition

9781285401072, 1111971722, 1285401077, 978-1111971724

More Books

Students also viewed these Accounting questions

Question

What are the different techniques used in decision making?

Answered: 1 week ago