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: Month January February March April May June July August September October November December Machine Hours 2,500 2,900 1,900 3,100 3,800 3,300 4,100 3,500 2,000 3,700 4,700 4,200 Electricity Costs $ 18,400 $ 21,000 $ 13,500 $ 23,000 $ 28,250 $ 22,000 $ 24,750 $ 22,750 $ 15,500 $ 26,000 $ 31,000 $ 27,750 Summary Output Regression Statistics Multiple R R Square Adjusted R2 Standard Error Observations .965 .932 925 1,425.18 12.00 I Intercept Machine Hours Coefficients 3,726.88 5.77 Standard Error 1,682.82 0.49 Stat 2.21 117 P-value 0.05 0.00 1 Lower 95% (22.69) 4.67 Upper 95% 7,476.45 6.87 Based on the results of the high-low analysis, the estimate of electricity costs in a month with 2,200 machine hours would be: $15,375. O $22,825. O $15,180 $16,427

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

Authors: Walter B. Meigs, A. N. Mosich, Robert F. Meigs

2nd Edition

0070412901, 978-0070412903

More Books

Students also viewed these Accounting questions

Question

5. How is Karen Slagles argument an example of confirmation bias?

Answered: 1 week ago