A Quiz 10 - 202101 QMTD 2750: X +A webassign.net/web/Student/Assignment-Respons... Q ☆h.Apps* Bookmarks oait DECALFX.com! U...West End UMC Va...> West End UMC Va...Brawdy Plastics, Inc., produces plastic seat belt retainers for General Motors at the Brawdy Plastics plant in Buffalo, New York. After final assembly andpainting, the parts are placed on a conveyor belt that moves the parts past a final inspection station. How fast the parts move past the final Inspectionstation depends upon the line speed of the conveyor belt (feet per minute). Although faster line speeds are desirable, management is concerned thatincreasing the line speed too much may not provide enough time for inspectors to identify which parts are actually defective. To test this theory, BrawdyPlastics conducted an experiment in which the same batch of parts, with a known number of defective parts, was inspected using a varlety of line speeds.The following data were collected.Number ofLineDefectiveSpeedParts Found20242020302030164014401650145012(a) Develop a scatter diagram with the line speed as the independent variable.2525202015-151010102030405060102030405060Line Speed (feet per minute)Line Speed (feet per minute)25252020151510105-102030405060102030405060Line Speed ifeet per minute)Line Speed (feet per minute)NOVétvMacBookNumber of Defective PartsNumber of Defective PartsNumber of Defective PartsNumber of Defective Parts -Respons...Q ☆* BookmarksDELALppsEX DECALFX.com! U..West End UMC Va...West End UMC Va...4014401650145012(a) Develop a scatter diagram with the line speed as the independent variable.2525202015:151010102030405060102030405060Line Speed (feet per minute)Line Speed (feet per minute)2525202015151010102030405060102030405060Line Speed (feet per minute)Line Speed (feet per minute)(b) What does the scatter diagram developed in part (a) indicate about the relationship between the two variables?O There appears to be a positive relationship between line speed (feet per minute) and the number of defective parts.O There appears to be no noticeable relationship between line speed (feet per minute) and the number of defective parts.O There appears to be a negative relationship between line speed (feet per minute) and the number of defective parts.(c) Use the least squares method to develop the estimated regression equation.(d) Predict the number of defective parts found for a line speed of 25 feet per minute.NOVtwNumber of Defective PartsNumber of Defective PartsNumber of Defective PartsNumber of Defective Parts

a) In this case Line Speed is the independent variable and Number of Defective Parts Found is the dependent variable.Enter the data in Excel. Software procedure: Step-by-step procedure to obtain the scatterplot using EXCEL is defined as follows: Open an EXCEL file. In Excel sheet, enter Line Speed and Number of Defective Parts Found, in columns A and B, respectively. Select the data, choose Insert > Scatter. Output obtained using Excel is given below: The correct scatterplot is the last one.b) The direct of the scatter plot is downward. There appears to be a negative relationship between the line speed (feet per minute) and the number of defective parts.c) Step-by-step software procedure to obtain regression equation using EXCEL is defined as follows: Open an EXCEL file. In Excel sheet, enter Line Speed and Number of Defective Parts Found, in columns A and B, respectively. In Data, select Data Analysis and choose Regression. In Input Y Range, select $B$1:$B$9. In Input X Range, select $A$1:$A$9. Select Labels. Click OK. Output obtained using Excel is given below: The regression equation is, Number of Defective Parts Found = 27.5 – 0.3 Line Speed.d) Substitute Line Speed = 25 in the regression equation. That is, Number of Defective Parts Found = 27.5 – 0.3(25) = 20. Thus, the predicted number of defective parts found for a line speed of 25 feet per minute is 20.