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:

MonthMachine HoursElectricity Costs

January2,100$ 19,000

February2,500$ 22,200

March1,500$ 14,100

April2,700$ 24,200

May3,400$ 28,850

June2,900$ 23,200

July3,700$ 25,350

August3,100$ 23,350

September1,600$ 16,700

October3,300$ 27,200

November4,300$ 32,200

December3,800$ 28,350

Summary Output

Regression Statistics

Multiple R.959

R Square.919

Adjusted R2.911

Standard Error1,558.51

Observations12.00

CoefficientsStandard Errort StatP-valueLower 95%Upper 95%

Intercept6,967.321,631.914.270.003,331.2010,603.44

Machine Hours5.760.5410.680.004.566.96

Based on the results of the regression analysis, the estimate of electricity costs in a month with 1,800 machine hours would be closest to:(rounded to the nearest wholedollar)

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

Financial Accounting and Reporting

Authors: Barry Elliott, Jamie Elliott

14th Edition

978-0273744535, 273744445, 273744534, 978-0273744443

More Books

Students also viewed these Accounting questions