please show clear specific work

Assignment 2 Instructions: Please be specific in answering the following questions and present the details of your work/calculations. Submitting just the final answers is not enough. This also allows me to give you partial credits. (5 points) You should either type your answer in the Word file, or if you write in on a paper, take a photo of it and copy the photo on the Word file. If you use Excel to answer the questions you should copy an image of the Excel sheet on the Word file. You should submit all answers in one Word file. Questions 1-4 (95 Points) Question 1- Midnight Mocha is a 24-hr caf that specializes in coffee drinks. It has a drive-through that is almost fully automated Each mug of coffee is dispensed by the automated machinery and should provide exactly 12 ounces. Recently, customers have complained that the cups appear to have too much or too little coffee. Midnight Mocha began a quality control program. Every day for 9 days they sampled nine cups of coffee. They computed the average amount of coffee for the nine cups and the average for the range of values. Those values are listed below. 1 2 3 4 5 6 7 8 9 Mean 11.9 12.2 12.1 12.1 11.7 11.9 12.1 12.1 11.9 Range 0.19 0.24 0.18 0.19 0.19 0.18 0.07 0.09 0.07 1. What would be the upper control limit (UCL) and lower control limit (LCL) for the means? 2. What would be the upper controllimit (UCL) and lower control limit (LCL) for the range values? 3. Plot the control charts (both Mean and Range charts) including the samples in table above (you may use excel to do this) 4. How many of the observations for the means are out of control? 5. How many of the nine observations for the ranges are out of control? 6. Assume that Midnight Mocha obtained the same values for the means and the same values for the ranges, but it had used a sample size of 16. What then would be the upper control limit (UCL) and lower control limit (LCL) for the means? 7. Assume that Midnight Mocha obtained the same values for the means and the same values for the ranges, but it had used a sample size of 16. What then would be the upper control limit (UCL) and lower control limit (LCL) for the ranges