The following excel printout provides information to estimate overhead costs using linear regressio Upper 95% 9289.88697 P-value Coefficients 6035.987027 4.558482698 Standard Error tStat Lower 95% Intercept 1411.05464 4.277642 0.002696 2782.0871 DLH 1.609683731 2.831912 0.022085 0.846543 8.27042244 # setups # moves 771.1028938 14.03685 6.44E-07 6.26E-06 54.93418317 644.42436 23.312095 897.781429 29.9411124 2.874675342 10.41548 36.5701299 Regression Statistics Multiple R R Square Adjusted R Square Standard Error 0.996584412 0.99318049 0.990623174 347.9563597 12 Observations 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: 57,683.79

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
icon
Concept explainers
Topic Video
Question
ersity
The following excel printout provides information to estimate overhead costs using linear regression:
Coefficients
6035.987027
4.558482698
771.1028938
29.9411124
Standard Error t Stat
1411.05464
1.609683731
54.93418317
2.874675342
P-value
0.002696
0.022085
6.44E-07
6.26E-06
Lower 95%
2782.0871
0.846543
644.42436
23.312095
Upper 95%
9289.88697
8.27042244
897.781429
36.5701299
Intercept
DLH
4.277642
2.831912
14.03685
10.41548
# setups
# moves
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. 57,683.79
Co search
10
Transcribed Image Text:ersity The following excel printout provides information to estimate overhead costs using linear regression: Coefficients 6035.987027 4.558482698 771.1028938 29.9411124 Standard Error t Stat 1411.05464 1.609683731 54.93418317 2.874675342 P-value 0.002696 0.022085 6.44E-07 6.26E-06 Lower 95% 2782.0871 0.846543 644.42436 23.312095 Upper 95% 9289.88697 8.27042244 897.781429 36.5701299 Intercept DLH 4.277642 2.831912 14.03685 10.41548 # setups # moves 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. 57,683.79 Co search 10
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Application of Algebra
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
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