Question
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 | Machine Hours | Electricity Costs | ||
January | 3,500 | $ | 18,900 | |
February | 3,900 | $ | 22,000 | |
March | 2,900 | $ | 14,000 | |
April | 4,100 | $ | 24,000 | |
May | 4,800 | $ | 28,750 | |
June | 4,300 | $ | 23,000 | |
July | 5,500 | $ | 25,250 | |
August | 4,500 | $ | 23,250 | |
September | 3,000 | $ | 16,500 | |
October | 4,700 | $ | 27,000 | |
November | 6,800 | $ | 32,000 | |
December | 6,000 | $ | 28,250 | |
Summary Output | |
Regression Statistics | |
Multiple R | .919 |
R Square | .844 |
Adjusted R2 | .829 |
Standard Error | 2,165.73 |
Observations | 12.00 |
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | |
Intercept | 5,084.31 | 2,589.60 | 1.96 | 0.08 | (685.68) | 10,854.29 |
Machine Hours | 4.11 | 0.56 | 7.36 | 0.00 | 2.86 | 5.35 |
If the controller uses high-low method to estimate costs, the cost equation for electricity cost is:( Round intermediate calculations to 2 decimal places)
Multiple choice:
- Electricity costs= $21.716
- Electricity costs= $5,084.31 + ($4.11 * machine-hours)
- Electricity cost = $584 + (4.62 * machine-hours)
- Electricity costs = $5.40 * 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