Question
wants to establish the relationship between electricity costs and machine hours. Data have been collected and a regression analysis prepared using Excel. The monthly data
wants to establish 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 | 2,500 | $ | 18,400 | |
February | 2,900 | 21,000 | ||
March | 1,900 | 13,500 | ||
April | 3,100 | 23,000 | ||
May | 3,800 | 28,250 | ||
June | 3,300 | 22,000 | ||
July | 4,100 | 24,750 | ||
August | 3,500 | 22,750 | ||
September | 2,000 | 15,500 | ||
October | 3,700 | 26,000 | ||
November | 4,700 | 31,000 | ||
December | 4,200 | 27,750 | ||
Summary Output | |
Regression Statistics | |
Multiple R | 0.965 |
R Square | 0.932 |
Adjusted R2 | 0.925 |
Standard Error | 1,425.18 |
Observations | 12.00 |
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | |
Intercept | 3,726.88 | 1,682.82 | 2.21 | 0.05 | (22.69) | 7,476.45 |
Machine Hours | 5.77 | 0.49 | 11.7 | 0.00 | 4.67 | 6.87 |
If the controller uses the high-low method to estimate costs, the cost equation for electricity costs is:
Question options:
|
Electricity Costs = $6.90 Machine-hours.
|
|
Electricity Costs = $1,625.00 + ($6.25 Machine-hours).
|
|
Electricity Costs = $3,726.88 + ($5.77 Machine-hours).
|
|
Electricity Costs = $22,825.
|
Shell wants to establish 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,300 | $ | 18,800 | |
February | 3,700 | $ | 21,800 | |
March | 2,700 | $ | 13,900 | |
April | 3,900 | $ | 23,800 | |
May | 5,200 | $ | 28,650 | |
June | 4,100 | $ | 22,800 | |
July | 5,100 | $ | 25,150 | |
August | 4,300 | $ | 23,150 | |
September | 2,800 | $ | 16,300 | |
October | 4,500 | $ | 26,800 | |
November | 6,200 | $ | 31,800 | |
December | 5,700 | $ | 28,150 | |
Summary Output | |
Regression Statistics | |
Multiple R | 0.957 |
R Square | 0.916 |
Adjusted R2 | 0.908 |
Standard Error | 1,584.49 |
Observations | 12.00 |
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | |
Intercept | 3,998.65 | 1,911.17 | 2.09 | 0.06 | (259.71) | 8,257.01 |
Machine Hours | 4.53 | 0.43 | 10.47 | 0.00 | 3.56 | 5.49 |
If the controller uses regression analysis to estimate costs, the cost equation for electricity costs is:
Question 5 options:
|
Electricity Costs = $3,998.65 + ($1,911.17 Machine-hours).
|
|
Electricity Costs = $3,998.65 + ($4.53 Machine-hours).
|
|
Electricity Costs = $1,911.17 + ($0.43 Machine-hours).
|
|
Electricity Costs = $1,584.49 + ($12.00 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