Show work in excel

2. (10 Points) Create a number nonconforming NP chart for the provided data. Show your calculations for the centerline and the control limits. Graph the results. What does this chart tell us? No need to correct or revise this chart. n Subgroup 1 2 3 4 12 15 88479 10 16 56789 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 100 14 10 5 6 17 12 22 10 11 12 13 14 15 16 17 18 19 20 21 10 || o 13 12 20 18 24 15 22 23 24 25 8