Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following excel printout provides information to estimate overhead costs using linear regression. Coefficient Standard-Error-Stat P-Value Lower 95% Upper 95% Intercept 6035.99 1411.05 4.280.003 2782.09

The following excel printout provides information to estimate overhead costs using linear regression.

Coefficient Standard-Error-Stat P-Value Lower 95% Upper 95%

Intercept 6035.99 1411.05 4.280.003 2782.09 9289.89

DLH 4.56 1.61 2.83 0.022 0.85 8.27

#Setups771.154.93 14.03 6.44e-07 644.42 897.78

# Moves 29.94 2.87 10.42 6.26E-06 23.31 36.57

Regression Statistics

Multiple R 0.9966

R-Square 0.9932

Adjusted R-Square 0.9906

Standard Error 347.96

Observations 12

The estimated regression equation would be:

a) 6035.99 + 1411.05 DLH + 428 # SETUPS + 0.002 # MOVES

b) 6035.99 + 4.56 DLH + 771.10 # SETUPS + 29.94 # MOVES

c) 411.05 + 1.61 DLH + 54.93 # SETUPS + 2.87 # MOVES

d) 4.28 + 2.83 DLH + 14.04 # SETUPS + 10.42 # MOVES

Please explain.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Financial & Managerial Accounting

Authors: Jan Williams, Sue Haka, Mark Bettner, Joseph Carcello

15th Edition

0073526991, 9780073526997

More Books

Students also viewed these Accounting questions

Question

Do not come to the conclusion too quickly

Answered: 1 week ago

Question

Engage everyone in the dialogue

Answered: 1 week ago