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 CostsJanuary2,700$18,500February3,100$21,200March2,100$13,600April3,300$23,200May4,000$28,350June3,500$22,200July4,300$24,850August3,700$22,850September2,200$15,700October3,900$26,200November4,900$31,200December4,400$27,850
Summary OutputRegression StatisticsMultiple R0.965R Square0.930Adjusted R20.923Standard Error1,443.07Observations12.00
CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Intercept2,728.641,800.971.520.16(1,284.17)6,741.44Machine Hours5.770.5011.560.004.666.88
Based on the results of the high-low analysis, the estimate of electricity costs in a month with 2,400 machine hours would be
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