A factory is making scented candles. Every day a sample of 6 candles is taken from the production process and their weight (in grams) is measured. Over the last 30 days, the measurements were taken and the data is in this Excel file: Data for Homework Quality S23.xlsx Generate the X-bar and R control charts for this process.

 

Transcribed Image Text:

Item Number Sample Number 1 2 3 4 5 6 123 + 1 95.66 46.10 97.10 95.65 68.54 87.87 107.78 94.75 87.49 92.18 57.60 75.13 63.19 67.54 65.47 87.58 78.65 85.60 4 100.58 71.93 93.69 77.98 97.20 83.06 56700 115.79 48.13 107.23 107.63 53.30 81.30 44.24 107.89 54.28 112.49 56.08 115.37 61.23 52.38 118.71 109.99 87.00 73.58 8 66.95 55.52 98.36 43.57 58.72 110.76 9 85.81 115.36 94.57 40.38 40.28 94.92 10 112.76 111.56 116.58 68.84 80.14 78.26 11 92.49 68.83 58.83 64.48 112.26 60.85 12 49.64 43.39 82.00 41.11 61.70 45.38 13 69.73 110.19 129.13 30.69 124.65 140.62 14 80.11 38.38 149.19 25.09 65.25 33.34 15 120.29 138.76 35.46 20.99 86.80 92.02 16 114.20 51.51 98.82 46.59 113.85 108.42 17 108.73 85.18 63.76 76.22 77.98 62.64 18 54.15 94.07 97.65 119.17 43.72 44.04 19 64.36 60.59 42.42 80.96 41.97 96.29 20 96.26 58.34 102.87 63.53 115.26 88.61 21 96.52 41.05 78.80 79.16 62.14 58.32 22 65.65 49.19 105.18 97.57 107.05 64.03 23 42.58 50.51 62.82 58.49 97.93 62.19 24 55.73 89.23 76.34 114.39 51.18 42.35 25 106.67 77.35 85.67 113.71 82.61 94.71 26 76.16 113.79 118.90 77.01 56.93 74.18 27 46.22 107.52 40.51 78.31 46.49 116.22 28 93.21 71.45 111.83 58.05 78.64 104.97 29 74.89 116.43 76.80 40.96 98.25 113.34 30 77.64 77.15 116.30 73.32 89.71 65.32 Item Number Sample Number 1 2 3 4 5 6 123 + 1 95.66 46.10 97.10 95.65 68.54 87.87 107.78 94.75 87.49 92.18 57.60 75.13 63.19 67.54 65.47 87.58 78.65 85.60 4 100.58 71.93 93.69 77.98 97.20 83.06 56700 115.79 48.13 107.23 107.63 53.30 81.30 44.24 107.89 54.28 112.49 56.08 115.37 61.23 52.38 118.71 109.99 87.00 73.58 8 66.95 55.52 98.36 43.57 58.72 110.76 9 85.81 115.36 94.57 40.38 40.28 94.92 10 112.76 111.56 116.58 68.84 80.14 78.26 11 92.49 68.83 58.83 64.48 112.26 60.85 12 49.64 43.39 82.00 41.11 61.70 45.38 13 69.73 110.19 129.13 30.69 124.65 140.62 14 80.11 38.38 149.19 25.09 65.25 33.34 15 120.29 138.76 35.46 20.99 86.80 92.02 16 114.20 51.51 98.82 46.59 113.85 108.42 17 108.73 85.18 63.76 76.22 77.98 62.64 18 54.15 94.07 97.65 119.17 43.72 44.04 19 64.36 60.59 42.42 80.96 41.97 96.29 20 96.26 58.34 102.87 63.53 115.26 88.61 21 96.52 41.05 78.80 79.16 62.14 58.32 22 65.65 49.19 105.18 97.57 107.05 64.03 23 42.58 50.51 62.82 58.49 97.93 62.19 24 55.73 89.23 76.34 114.39 51.18 42.35 25 106.67 77.35 85.67 113.71 82.61 94.71 26 76.16 113.79 118.90 77.01 56.93 74.18 27 46.22 107.52 40.51 78.31 46.49 116.22 28 93.21 71.45 111.83 58.05 78.64 104.97 29 74.89 116.43 76.80 40.96 98.25 113.34 30 77.64 77.15 116.30 73.32 89.71 65.32