kindly show how to input the values in Excel

D B 1 Data for nonconforming cables Sample # Number of nonconforming Cables 2 3 4 E H Assignment 3 Problem The number of nonconforming cables is found for 20 samples of size 100 and is shown in the table given on the left. (a) Construct a control chart for the proportion of nonconforming cables. Revise the control limits, assuming special causes for points outside the contol limits. (b) The desired standart for the nonconformance rate is set by the management at 3%, so establish controllimits based on this standard. Comment on the ability of the process to meet this standard. If the management were to setnthe standard at 2%, can the existing process meet this goal? What actions would you recomment. 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 2 5 4 3 4 2 3 2 4 11 5 4 2 5 3 12 3 2 5 2 22 28 24 25 26 27 28 29 A 1 Data for nonconforming cables Sample # Number of nonconforming Cables 2 3 1 4 2 3 4 5 6 7 8 5 6 7 8 9 Assignment 3 Problem The number of nonconforming cables is found for 20 samples of size 100 and is shown in the table given on the left. (a) Construct a control chart for the proportion of nonconforming cables. Revise the control limits, assuming special causes for points outside the contol limits. (b) The desired standart for the nonconformance rate is set by the management at 3%, so establish control limits based on this standard. Comment on the ability of the process to meet this standard. If the management were to setnthe standard at 2%, can the existing process meet this goal? What actions would you recomment. 2 5 4 3 4 2 3 2 4 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 10 11 12 13 14 15 16 17 18 19 20 11 5 4 2 5 3 12 3 NON