Question: 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
Get step-by-step solutions from verified subject matter experts
