Construct X Bar and R Charts

profilenataligurencxfries
battery_tqm1.xlsx

Battery - Raw Data

Hour Sample Taken Observations
1 2 3 4 5 r x-bar
1 51 50 49 50 50 50
2 45 47 70 46 36 53
3 50 35 48 39 47 42.5
4 55 70 50 30 51 50
5 49 38 64 36 47 50
6 59 62 40 54 64 52
7 36 33 49 48 56 44.5
8 50 67 53 43 40 53.5
9 44 52 46 47 44 48
10 70 45 50 47 41 55.5
11 57 54 62 45 36
12 56 54 47 42 62
13 40 70 58 45 44
14 52 58 40 52 46
15 57 42 52 58 59
16 62 49 42 33 55
17 40 39 49 59 48
18 64 50 42 57 50
19 58 53 52 48 50
20 60 50 51 41 50
21 52 47 48 58 40
22 55 40 56 49 45
23 47 48 50 50 48
24 50 50 49 51 51
25 51 50 51 51 62
Hour Sample Taken Observations
1 2 3 4 5
26 48 52 39 57 61
27 45 53 48 46 66
28 63 49 50 45 53
29 57 70 45 52 61
30 45 38 46 54 52