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:
MonthMachine HoursElectricity Costs
January2,100$ 19,000
February2,500$ 22,200
March1,500$ 14,100
April2,700$ 24,200
May3,400$ 28,850
June2,900$ 23,200
July3,700$ 25,350
August3,100$ 23,350
September1,600$ 16,700
October3,300$ 27,200
November4,300$ 32,200
December3,800$ 28,350
Summary Output
Regression Statistics
Multiple R.959
R Square.919
Adjusted R2.911
Standard Error1,558.51
Observations12.00
CoefficientsStandard Errort StatP-valueLower 95%Upper 95%
Intercept6,967.321,631.914.270.003,331.2010,603.44
Machine Hours5.760.5410.680.004.566.96
Based on the results of the regression analysis, the estimate of electricity costs in a month with 1,800 machine hours would be closest to:(rounded to the nearest wholedollar)
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