Answered step by step
Verified Expert Solution
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.
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,989 1,900 3,100 3,800 3,300 4,100 3,500 2,800 3,700 4,700 4,200 Electricity Costs $ 19, 280 $ 22,600 $ 14,300 $ 24,600 $ 29,050 $ 23,600 $ 25,550 $ 23,550 $ 17,100 $ 27,600 $ 32,600 $ 28,55 Summary Output Regression Statistics Multiple R 0.956 R Square 8.914 Adjusted R2 0.905 Standard Error 1.615.39 Observations 12.00 Intercept Machine Hours Coefficients 4,974.43 5.76 Standard Errort 1,987.43 0.56 Stat 2.61 10.30 p-value Lower 95% 0.03 724.41 0.00 4.51 Upper 95% 9,224.45 7 .00 Based on the results of the high-low analysis, the estimate of electricity costs in a month with 2.200 machine hours would be: (Round cost per machine hour to 2 decimal places and all other dollar amounts to nearest whole dollar.) Multiple Choice 0 $16,250. 0 0 0
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