Please include Excel document and formulas!!

1. Angela is now going to evaluate a new salt process delivery system and wants to know if the upper and lower control limits at 3 standard deviations for the new system will meet the upper and lower control specifications noted earlier. She picks a sample of four each hour for 5 hours. The data (in percent) from the initial trial samples are: Sample 1: 1.99, 2.0, 2.08,1.99 Sample 2: 1.98, 2.11, 2.15, 2.06 Sample 3:2.01,2.08,2.14,2.16 Sample 4:2.18,2.01,2.23,1.98 Sample 5: 2.20, 2.10.2.20,2.05 Analyze the data and draw the x and R control charts in Microsoft Excel including the upper and lower control limits. (Hint: There is no population standard deviation available so you need to get A2,D3 and D4 for upper and lower limits) 2. Given these data and your analysis, what conclusion do you, as a Frito Lays quality control inspector, draw from this process? What report do you issue to your supervisor Angela? If the current pattern of the data continues, what will happen in the next 10 hours of operations? Explain your findings and decision based on the data analysis. 3. What are the advantages and disadvantages of Frito-Lay drivers stocking their customers' 1. Angela is now going to evaluate a new salt process delivery system and wants to know if the upper and lower control limits at 3 standard deviations for the new system will meet the upper and lower control specifications noted earlier. She picks a sample of four each hour for 5 hours. The data (in percent) from the initial trial samples are: Sample 1: 1.99, 2.0, 2.08,1.99 Sample 2: 1.98, 2.11, 2.15, 2.06 Sample 3:2.01,2.08,2.14,2.16 Sample 4:2.18,2.01,2.23,1.98 Sample 5: 2.20, 2.10.2.20,2.05 Analyze the data and draw the x and R control charts in Microsoft Excel including the upper and lower control limits. (Hint: There is no population standard deviation available so you need to get A2,D3 and D4 for upper and lower limits) 2. Given these data and your analysis, what conclusion do you, as a Frito Lays quality control inspector, draw from this process? What report do you issue to your supervisor Angela? If the current pattern of the data continues, what will happen in the next 10 hours of operations? Explain your findings and decision based on the data analysis. 3. What are the advantages and disadvantages of Frito-Lay drivers stocking their customers