AutoSave Off ENGR 222 WALKING BY (NAM... File Home Insert Draw Page Layout Formulas Data 1010 % Conditional Formatting Format as Table Paste Font Alignment Number Cell Styles Kevin Mendez Review View Help 1 13 X B D a 4 Cells Editing Ideas Sensitivity Ideas Sensitivity Clipboard G G26 Styles 4 E > Sx A C D G Н 1 DAY LAP 1 LAP 2 LAP3 LAP 4 LAPS 3 2 1 60.87 59.9 61.82 64.98 65.21 3 2 62.42 63.06 57,45 59.14 60.71 4 3 57.33 55.58 58.71 64.71 65.82 5 4 59.78 62.14 63.59 63.23 65.26 6 5 57.68 58.48 59.59 59.83 62.85 7 6 60.24 59.74 59:43 61.39 60.98 8 7 57.89 58.81 61.04 61.52 61.02 9 8 61.64 59.62 58.76 60.68 58.46 10 9 57.79 61.95 59.47 60.67 57.87 11 10 57.11 60.4 61.96 62.58 60.76 12 11 61.77 57.38 57.92 58.03 59.66 13 12 60.64 62.77 61.82 59.33 58.11 14 13 57.31 59.69 60.62 61.55 60.93 15 14 62.29 58.89 57.41 62.45 59.48 16 15 62.83 61.17 59.01 61.07 60.73 17 16 57.46 60.98 58.29 57.44 58.78 18 17 59.54 59.3 62.88 62.75 61.96 19 18 60.46 . 62.79 58.56 61.47 59.76 20 19 61.32 62.39 60.59 62.25 58.87 21 22 22 201 57.85 60.1 60.86 57.37 60.12 21 60.88 58.31 58.9 58.65 59.47 23 24 23 25 26 222 A 57.25 57.06 57.46 61.79 62.16 61.26 57.61 61.04 60.85 62.09 24 59.51 60.25 57.15 59.04 59.28 25 59.45 60.22 6142 58.57 59.77 Sheet1 + 3 Ready M с 70% Use WALKING data values to: 6. Create R and X-bar-bar charts. 7. Calculate the R(bar) and X(double bar) center lines, standard deviations, UCLS and LCLs to confirm the chart values. 8. Creates and X-bar-bar charts. 9. Calculate the s(bar) and X(double bar) center lines, standard deviations, UCLS and LCLs to confirm the chart values. Show variables used in formulas. 10. Compare the charts in step 6 and 8.