please also explain how to do it in excel

Merge & Center Cell Insert Delete Format Painter board Conditional Format Formatting as Table Styles Styles Font Alignment Number Cells C20 ment two-2 [Read-Only] B D H M N You are analysing the results of a designed experiment for a 24 factorial. This experiment looks at the effect of four process parameters on chemical yield which is measured in milligrams treatment Response (mg) (1) 90 74 b 81 77 d 98 2 marks Provide the design matrix ab 83 81 2 marks provide Contrast Totals and Effects 88 72 ac bc ad bd cd abc 2 marks Create a half-normal plot of the effects 87 99 2 marks Which effects are significant? 73 85 5 marks 79 Provide plots for each main effect and interaction effect be sure to make good plots with titles and axis labels abd acd bcd abcd 87 80 e s