Answered step by step
Verified Expert Solution
Question
1 Approved Answer
41. Thane Company is interested in establishing the relationship between electricity costs and machine hours. Data have been collected and a regression analysis prepared using
41. 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 Electricity Costs Month January February March April May June July August 3,100 3,500 2,500 3,700 4,400 3,900 4,700 4,100 2,600 4,300 5,800 5,400 $ 18,700 s 21,600 $ 13,800 $23,600 $ 28,550 $ 22,600 $25,050 23,050 $ 16,100 $26,600 31,600 $ 28,050 October December Summary Output Regression Statistics MultipleR R Square Adjusted R? Standard Error Observations 947 897 887 1753.98 12.00 Coefficlents Standard Error t Stat P-value 0.11 0.00 Lower 95% (1,004.49) 3.71 Upper 95% 8,558.03 6.04 Intercept 3,776.77 2145.85 0.52 1.76 Machine Hours 4.87 9.35 If the controller uses regression analysis to estimate costs, the estimate of the variable portion of electricity cost is: O Variable Cost $0.52 x Machine-hours. O Variable Cost $0.90 x Machine-hours O Variable Cost $4.87 x Machine-hours. Variable Cost-$9.35% Machine-hours
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started