Only need question D-F answered. please use excel and show formulas and setup for the charts and please complete the table 6. Thanks

Inventory Specialists, Inc. provides inventory verification services for the grocery store industry. Each week they physically count the inventory of each of the products their customers carry and check the numbers against what the customer's automated inventory tracking system indicates is being held in inventory. Table 5 below provides the number of products for which their was a discrepancy between the physical count and the amount provided by the inventory tracking system of Customer X over the last year. The company would like to determine whether Customer X's automated inventory tracking process is in control or experiencing an excessive level of non-random variation as it pertains to the count discrepancies. Use the data provided in Table S to answer the following questions. Carry calculations out to at least 3 decimal places. A. What is type of control chart(s) should be constructed based on the data provided (.e.. c. p, X-bar, and/or R)? (2) B. What is the central limit for this data? (2) C. What are the 3-sigma upper and lower control limits? Show your calculations. (2) D. Construct the control chart showing not only the control limits but also the zone lines for the Pattern Test discussed in class. Label the zones on the chart and identify the value of the top and bottom borders of each zone by completing the Zone Information Table below (Table 6). Note: The control chart may be created in Excel but a copy of it should be embedded as a picture in your test document. Make sure it is large enough to read all elements. (6) E. State whether the process appears to be in control. Justify your answer. (3) F. List all of the patterns associated with the Pattern Test discussed in class and identify if any Pattern Test violations found. If any Pattern Test violations are found, identify which points fit the pattern. (5) Table 5: Sample process data Week # of Errors Week # of Errors Week # of Errors Week # of Errors 1 2 3 4 5 6 7 8 9 10 11 12 13 28 28 33 30 31 33 34 35 33 33 27 31 33 14 15 16 17 18 19 20 21 22 23 24 25 26 25 24 30 31 33 29 25 29 20 27 36 27 28 29 30 31 32 33 34 35 36 37 41 29 30 26 41 36 27 30 32 32 34 26 36 40 41 42 43 44 45 46 47 48 49 50 51 52 32 27 31 29 24 22 25 26 30 32 29 38 34 32 38 44 39 Table 6: Zone information table ZONE INFORMATION TABLE Zone Top border Bottom border Zone Top border C bottom B top B bottom C top A bottom Bottom border A top