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:
891 |
||||||||||||||||||||||||||||||||||
933 |
911 |
889 |
882 |
903 |
890 |
892 |
908 |
895 |
916 |
901 |
909 |
|||||||||||||||||||||||
897 |
898 |
915 |
913 |
930 |
940 |
912 |
920 |
928 |
904 |
902 |
||||||||||||||||||||||||
885 |
900 |
905 |
896 |
922 |
918 |
906 |
||||||||||||||||||||||||||||
894 |
925 |
872 |
932 |
|||||||||||||||||||||||||||||||
879 |
862 |
873 |
871 |
926 |
893 |
927 |
917 |
884 |
|||||
907 |
||||||
942 |
941 |
|||||
910 |
923 |
936 |
934 |
914 |
919 |
|
888 |
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:
Your Name
TECH 458 Quality Assurance
May 6, 2013
>Asgnmt Number
1 2 >Asgnmt Number
1 2 4 5 8 9 2
895 896 918 908 917 926 896 912 912 882 890 885 908 895 896 916 917 905 895 900 890 910 6
909 896 885 897 908 895 910 900 914 873 900 925 885 926 913 917 909 896 911 912 928 925 915 915 892 913 930 917 889 903 912 909 896 894 912 892 904 920 920 907 890 897 917 894 897 915 899 903 918 900 906 917 915 919 914 911 898 903 905 905 912 911 906 906 904 898 42 89 40 11 41 49 19 59 20 19 26 33 29 35 30 93 0 >Asgnmt Number
1 2 1
Sample
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
Sample
Measurements
Average
Range
Chart of Averages
Chart of Ranges
UCLX=
LCLX=
UCLR=
LCLR=
1
Ahmad Binali
TECH
4
5
8
5-May-
0
9
Sample
3
6
7
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
873
900
905
89
896
9
30
890
918
912
908
907
913
9
40
9
41
895
9
42
916
922
917
904
891
885
Sample
9
26
911
889
901
882
903
884
892
897
909
9
60
Measurements
910
902
925
914
919
945
915
93
934
923
920
885
862
995
9
33
871
898
928
894
888
879
825
903
893
985
951
906
Average
899
9
29
Range
53
49
103
59
35
44
61
57
81
940
932
——————————————————————————————————————
Chart of Averages
924
916
908
̿̅
900
892
884
876
Chart of Ranges
100
80
60
40
20
UCLX = 907.496 + (0.577 x 47.08)
907.5 +27.2
934.7
LCLX = 907.496 – (0.577 x 47.08)
907.5 – 27.2
880.3
UCLR=
2.114 x 47.08
99.5
LCLR=
0.47.08
1
Sample
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
Sample
Measurements
Average
Range
Chart of Averages
Chart of Ranges
UCLX=
LCLX=
UCLR=
LCLR=