Answered step by step
Verified Expert Solution
Link Copied!

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

Thane Company is interested in establishing the relationship between electricity costs and machine hours.Based on the results of the regression analysis, the estimate of electricity costs in a month with 2,200

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 Multiple R R Square Summary Output Regression Statistics Adjusted R Standard Error Observations Machine Hours 2,500 2,900 1,900 3,100 3,800 3,300 4,100 Intercept Machine Hours 3,500 2,000 3,700 4,700 4,200 0.965 0.932 0.925 1,425.18 12.00 Electricity Costs $18,400 21,000 13,500 23,000 28,250 22,000 24,750 22,750 15,500 26,000 31,000 27,750 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% 3,726.88 0.05 (22.69) 7,476.45 4.67 6.87 1,682.82 2.21 5.77 0.49 11.7 0.00 Based on the results of the regression analysis, the estimate of electricity costs in a month with 2,200 machine hours would be: (rounded to the nearest whole dollar) Multiple Choice O O $22,825. $15,180. $3,727. $16,421.

Step by Step Solution

3.35 Rating (155 Votes )

There are 3 Steps involved in it

Step: 1

Based on the results of the regression analysis the estimate of electricity costs in a month with 22... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting Decision Making and Motivating Performance

Authors: Srikant M. Datar, Madhav V. Rajan

1st edition

132816245, 9780132816243, 978-0137024872

More Books

Students also viewed these Accounting questions

Question

6. Creating: Creating something new by combining different ideas.

Answered: 1 week ago