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,800 3,888 3,200 1,700 3,480 4,400 3,900 Electricity Costs $19,95 $22,300 $14,150 $24,300 $28,900 $23,300 $25,400 $23,400 $16,800 $27, 30e $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 Coefficients 6,468.83 Standard Error 1,698.62 t Stat 3.81 P-value .ee Lower 95% 2,684.06 Upper 95% 19,253.60 Intercept Seve & ENIE Subrr -HUJU>LCU Standard Error Observations 1,572.21 12.00 Intercept Machine Hours Coefficients 6,468.83 5.76 Standard Error 1,698.62 e.54 t Stdt 3.81 10.59 P-value 0.ee @.ee Lower 95% Upper 95% 2,684.66 10,253.60 4.55 6.97 If the controller uses regression analysis to estimate costs, the estimate of the variable portion of electricity costs is: Multiple Choice Electricity Costs - $054 Machine hours Electricity Costs - $10.59 Machine hours Electricity Costs - $576 Machine-hours Electricity Costs = $092 * Machine-hours
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