SPC Project

Bankme
SPCCaseAnalysisDataset.xlsx

Sheet1

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