Question 9 1/ 1 point A company want to find out if there is a linear relationship between indirect labor expense (ILE), in dollars, and direct labor hours (DLH). Data for direct labor hours and indirect labor expense for 25 months are given. Using the estimated regression equation found by using DLH as the predictor variable, find a point estimate for Indirect Labor Expense usage when the Direct Labor Hours is 407 Please see attached Excel for data. ILE_and_DLH data V(e 544.45 177.38 145.46 543.54 w Hide question 9 feedback You will run a Simple Linear Regression Analysis in Excel using the Data Analysis ToolPak. Data -> Data Analysis -> Scroll to Regression Highlight ILE for the Y Input: Highlight DLH for the X Input: Make sure you click on Labels and Click OK If done correctly then you look under the Coefficients for the values to write out the Regression Equation Coefficients Intercept 171.7566705 DLH(X) 9.317247081 ILE = 171.7567 + 9.3172(DLH) Plug in 40 for DLH ILE = 171.7567 + 9.3172(40)
