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 $ 18,500
February 3,100 $ 21,200
March 2,100 $ 13,600
April 3,300 $ 23,200
May 4,000 $ 28,350
June 3,500 $ 22,200
July 4,300 $ 24,850
August 3,700 $ 22,850
September 2,200 $ 15,700
October 3,900 $ 26,200
November 4,900 $ 31,200
December 4,400 $ 27,850

Summary Output
Regression Statistics
Multiple R 0.965
R Square 0.930
Adjusted R2 0.923
Standard Error 1,443.07
Observations 12.00

Coefficients Standard Error t Stat P-value Lower 95% Upper 95%
Intercept 2,728.64 1,800.97 1.52 0.16 (1,284.17) 6,741.44
Machine Hours 5.77 0.50 11.56 0.00 4.66 6.88

The percent of the total variance that can be explained by the regression 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

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

Gleim CIA Review Part 3 Internal Audit Knowledge Elements

Authors: Irvin N. Gleim

2018 Edition

1618541153, 978-1618541154

More Books

Students also viewed these Accounting questions