I need to show work please use the numbers given

MGMT 4630 SPC Assignment #2 Process Capability Exercise Objectives: 1) Calculate capability indices and interpret them. 2) Estimate amount of acceptable output from a process. Course Learning Objective: Use a variety of current industry quality tools for measuring and monitoring quality. Using the scenario and data for SPC Assignment 1, determine the capability of the process. Calculate both Cp and Cpk. Based among these, state if the process is capable and your reason for concluding this? Assume that the histogram of the individual measurements is approximately bell-shaped. Estimate the percentage of items that will: 1. Meet the specifications 2. Exceed the upper specification limit 3. Fall below the lower specification limit Instructions Submit a very neatly prepared page of handwritten calculations. You may NOT use Excel (or similar software). Round all calculations to three (3) decimal places. For example, show Cp and Cpk as 1.234 Note: You may show percentages to two decimal places, e.g., as 5.64%. Data Day 2 Bag 3 X-ber R R Subgroup Bag 1 99.6 Bag 4 100.5 98.4 100.0 100.4 99.2 2 99.1 99,2 3 E 993 98.5 98.9 99.1 044 98.4 4 S 97.6 99.7 99.4 99.5 98.6 9 98.8 98.2 98.4 98.50 0.60 7 99.8 99.58 1.40 99.0 2. 98.7 100.4 www. 98.8 8 99.1 98.5 98.78 98.90 9 995 S 99.1 99.8 982 1.4 10 99.5 99.1 99.4 1.90 11 99,2 101.0 100.1 99.2 1002 99.75 99.85 99.15 0. 12 98.8 99.4 0.60 13 99.6 99.9 98.2 1003 99.50 2.10 14 99.5 100.1 99.9 98.7 99.55 1.40 15 98.1 99.4 99.3 99.6 99.10 1.50 16 188 10X1.1 100.0 107 1.30 17 993 99.1 98.2 98.7 98.83 1.10 18 99.5 98.2 99.6 97.4 98.6 2.20 19 99.4 99.0 99.2 98.7 99.08 0.70 20 100.0 99.2 98.7 1000 99.18 1.9 21 10X1.4 99,0 166 1.40 992 985 22 999 186 905 99 SKN ! 1 400 . 1.10 99.1 100.0 98.9 99.33 23 24 99.9 100.0 98.9 90.9 99.5 99.13 25 98.2 99.2 99.9 99.6 99.23 1.70 (Bag weights are reported in grams) MGMT 4630 SPC Assignment #2 Process Capability Exercise Objectives: 1) Calculate capability indices and interpret them. 2) Estimate amount of acceptable output from a process. Course Learning Objective: Use a variety of current industry quality tools for measuring and monitoring quality. Using the scenario and data for SPC Assignment 1, determine the capability of the process. Calculate both Cp and Cpk. Based among these, state if the process is capable and your reason for concluding this? Assume that the histogram of the individual measurements is approximately bell-shaped. Estimate the percentage of items that will: 1. Meet the specifications 2. Exceed the upper specification limit 3. Fall below the lower specification limit Instructions Submit a very neatly prepared page of handwritten calculations. You may NOT use Excel (or similar software). Round all calculations to three (3) decimal places. For example, show Cp and Cpk as 1.234 Note: You may show percentages to two decimal places, e.g., as 5.64%. Data Day 2 Bag 3 X-ber R R Subgroup Bag 1 99.6 Bag 4 100.5 98.4 100.0 100.4 99.2 2 99.1 99,2 3 E 993 98.5 98.9 99.1 044 98.4 4 S 97.6 99.7 99.4 99.5 98.6 9 98.8 98.2 98.4 98.50 0.60 7 99.8 99.58 1.40 99.0 2. 98.7 100.4 www. 98.8 8 99.1 98.5 98.78 98.90 9 995 S 99.1 99.8 982 1.4 10 99.5 99.1 99.4 1.90 11 99,2 101.0 100.1 99.2 1002 99.75 99.85 99.15 0. 12 98.8 99.4 0.60 13 99.6 99.9 98.2 1003 99.50 2.10 14 99.5 100.1 99.9 98.7 99.55 1.40 15 98.1 99.4 99.3 99.6 99.10 1.50 16 188 10X1.1 100.0 107 1.30 17 993 99.1 98.2 98.7 98.83 1.10 18 99.5 98.2 99.6 97.4 98.6 2.20 19 99.4 99.0 99.2 98.7 99.08 0.70 20 100.0 99.2 98.7 1000 99.18 1.9 21 10X1.4 99,0 166 1.40 992 985 22 999 186 905 99 SKN ! 1 400 . 1.10 99.1 100.0 98.9 99.33 23 24 99.9 100.0 98.9 90.9 99.5 99.13 25 98.2 99.2 99.9 99.6 99.23 1.70 (Bag weights are reported in grams)