please send me EXCEL FILES Brawdy Plastics, Inc. produces plastic seat belt retainers forGeneral Motors at their plant in Buffalo, New York. Afterfinal assembly and painting, the parts are placed on aconveyor belt that moves the parts past a final inspectionstation. 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 that increasing the line speedtoo much may not provide enough time for inspectors toidentify which parts are actually defective. To test thistheory, Brawdy Plastics conducted an experiment in whichthe same batch of parts, with a known number of defectiveparts, was inspected using a variety of line speeds. Thefollowing data were collected. If required, enter negativevalues as negative numbers.a. Select a scatter diagram with the line speed as theindependent variable.b. What does the scatter diagram developed in part (a)indicate about the relationship between the two variables?c. Use the least squares method to develop the estimatedregression equation (to 1 decimal). = + x d. Predict thenumber of defective parts found for a line speed of 25 feetper minute.Number of DefectiveLine SpeedParts found20232021301930164015401750145011

Name: please send me EXCEL FILES Brawdy Plastics, Inc. produces plastic seat
Uploaded: 2024-03-20T07:07:26.000Z
Channel: Bartleby
Description: please send me EXCEL FILES Brawdy Plastics, Inc. produces plastic seat belt retainers forGeneral Motors at their plant in Buffalo, New York. Afterfinal assembly and painting, the parts are placed on aconveyor belt that moves the parts past a final in