MBA 5008-Gnyxl, LLC would like to determine if the
It’s recommended that you use Excel to solve this problem). Gnyxl, LLC would like to determine if the speed at which the firm’s assembly lines are moving or the shift being worked have an effect on the number of defective parts found during final inspection. To determine if this is so, the production line speed has been varied and the number of defective parts were recorded. The results are given in the table below (the extra columns and rows are provided for your convenience – as they may help with calculations).Line Speed (Feet Per Minute)ShiftNumber of Defectives Detected2012120219402153011660314402174512250372538301153523240318502204031030118(10) Develop a regression equation that relates the line speed to the number of defective parts found.b. (15) What conclusions can you draw based on the results of the analysis (e.g., interprert r, R2, etc.)c. (15) Do any of the model’s assumptions appear to be violated? If so, which ones, and how do you know?
