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.28 0.003

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.28 0.003 2782.09 9289.89

DLH 4.56 1.61 2.83 0.022 0.85 8.27

#Setups 771.1 54.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 output suggest that?

A) 99.32% variation in the overhead cost is explained by changes in DLH, # setups, and # moves

B) 99.32% variation in the overhead cost is explained by changed in DLH

C) 99.06% variation in the overhead cost is explained by changes in DLH, # setups, and # moves

D) 99.67% variation in the overhead cost is explained by changes in DLH, # setups, and # moves

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 Accounting

Authors: Jan Williams, Susan Haka, Mark S Bettner, Joseph V Carcello

16th edition

1259692396, 77862384, 978-0077862381

More Books

Students also viewed these Accounting questions