AutoSave O OFF MAP ?C ... Homework XI - Control Chart.xIsx - Read-Only Home Insert Draw Page Layout Formulas Data Review View Automate Analytic Solver Data Mining _ Tell me Share Comments Calibri (Body) v 11 AA ab Wrap Text v General Insert v Ex Delete v Paste BIU V V Q DVAv Merge & Center v $ ~ % " Conditional Format Cell Sort & Find & Analyze Formatting as Table Styles Format v DV Cloze Question Filter Select Data Builder C52 X fx B G H M N AA AB AC AD AE Item Number Sample 2 Number 12.27 14.71 10.28 10.36 13.39 14.19 13.90 11.19 13.32 10.56 10.41 10.15 10.82 14.15 11.36 12.16 11.10 10.24 14.70 14.24 0.23 14.68 13.28 0. 29 14.47 13.58 14.36 13.71 10.44 12.94 13.35 10.OS 12.77 10.88 12.23 12.95 11.98 14.23 14.29 10.75 12.55 13.98 1.04 11.24 10.99 13 90 13.13 14.63 13 86 12.40 15.78 9.06 13.19 8.05 10.96 13.16 8.54 0.09 16.62 11.77 15 12.08 11.73 6.47 9.12 16.92 5.55 16.83 3.44 12.77 9.87 10.58 10.11 16.44 11.79 13.70 18 11.79 11.99 13.84 10.61 14.94 19 11.93 11.56 11.0 13.28 10.7 20 11.90 11.37 11.68 12.34 14.59 10.80 10.87 10.93 13.80 10.01 14.85 11.54 12.15 13.01 13.54 12.40 14.32 11.73 13.52 10.05 12.85 12.12 14.85 14.91 11.49 25 10.69 13.82 10.47 14.94 14.31 26 14.43 10.32 11.96 10.40 11.63 27 28 Fill all the yellow cells: 29 30 1. Sample Size 31 32 2. X-bar-bar R-bar= 33 34 3. Constant choices: D3 D4 35 36 37 4. Control Limits: LCL-X UCL-X LCL-R UCL-R 38 39 40 Draw the X-bar control chart, specify the LCL and ULC in the chart 41 42 5. Is the process in control? This should be answered according to BOTH the X-bar control chart and R control chart. 43 44 Specification Limits: LSL USL 45 10.5 14 46 47 6. Process Capability Index (Cp) = 48 49 Data Constants + Ready Accessibility: Good to go " - - + 85%AutoSave O OFF Q A E Y . C ... Homework XI - Control Chart.xIsx - Read-Only Home Insert Draw Page Layout Formulas Data Review View Automate Analytic Solver Data Mining Tell me Share Comments Calibri (Body) v 11 AA ab Wrap Text v General Insert v O. Ex Delete v Sort & Find & Analyze Cloze Question Paste BI U V V Q MVAv = = Merge & Center v $ ~ % " Conditional Format Cell Formatting as Table Styles Format DV Filter Select Data Builder E17 fx G H K M N O P Q R F S A B C D E Sample size A2 D3 D4 d2 1.8 3.268 1.128 - W N 1.023 2.574 1.693 o o o O 0.729 2.282 2.059 0.577 2.115 2.326 CO V O UT A W N 0.483 2.004 2.534 0.419 .076 1.924 2.704 0.373 0.136 1.864 2.847 9 0.337 0.184 1.816 2.97 10 10 .308 .223 1.777 3.078 11 11 0.285 .256 1.744 12 12 0.266 0.284 1.716 13 13 0.249 0.308 1.692 14 14 0.235 0.329 1.671 15 15 0.223 0.348 1.652 16 16 0.212 0.364 1.636 17 17 0.203 0.379 1.621 18 18 0.194 0.392 L.608 19 19 0.187 0.404 1.596 20 20 .18 0.414 1.586 21 21 0.173 0.425 1.575 22 22 0.167 0.434 1.566 23 23 0.162 0.443 1.557 24 24 0.157 ).452 1.548 25 25 0.153 0.459 1.541 26 27 28 29 30 31 32 Data Constants + + 139% Ready Accessibility: Good to go