Assignment-Mean and Range

The data below are X and R values for 13 samples/patches of n=3. They were taken from a process producing Precision turbos. Set up the Mean and R charts on this process. Does the process seem to be in control? Why or why not? A.025=.668/A.001=1.054; D.025=2.17 D.001=2.98. The best way to construct the charts is through Excel, you will have to figure out how to draw your warning and action limits. Hint: the insert tab, shapes is a good tool.

Subgroup Number	X	X	X	Mean X	Range
1	12	11	65
2	45	12	61
3	40	25	49
4	25	5	26
5	50	21	75
6	61	27	60
7	50	17	52
8	85	22	59
9	15	13	51
10	12	10	20
11	65	20	73
12	55	24	85
13	74	54	75