Create the Microsoft Excel file that contains x bar chart and R bar chart.
The Company A produces high-tech bicycles. They have had trouble with a particular round component. Samples of size five were taken during four successive days. The results are in the following table. Using Microsoft Excel, create process mean chart and process variation chart to check whether the process is stable.
|
|
Day 1
|
Day 2
|
Day 3
|
Day 4
|
|
Sample 1
|
110.102
|
107.6015
|
110.0986
|
101.9892
|
|
Sample 2
|
96.33667
|
98.87803
|
105.0386
|
109.7321
|
|
Sample 3
|
104.2647
|
122.2084
|
96.30126
|
81.33958
|
|
Sample 4
|
77.82035
|
110.2074
|
100.9358
|
84.28689
|
|
Sample 5
|
116.6838
|
92.03423
|
113.4339
|
95.73624
|
Also, see the following table (Table for factors for control limits).
|
Number of observations in subgroup
|
Factors for process mean chart (A2)
|
Factors for process variation chart
upper control limit (D4)
|
|
3
|
1.023
|
2.574
|
|
4
|
0.729
|
2.282
|
|
5
|
0.577
|
2.114
|