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: Machine Hours 3, eee 3,400 2,400 3,600 4,3ee Month January February March April May June July August September October November December Electricity Costs $18,650 $21,5ee $13,750 $23,5ee $28,500 $22,5ee $25, eee $23, eee $16,000 $26,500 $31,500 $28, eee 3,800 4,600 4, eee 2,5ee 4,200 5,6ee 5, 2ee Summary Output Regression Statistics Multiple R 2.952 R Square 2.906 Adjusted R2 8.897 Standard Error 1,676.51 Observations 12.08 Intercept Machine Hours Coefficients 3,639.33 5.04 standard Error 2,848.60 8.51 t stat 1.78 9.83 P-value Lower 95% Upper 956 0.11 (925.25) 8, 203.90 3.89 6.18 @.00 The correlation coefficient for the regression equation for electricity costs is: Multiple Choice 0.956. 0.897 0.952 0.906
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