MGT 3302 DUE on Thursday Nov 22 at 10 pm

sidibef1
SPC-DatasetFall2018updated.xlsx

Sheet1

MGT 3332 SPC Project Dataset Fall 2018
Morning
Samples of size 5 were taken to find X-bar Afternoon
Night
Sample # Time Average (X-bar) Smallest Largest Range
1 6:00 AM 25.35 24.9 25.7
2 7 25.55 25.3 26.2
3 8 25.35 25.1 26.4
4 9 25.65 25.2 26.1
5 10 25.65 25.2 26.3
6 11 25.65 24.9 25.7
7 12 Noon 25.25 24.8 25.3
8 1:00 PM 25.15 24.5 25.4
9 2 24.85 23.9 25.1
10 3 25.25 23.9 25.45
11 4 24.65 24.2 24.8
12 5 24.85 24.4 25.2
13 6 24.95 24.2 25
14 7 24.55 24 25
15 8 25.15 23.6 25.2
16 9 24.95 24.4 25.1
17 10 24.75 24.5 24.8
18 11 24.25 23.9 25.1
19 12 Mid Night 24.05 23.1 24.7
20 1:00 AM 23.85 22.6 24.7
21 2 23.95 22.7 24.6
22 3 24.05 22.8 24.7
23 4 23.65 22.5 24.1
24 5 24.25 22.1 24.6
25 6 25.15 24.6 25.4
26 7 25.35 24.2 25.5
27 8 25.15 24 25.5
28 9 25.15 24.4 25.7
29 10 25.25 24.6 25.8
30 11 25.35 24 25.6
31 12 Noon 25.35 23.8 25.4
32 1:00 PM 25.45 24.4 25.7
33 2 24.8 23.6 25.3
34 3 24.35 23.8 24.7
35 4 24.55 23.7 24.8
36 5 24.55 23.9 24.7
37 6 24.65 23.2 25
38 7 24.45 24.1 24.7
39 8 24.35 23.2 24.7
40 9 24.55 24.2 25.1
41 10 24.25 23.6 25.2
42 11 23.95 23.1 25
43 12 Midnight 24.25 23.2 25.1
44 1:00 AM 23.95 23.4 24.7
45 2 23.75 23 25.2
46 3 24.65 23.4 25
47 4 23.55 22.7 24.3
48 5 23.85 22.9 24.5
49 6 25.25 23.8 25.4
50 7 24.95 23.4 25.6
51 8 24.95 23 25.8
52 9 25.35 24.1 25.7
53 10 25.35 24.8 25.4
54 11 25.55 24.5 25.7
55 12 Noon 25.35 23.7 25.9
56 1PM 25.05 23.7 26.2
57 2 24.75 23.4 24.9
58 3 24.85 23.8 25.1
59 4 24.95 24.1 25.6
60 5 24.45 23.9 25.2
61 6 24.55 22.8 24.7
62 7 24.75 23.7 25
63 8 24.55 22.9 24.9
64 9 24.75 22.2 24.9
65 10 24.3 23.1 24.5
66 11 24.05 22 24.2
67 12 Midnight 23.65 22.1 24.2
68 1:00 AM 23.55 22.3 24
69 2 24.15 23.8 25
70 3 23.95 23.1 24.6
71 4 24.05 23.2 24.5
72 5 23.65 22.3 25.1