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.

image 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 Hours 3, eee 3,400 2,400 3,600 4,3ee Month January February March April May June July August September October November December Electricity Costs $18,650 $21,5ee $13,750 $23,5ee $28,500 $22,5ee $25, eee $23, eee $16,000 $26,500 $31,500 $28, eee 3,800 4,600 4, eee 2,5ee 4,200 5,6ee 5, 2ee Summary Output Regression Statistics Multiple R 2.952 R Square 2.906 Adjusted R2 8.897 Standard Error 1,676.51 Observations 12.08 Intercept Machine Hours Coefficients 3,639.33 5.04 standard Error 2,848.60 8.51 t stat 1.78 9.83 P-value Lower 95% Upper 956 0.11 (925.25) 8, 203.90 3.89 6.18 @.00 The correlation coefficient for the regression equation for electricity costs is: Multiple Choice 0.956. 0.897 0.952 0.906

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

Forensic Accounting And Fraud Examination

Authors: Mary Jo Kranacher, Richard Riley

2nd Edition

1119494338, 9781119494331

More Books

Students also viewed these Accounting questions

Question

What are their resources?

Answered: 1 week ago

Question

What impediments deal with customers?

Answered: 1 week ago