I need to answer this as Excell !!

1. The specifications from the manufacturer of a particular type of metal coating call for the temperature of the drying oven to be 370 = 10F. The company that is con- sidering using this coating has run tests by taking a large number of temperature readings from various parts of its oven at random times. The standard deviation of the readings about the mean temperature setting was found to be 2.06F. What is the capability index? 2. The manufacturer of a carbonated drink mix recommends that its drink concen- trate be 6 = 1 percent of each drink so the drinks will have the intended flavor. A manufacturer of drink dispensers is testing its mixer valves to determine the per- centage of concentrate dispensed. What would the standard deviation of the distri- bution of concentrations have to be for the dispensing equipment to meet the rec- ommendations with a capability index of 1.25? 7. Care was taken to operate a metal casting process so that no assignable causes of vari- ation were introduced, and randomly selected castings were weighed. The target weight of the castings was 28 pounds. The following weights came from 30 random observations. 28.00 28.04 28.03 28.01 27.99 27.96 28.03 27.98 28.03 28.04 28.01 27.94 28.01 27.98 28.00 28.02 27.99 28.03 27.98 28.02 28.00 27.98 28.02 28.05 28.03 28.01 27.99 28.02 27.96 27.96 a. Estimate the standard deviation of the process. b. What is Cp if the specifications are 28.0 + 0.1 pounds