in excel

B D H E G A study was conducted to determine the effects of four factors on the output of a process. R S T 4 marks M N Q Provide the design layout for a four factor factorial experiment The results are in the table below. 3 marks Given the responses, provide the contrast totals, effect estimates and Sum of Squares. 3 marks Treatment (1) Generate the ANOVA table for these results and highlight those that are significant. Use alpha=0.01. 3 marks Create one interaction plot for the two-factor interaction that is most significant. b d ab ac Replicates Il 0.756 0.675 0.985 1.112 0.723 0.776 0.632 0.605 0.603 0.652 0.984 0.952 0.671 0.666 0.811 0.776 0.652 0.669 0.637 0.552 0.564 0.586 0.802 0.785 0.795 0.775 0.657 0.619 0.556 0.495 0.691 0.652 ad bc bd cd abc abd acd bcd abcd 3 O 25 26 B D H E G A study was conducted to determine the effects of four factors on the output of a process. R S T 4 marks M N Q Provide the design layout for a four factor factorial experiment The results are in the table below. 3 marks Given the responses, provide the contrast totals, effect estimates and Sum of Squares. 3 marks Treatment (1) Generate the ANOVA table for these results and highlight those that are significant. Use alpha=0.01. 3 marks Create one interaction plot for the two-factor interaction that is most significant. b d ab ac Replicates Il 0.756 0.675 0.985 1.112 0.723 0.776 0.632 0.605 0.603 0.652 0.984 0.952 0.671 0.666 0.811 0.776 0.652 0.669 0.637 0.552 0.564 0.586 0.802 0.785 0.795 0.775 0.657 0.619 0.556 0.495 0.691 0.652 ad bc bd cd abc abd acd bcd abcd 3 O 25 26