Please use Excel and show all formulas/work

QUESTION #5 An industrial engineer is investigating 5 different assembly methods (A, B, C, D, E) for a sub-component. Five operators were selected for this study. The engineer also knows that each assembly method produces fatigue such that the time required for the last assembly may be greater than the first, regardless of the method. To account for these two sources of variability, the engineer utilizes the following Latin Square design. Table 1 shows where each treatment is locateed in the Latin Square. Table 2 shows the corresponding assembly times. Table 1: Treatment Locations Operator Table 2: Assembly Times Operator Order of Assembly Total 3 11 4 9 5 20 7 10 B C 2 3 DF D Order of Assembly 1 2 3 4 5 Total A B C 10 1423 10 17T 10 21 9 8 15 199 12 11 8 5 E L A Treatment Totals E The industrial engineer performs a hypothesis test with alpha a = 0.05 Ho: u;=u2 = Ug = 04 = us H: At least one mean is different 1. Fill in the ANOVA table. You can give a range for the p-value. SS P-value Source of variation Assembly method Operator Order of assembly Error Total 2. What should be the industrial engineer's conclusion