# Siddharth

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. Two versions of the assignment template are provided; 1A is for the newer version of Excel: .xlsx, 1B is compatible for older versions of Excel: .xls. 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.

Numerical Data:

 1 2 3 4 5 6 7 8 9 10 11 12 13 14 933 911 889 882 903 890 892 908 895 916 901 908 909 895 897 898 915 913 930 940 912 920 920 890 892 895 904 902 885 900 905 930 890 895 895 896 922 891 892 896 906 902 900 905 902 900 890 909 896 894 928 920 895 925 872 932 879 862 873 871 900 915 902 906 926 915 898 933 927 932

 15 16 17 18 19 20 21 22 23 24 25 893 909 885 897 912 882 896 912 926 917 884 906 907 892 904 896 894 912 909 903 917 889 917 904 942 916 932 941 907 913 908 918 912 910 923 911 912 936 934 928 915 910 914 919 925 888 916 920 913 917 926 928 885 925 898

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 and then the due date, as per the example: