Use the following description to answer questions. A human resources director at an assembly plant wants to predict the performance of work inspectors on an assembly line. She develops a visual search test (x-variable) that requires the examinee to identify target letters in a mass of letters and numbers on a computer screen. The score is the number of assembly errors made on 20 screens (y-variable). The assembly line performance requires the inspectors to reject an assembly if it has a broken connection. An error is counted if the assembly gets by the inspector before he or she can see the faulty part and push a reject switch. The following descriptive statistics were obtained: .- __ _I- __ _5- I11 .. M u -u 5. Use the 'Regression' function in Excel to obtain the following values: (A) What is the value of the slope for the regression equation when predicting errors from search test? The value for the slope in the regression equation when predicting errors was - 0.7241. (B) Obtain the value of the y-intercept. The value of the y-intercept was 14. (C) Provide an interpretation of the y-intercept obtained in part B. 8. Explain the possible difculties of extrapolation and limited range about line correlation. SUMMARY OUTPUT Regression Statistics Multiple R 0.921995099 R Square 0.850074963 Adjusted R Square 0.831334333 Standard Error 1.098588436 Observations 10 ANOVA of 55 MS F ignificance F Regression 54.74482759 54.74483 45.36 0.000147 Residual 9.655172414 1.206897 Total 64.4 Coefficients Standard Error Stat P-value Lower 95% Upper 95%% lower 95.0: Upper 95.0% Intercept 14 1.294698888 10.81333 4.720828-06 11.01442 16.98558 11.01442 16.98558 X - Search Test -0.724137931 0.10751889 -6.73498 0.000147306 -0.97208 -0.4762 -0.97208 -0.4762 RESIDUAL OUTPUT Observation Predicted Y - Assembly Errors Residuals 6.034482759 0.965517241 7.482758621 1.517241379 3.137931034 -0.137931034 8.931034483 -1.931034483 5.310344828 0.689655172 2.413793103 0.413793103 1.689655172 -0.689655172 6.75862069 -0.75862069 6.034482759 0.965517241 10 8.206896552 -0.206896552