Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Old MathJax webview Thane Company is interested in establishing the relationship between electricity costs and machine hours. Data have been collected and a regression analysis
Old MathJax webview
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 Machine Hours 3,500 3,900 2,900 4,1ee 4,80e 4,300 5,500 4,500 3, 4,700 May Electricity Costs $18,900 $22,000 $14,000 $24,000 $28,750 $23, eee $25,250 $23, 25e $16,500 $27,000 $32,000 $28,250 June July August September October November December 6,800 6,000 Summary Output Regression Statistics Multiple R 0.919 R Square 0.844 Adjusted R2 0.829 Standard Error 2,165.73 Intercept Machine Hours Coefficients 5,084.31 4.11 Standard Error 2,589.60 0.56 t Stat p-value 1.96 0.08 7.36 e.ee Lower 95% Upper 95% (685.68) 10,854.29 2.86 5.35 Based on the results of the high-low analysis, the estimate of electricity costs in a month with 3,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 $20,450 $15,513 O $15,368 O O $18,233 Summary output Regression statistics Multiple R 0.919 0.344 Adjusted R2 0.829 Standard Error 2.165.73 Observations 12.00 R Square Intercept Machine Hours Coefficients 5,084.31 4.11 Standard Error 2.589.60 0.56 Star P-value 1.96 0.08 7.36 0.00 Lower 95% Upper 95% (085.68) 10,854.29 2.86 5.35 Based on the results of the high low analysis the estimate of electricity costs in a month with 3.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 120,450 415 513
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