Using the attached data, calculate the upper controllimit for the R chart H 5- = FILE HOME INSERT PAGE LAYOUT FORMULAS DATA SPC Charts and Capability - Excel REVIEW VIEW A Microsoft account A R S U v w X Y Z AA AB AC Ruler Formula Bar Split View Side by Side PL Normal Page Break Page Custom Gridlines Headings Hide FB Synchronous Scrolling Zoom 100% Zoom to New Arrange Freeze Unhide eReset Window Position Windows Switch Macros Preview Layout Views Selection Window All Panes Workbook Views Show Zoom Window Macros 118 IX fx A B D E E F G H K M N o 1 Xbar and R Chart Initial Control Chart (Used for Determining Initial Control Limits) 2. 3 4 Sample 7.00 8.00 9.00 10.00 11.00 12.00 13.00 14.00 15.00 18.00 17.00 18.00 19.00 20.00 5 1 34.5900 35.3000 35.45 35.28 35.48 34.59 35.47 35.41 34.88 35.01 34.55 35.2 34.72 34.84 6 2 35.1300 34.6500 34.90 3477 35.39 34.59 34.61 34.67 34.68 34.91 34.6 34.71 35.37 34.56 7 3 35 3100 34 8400 3505 3523 34.52 3524 351 35 35 3483 3495 3483 34 85 35 35 35 23 3 4 34.8800 35.4600 35.11 34.88 345 3476 35.05 35.38 35 25 34.77 34.92 34 53 34.74 34.68 9 5 350100 35.0400 3527 3497 35.49 3521 34.89 35.41 3546 34.96 35.35 35.23 34.74 10 11 34 9840 35 0580 35 1720 34.9820 34 9820 35 0720 35 0720 34 878035 024035 2440 35 0200 34.9200 34 8500 34.7900 350820 34 8060 12 R 0.7200 0.8100 0.4700 0.6200 0.9900 0.6500 0.8600 0.7400 0.7800 0.2400 0.8000 0.6700 0.6500 0.6700 13 14 15 34 66 16 17 18 19 20 21 22 23 24