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


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

Extracted 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

Jun 01, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here