Case Analysis

profilemicael14
copy_of_spc_case_analysis_dataset.xlsx
Home>Business & Finance homework help>Case Analysis

Sheet1

n= 5 Morning
Samples of size 5 were taken to find X-bar Afternoon
Night
Sample # Time Average (X-bar) Smallest Largest
1 6:00 AM 49.6 48.7 50.7
2 7 50.2 49.1 51.2
3 8 50.6 49.6 51.4
4 9 50.8 50.2 51.8
5 10 49.9 49.2 52.3
6 11 50.3 48.6 51.7
7 12 Noon 48.6 46.2 50.4
8 1:00 PM 49 46.4 50
9 2 49 46 50.6
10 3 49.8 48.2 50.8
11 4 50.3 49.2 52.7
12 5 51.4 50 55.3
13 6 51.6 49.2 54.7
14 7 51.8 50 55.6
15 8 51 48.6 53.2
16 9 50.5 49.4 52.4
17 10 49.2 46.1 50.7
18 11 49 46.3 50.8
19 12 Mid Night 48.4 45.4 50.2
20 1:00 AM 47.6 44.3 49.7
21 2 47.4 44.1 49.6
22 3 48.2 45.2 49
23 4 48 45.5 49.1
24 5 48.4 47.1 49.6
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 48.4 47.2 51.7
35 4 47.2 45.3 50.9
36 5 46.8 44.1 49
37 6 46.8 41 51.2
38 7 50 46.2 51.7
39 8 47.4 44 48.7
40 9 47 44.2 48.9
41 10 47.2 46.6 50.2
42 11 48.6 47 50
43 12 Midnight 49.8 48.2 50.4
44 1:00 AM 49.6 48.4 51.7
45 2 50 49 52.2
46 3 50 49.2 50
47 4 47.2 46.3 50.5
48 5 47 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 47.8 45.2 51.2
61 6 46.4 44 49.7
62 7 46.4 44.4 50
63 8 47.2 46.6 48.9
64 9 48.4 47.2 49.5
65 10 49.2 48.1 50.7
66 11 48.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 49.6 49 50.6
71 4 51 50.5 51.5
72 5 50.5 50 51.9