123

Using the attached data, calculate the lower control limit for the Xbar chart. KH 5 - SPC Charts and Capability - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW w Ruler Formula Bar Gridlines Headings 3 Split I View Side by Side Ee Hide DI Synchronous Scrolling Zoom 100% Zoom to New Arrange Freeze Selection Window All Panes Unhide Reset Window Position Zoom Window Normal Page Break Page Custom Preview Layout Views Workbook Views Macros Switch Windows Show Macros D E F G H j L M N 118 IX fx A B 1 Xbar and R Chart 2 O Q R S T U V w X Y Z Initial Control Chart (Used for Determining Initial Control Limits) 3 4 7:00 8:00 9:00 11:00 14.00 16.00 5 35.46 35.39 6 7 7 Sample 1 2 3 4 5 34.5900 35.3000 35.1300 34.6500 35.3100 34.8400 34 8800 35.4600 35 0100 350400 35.45 34.98 35 05 35.11 35 27 10:00 35.28 34.77 35 23 34.66 3497 12.00 34.59 34.59 35.24 34.76 3521 13:00 35.47 34.61 35.1 35 05 3489 15.00 34.88 34.68 34 83 3525 35.46 35.41 34.67 35.35 3538 35.41 17.00 34.55 34.6 34.83 34 92 35 35 35.01 34.91 34.95 34.77 3496 18:00 35.2 34.71 34.85 3453 34 66 19:00 34.72 35.37 35.35 34.74 35 23 3452 345 20:00 34 84 34.56 35 23 3468 34.74 8 35 49 9. 10 X R 34.9840 35 0580 35.1720 34 9820 35.0720 0.7200 0.8100 0.4700 0.6200 0.9900 34.8780 35.0240 35.2440 35.0200 34.9200 34.8500 34.7900 35.082034.8060 0.6500 0.8600 0.7400 0.78000.2400 0.8000 0.6700 0.6500 11 12 13 14 0.6700