Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
Summary Output Regression Statistics Multiple R R Square Adjusted R2 Standard Error Observations .959 .920 .912 1,550.32 12.00 t Intercept Machine Hours Coefficients 2,992.80 5.37
Summary Output Regression Statistics Multiple R R Square Adjusted R2 Standard Error Observations .959 .920 .912 1,550.32 12.00 t Intercept Machine Hours Coefficients 2,992.80 5.37 Standard Error 1,933.78 0.50 Stat 1.55 10.70 P-value 0.15 0.00 Lower 95% 01,315.92) 4.25 Upper 95% 730152 6.49 the controller uses the high-low method to estimate costs, the fixed cost portion of the cost equation for electricity cost is: (Rou ntermediate calculations to 2 decimal places.) O $23,670.00 O $2,992.80. O $1,550.32. $130.00 Thane Company is interested in establishing the relationship between electricity costs and machine hours. Dat 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,900 3,300 2,300 3,500 4,200 3,700 4,500 3,900 2,400 4,100 5,300 4,900 Electricity Costs $ 18,600 $ 21,400 $ 13,700 $ 23,400 $ 28,450 $ 22,400 $ 24,950 $ 22,950 $ 15,900 $ 26,400 $ 31,400 $ 27,950 Summary Output Regression Statistics .959 Multiple R R Square 1920
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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