its a excel question of operations management how to do it on excel

An experiment was performed to study the effect of four factors on chemical yield High A B D temperature pressure catalyst conc Low 125 60 Type A 4% 145 80 Type B 6% 3 marks Provide the design layout for a four factor factorial experiment 3 marks Given the responses, provide effect estimates. (the responses are in columns AQ:AS) 3 marks Provide a half-normal plot of the effects and label the effects ( as we did on class) 4 marks Put together an ANOVA table for this experiment and highlight the significant effects An experiment was performed to study the effect of four factors on chemical yield High A B D temperature pressure catalyst conc Low 125 60 Type A 4% 145 80 Type B 6% 3 marks Provide the design layout for a four factor factorial experiment 3 marks Given the responses, provide effect estimates. (the responses are in columns AQ:AS) 3 marks Provide a half-normal plot of the effects and label the effects ( as we did on class) 4 marks Put together an ANOVA table for this experiment and highlight the significant effects