SPC CASE ANALYSIS: AMERICO DRILLING SUPPLIES

profiletutor4helpyou
data.xlsx
Home>Mathematics homework help>Numerical analysis homework help>SPC CASE ANALYSIS: AMERICO DRILLING SUPPLIES

Sheet1

n= 6 Morning
Samples of size 6 were taken to find X-bar Afternoon
Night
Sample # Time Average (X-bar) Smallest Largest Sample # Morning Afternoon Night
1 6:00 AM 49.6 48.7 50.7 1 49.6 49 48.2
2 7 50.2 49.1 51.2 2 50.2 49.8 48.5
3 8 50.6 49.6 51.4 3 50.6 50.3 47.4
4 9 50.8 50.2 51.8 4 50.8 51.4 47.6
5 10 49.9 49.2 52.3 5 49.9 51.6 47.4
6 11 50.3 48.6 51.7 6 50.3 51.8 47.2
7 12 Noon 49.6 46.2 50.4 7 49.6 51 47.5
8 1:00 PM 49.8 46.4 50 8 49.8 50.5 48.4
9 2 49 46 50.6 9 48.6 49.7 49.2
10 3 49.8 48.2 50.8 10 50 49.4 48.6
11 4 50.3 49.2 52.7 11 49.8 49.2 49.1
12 5 51.4 50 55.3 12 50.3 48.8 48.6
13 6 51.6 49.2 54.7 13 50.2 48.8 49.4
14 7 51.8 50 55.6 14 50 50 48.5
15 8 51 48.6 53.2 15 50 48.4 47.2
16 9 50.5 49.4 52.4 16 50.1 49.2 46.2
17 10 48.2 46.1 49.7 17 48.4 49.8 49.2
18 11 48.5 46.3 50.8 18 48.8 49.8 47.4
19 12 Mid Night 47.4 45.4 50.2 19 49.6 50 47.2
20 1:00 AM 47.6 44.3 49.7 20 50 48.8 47.4
21 2 47.4 44.1 49.6 21 51 49.4 48.8
22 3 47.2 45.2 49 22 50.4 49.4 45.3
23 4 47.5 45.5 49.1 23 50 48.2 47.5
24 5 48.4 47.1 49.6 24 48.9 49.4 47.8
25 6 48.6 47.4 52
26 7 50 49.2 52.2
27 8 49.8 49 52.4
28 9 50.3 49.4 51.7
29 10 50.2 49.6 51.8
30 11 50 49 52.3
31 12 Noon 50 48.8 52.4
32 1:00 PM 50.1 49.4 53.6
33 2 49.7 48.6 51
34 3 49.4 47.2 51.7
35 4 49.2 45.3 50.9
36 5 48.8 44.1 49
37 6 48.8 41 51.2
38 7 50 46.2 51.7
39 8 48.4 44 48.7
40 9 49.2 44.2 48.9
41 10 49.2 46.6 50.2
42 11 48.6 47 50
43 12 Midnight 49.1 48.2 50.4
44 1:00 AM 48.6 48.4 51.7
45 2 49.4 49 52.2
46 3 48.5 49.2 50
47 4 47.2 46.3 50.5
48 5 46.2 44.1 49.7
49 6 48.4 45 49
50 7 48.8 44.8 49.7
51 8 49.6 48 51.8
52 9 50 48.1 52.7
53 10 51 48.1 55.2
54 11 50.4 49.5 54.1
55 12 Noon 50 48.7 50.9
56 1PM 48.9 47.6 51.2
57 2 49.8 48.4 51
58 3 49.8 48.8 50.8
59 4 50 49.1 50.6
60 5 48.8 45.2 51.2
61 6 49.4 44 49.7
62 7 49.4 44.4 50
63 8 48.2 46.6 48.9
64 9 49.4 47.2 49.5
65 10 49.2 48.1 50.7
66 11 47.4 47 50.8
67 12 Midnight 47.2 46.4 49.2
68 1:00 AM 47.4 46.8 49
69 2 48.8 47.2 51.4
70 3 45.3 48.1 50.6
71 4 47.5 48.2 51.5
72 5 47.8 47.3 51.9