Chapter 14 1. In a manufacturing process the assembly line speed (feet per minute) was thought to affect the number of defective parts found during the impaction process. To test this theory, managers devised a situation in which the same batch of parts was inspected visually at a variety of line speeds. They collected the following data. Line Speed (x) Number of Defective Parts Found (y) 20 21 20 19 40 15 30 16 60 14 40 17 Use Microsoft Excel to generate regression output for this problem and use the information in the output to answer the following questions. a. Develop the estimated regression equation that relates line speed to the number of defective parts found. b. What is the number of defective parts found when the line speed is 45 feet per minute? c. Compute the coefficient of determination. Did the estimated regression equation provide a good fit to the data? d. Compute the sample correlation coefficient between the number of defective parts found and the line speed. e. Is the relationship between speed and parts defective significant? Use a = 0.05