The following excel printout provides information to estimate overhead costs using linear regression: Standard Error t Stat Р-value Lower 95% Upper 95% Coefficients 6035.987027 1411.05464 4.277642 0.002696 2782.0871 9289.88697 Intercept DLH 4.558482698 1.609683731 2.831912 0.022085 0.846543 8.27042244 6.44E-07 6.26E-06 897.781429 36.5701299 644.42436 14.03685 10.41548 # setups 771.1028938 54.93418317 # moves 29.9411124 2.874675342 23.312095 Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.996584412 0.99318049 0.990623174 347.9563597 12 a. Write the multiple regression model (round to nearest cent). Answer: b. What is the estimate of overhead if the department has 1,205 DLH, 55 setups and 125 moves? Answer:

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
ph/mod/quiz/attempt.php?attempt3932918&lcmid%3D166208page%3D27
University
53
The following excel printout provides information to estimate overhead costs using linear regression:
Upper 95%
9289.88697
8.27042244
897.781429
36.5701299
Standard Error t Stat
P-value
Lower 95%
Coefficients
6035.987027
1411.05464
4.277642
0.002696
2782.0871
Intercept
DLH
ut of
4.558482698
1.609683731
2.831912
0.022085
0.846543
# setups
771.1028938
54.93418317
14.03685
6.44E-07
644.42436
29.9411124
2.874675342
10.41548
6.26E-06
23.312095
# moves
estion
Regression Statistics
Multiple R
R Square
Adjusted R Square
Standard Error
Observations
0.996584412
0.99318049
0.990623174
347.9563597
12
a. Write the multiple regression model (round to nearest cent).
Answer:
54
b. What is the estimate of overhead if the department has 1,205 DLH, 55 setups and 125 moves?
Answer:
out of
question
Transcribed Image Text:ph/mod/quiz/attempt.php?attempt3932918&lcmid%3D166208page%3D27 University 53 The following excel printout provides information to estimate overhead costs using linear regression: Upper 95% 9289.88697 8.27042244 897.781429 36.5701299 Standard Error t Stat P-value Lower 95% Coefficients 6035.987027 1411.05464 4.277642 0.002696 2782.0871 Intercept DLH ut of 4.558482698 1.609683731 2.831912 0.022085 0.846543 # setups 771.1028938 54.93418317 14.03685 6.44E-07 644.42436 29.9411124 2.874675342 10.41548 6.26E-06 23.312095 # moves estion Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.996584412 0.99318049 0.990623174 347.9563597 12 a. Write the multiple regression model (round to nearest cent). Answer: 54 b. What is the estimate of overhead if the department has 1,205 DLH, 55 setups and 125 moves? Answer: out of question
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Point Estimation, Limit Theorems, Approximations, and Bounds
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman