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,200 2,600 1,600 2,800 3,500 3,000 3,800 3,200 1,700 3,400 4,400 3,900 Electricity Costs $ 19,050 $22,300 $14,150 $24,300 $28,900 $23,300 $25,400 $23,400 $ 16,800 $27,300 $32,300 $28,400 Summary Output Regression Statistics Multiple R 0.958 R Square 0.918 Adjusted R2 0.910 Standard Error 1,572.21 Observations 12.00 Intercept Machine Hours | Coefficients Standard Errort Stat P-value Lower 95% Upper 95% 6,468.83 1,698.62 3.81 0.00 2,684.06 10,253.60 L 5.76 0.54 10.59 0.00 4.55 6.97 The correlation coefficient for the regression equation for electricity costs is: Multiple Choice 0.958. 0.910. 0.918. 0.968
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