Applies concepts from the Analyze phase of a Lean Six Sigma project. It again uses data from
Question:
Applies concepts from the Analyze phase of a Lean Six Sigma project. It again uses data from the first Cannabis Oil Data spreadsheet and from the Background Information document. The spreadsheet shows the milligrams of CBD in capsules from the east and west sites. You next need to determine whether the differences were due to actual differences between the processes, rather than to the randomness of the sampling procedure (i.e., were the capsules you chose just "lucky")
1. Perform a statistical test to assess the accuracy of the west process only. That is, do 1-sample t-test to compare the mean CBD of the west process to the design target for the product. Do test by hand. You can use the Excel functions "tinv()" or "t.inv.2t()" to get the critical value and "tdist()" or "t.dist.2t()" to get the p. Does the output match the target?
East | west | |
MEAN | 20.76711567 | 20.21979814 |
S.D | 1.05724 | 0.805876782 |
CBD in North and South samples | ||||
CBD measured in mg per capsule | ||||
East | West | |||
Capsule # | CBD | Capsule # | CBD | |
1 | 19.53 | 1 | 21.03 | |
2 | 21.75 | 2 | 19.61 | |
3 | 20.74 | 3 | 19.85 | |
4 | 20.62 | 4 | 21.40 | |
5 | 22.56 | 5 | 20.62 | |
6 | 20.58 | 6 | 19.47 | |
7 | 20.86 | 7 | 20.98 | |
8 | 20.38 | 8 | 19.35 | |
9 | 20.22 | 9 | 20.28 | |
10 | 21.51 | 10 | 19.82 | |
11 | 20.32 | 11 | 21.59 | |
12 | 20.61 | 12 | 20.15 | |
13 | 21.41 | 13 | 19.46 | |
14 | 20.95 | 14 | 21.41 | |
15 | 21.20 | 15 | 18.62 | |
16 | 20.64 | 16 | 18.93 | |
17 | 21.35 | 17 | 20.36 | |
18 | 20.05 | 18 | 19.96 | |
19 | 21.67 | 19 | 20.59 | |
20 | 19.61 | 20 | 19.20 | |
21 | 20.84 | 21 | 19.73 | |
22 | 21.20 | 22 | 20.38 | |
23 | 22.44 | 23 | 20.56 | |
24 | 20.35 | 24 | 19.02 | |
25 | 20.78 | 25 | 19.57 | |
26 | 20.43 | 26 | 20.51 | |
27 | 20.04 | 27 | 20.44 | |
28 | 19.31 | 28 | 21.44 | |
29 | 20.16 | 29 | 21.27 | |
30 | 18.93 | 30 | 19.92 | |
31 | 20.42 | 31 | 20.48 | |
32 | 19.13 | 32 | 19.97 | |
33 | 23.01 | 33 | 20.20 | |
34 | 20.14 | 34 | 20.54 | |
35 | 19.22 | 35 | 21.24 | |
36 | 19.21 | 36 | 21.32 | |
37 | 21.27 | 37 | 18.61 | |
38 | 21.88 | 38 | 20.57 | |
39 | 21.82 | 39 | 21.38 | |
40 | 22.99 | 40 | 21.38 | |
41 | 22.01 | 41 | 18.86 | |
42 | 22.20 | 42 | 19.68 | |
43 | 19.40 | 43 | 20.03 | |
44 | 20.38 | 44 | 19.67 | |
45 | 21.17 | 45 | 20.31 | |
46 | 22.11 | 46 | 19.40 | |
47 | 19.89 | 47 | 20.08 | |
48 | 21.41 | 48 | 21.19 | |
49 | 18.91 | 49 | 20.35 | |
50 | 22.06 | 50 | 21.00 |