15 Jun Assignment:You will complete an x-bar and R chart similar to th

Assignment:You will complete an x-bar and R chart similar to the example shown in Chapter 6, figure 6.8, from our textbook “Statistical Process Control and quality Improvement”, starting from the provided Excel template. You will enter the numerical data from the section below, and calculate all of the averages and ranges, then plot these numbers and add the connecting lines, in the appropriate chart sections. You will also calculate and plot the UCLX, LCLX, UCLR, and LCLR.  The control limit formulas are on page 203 of the textbook. Be sure to include your upper and lower control limit calculations below the chart.   1       2        3      4       5       6       7       8       9      10    11    12    13    14    15   16    17    18    19    20    21    22    23    24    25889 897 916 933 912 911 882 885 882 908 909 893 884 912 895 890 917 926 901 903 909 896 895 892 908915 904 890 897 896 898 894 892 913 895 907 906 889 909 902 940 917 903 892 930 904 912 920 912 920905 916 891 885 932 900 941 942 930 896 904 917 912 913 902 895 918 908 892 890 906 907 922 895 896902 912 920 900 936 905 934 911 900 925 923 910 919 915 932 909 914 910 895 890 872 928 928 896 894873 920 915 879 913 862 917 916 871 933 888 925 898 928 932 915 925 885 898 900 927 926 926 902 906Numerical Data:Formatting:Text Size: All of the text in this assignment has been preset to the individual cells.Margins: The margins have been preset in this assignment. If you file doesn’t display correctly, you will need to change the page setup. The top, bottom, and right side are set for ¼’ (0.25) margins. The left margin is set to ½” (0.5”).  The view is set to normal; the page is set to US Legal, landscape, and fit to page.Name Block: Place the name block in the upper left corner of the page, in cells A1 through A3. Put your name first, then the class title, as per the example: