Can you please describe what I need to do to complete this? I do not understand how to plot the figures within the spreadsheet or calculate them.

Sample 1 2 3 4 5 Xbar R

1 1.55 1.58 1.64 1.67 1.50 1.588 0.17

2 1.52 1.62 1.71 1.74 1.60

3 1.47 1.57 1.44 1.56 1.42

4 1.67 1.73 1.76 1.64 1.64

5 1.46 1.52 1.60 1.41 1.43

6 1.44 1.50 1.53 1.37 1.41

7 1.55 1.64 1.70 1.53 1.58

8 1.54 1.72 1.66 1.52 1.57

9 1.48 1.60 1.57 1.46 1.51

10 1.43 1.55 1.52 1.43 1.46

11 1.40 1.52 1.56 1.38 1.43

12 1.60 1.44 1.55 1.58 1.49

13 1.48 1.46 1.57 1.60 1.65

14 1.56 1.54 1.65 1.68 1.59

15 1.42 1.39 1.51 1.54 1.45

16 1.70 1.71 1.61 1.73 1.64

17 1.51 1.35 1.37 1.49 1.40

18 1.41 1.32 1.44 1.32 1.35

19 1.69 1.58 1.75 1.60 1.63

20 1.67 1.56 1.79 1.58 1.61

21 1.65 1.57 1.68 1.56 1.59

22 1.52 1.46 1.55 1.45 1.46

23 1.51 1.41 1.54 1.42 1.45

24 1.62 1.51 1.69 1.53 1.56

25 1.57 1.46 1.60 1.47 1.51

1. First plot the data using Excel.

2. Then determine the UCL and LCL. Do any of the data points need to be thrown out? If so, then recalculate the UCL and LCL.

3. Then you begin to plot results on this chart. Here are the next 6 samples of data (sample size = 5).

Sample # 1 2 3 4 5 Xbar

26 1.51 1.35 1.37 1.49 1.40

27 1.41 1.32 1.44 1.32 1.35

28 1.69 1.58 1.72 1.60 1.63

29 1.67 1.56 1.70 1.58 1.61

30 1.65 1.57 1.68 1.56 1.59

31 1.52 1.46 1.55 1.45 1.46

Plot these on the control chart.

4. Is the process in control?

Please explain in depth how to plot and calculate so that I can apply to future assignments.