Excel Homework. Fizzy Drugs wants to optimize the yield from an important chemical process. The company thinks the number of pounds produced each time the process is run depends on the size of the container used, the pressure, and the temperature. The scientists involved believe the effect of changing one variable might depend on the values of other variables. The size of the process container must be between 1.3 and 1.5 cubic meters, pressure must be between 4 and 4.5 mm, and temperature must be between 22 and 30 degrees Celsius. The scientists patiently set up experiments at the lower and upper levels of the three control variables and obtain the data shown in the Fizzy.xlsx file:
1.Determine the relationship among yield, size, temperature, and pressure.
2.Discuss the interactions among pressure, size, and temperature.
3.What settings for temperature, size, and pressure would you recommend?