E M R 1 DAY Ingredients A 1 2 3 4 5 square 0 0 C sum of each batch 0 0 0 0 0 sq of Day1 D D D D D sqof Day2 sqof Day3 D D D 0 0 0 0 0 D 0 sg of Day4 sqof Day5 0 0 0 0 0 0 O 0 0 0 0 D 0 E 0 0 0 0 0 0 0 0 0 0 0 sum of B 0 0 sum ofc 0 0 sum of D sum of E 0 0 0 0 2 3 1 4 2 BATCH 5 3 6 4. 7 5 8 sum of each column 9 square LO 11 sum of A 12 0 23 square 0 24 25 26 Row nr 27 Column nc L8 N nr*nc 19 p 20 alpha 5% 21 22 Grand Sum 23 Grand Mean SST 25 Streatement 26 MStreatement 27 5Srow 28 SScolumn 29 SSerror 30 MSerror 31 32 33 Numerator dof 34 Denominator dof 35 36 5 5 25 5 0.05 0 0 0 F-Test F-Critical #DIV/0! 3.26 0 0 0 0 0 0.000 4 12 Instructions Q) 1: Repeat class problem of 5x5 Latin square on excel sheet. Analyze and submit the output. Q) 2: Load the following data to excel sheet and analyze it. Submit the data Note: Don't type in TREATEMENT LETTERS in the color coded excel cells. Batches of Raw Materials Operator 1 Operator 2 Operator 3 Operator 4 Operator 5 1 2 3 4 A= 24 C = 18 B=17 D = 26 E=22 B= 20 E = 31 A= 30 C= 24 D = 38 D = 30 A= 26 C= 19 E = 26 B=20 C= 29 D = 24 E =27 B =23 A= 27 E = 24 B = 21 D=31 A=36 C=22 5 E M R 1 DAY Ingredients A 1 2 3 4 5 square 0 0 C sum of each batch 0 0 0 0 0 sq of Day1 D D D D D sqof Day2 sqof Day3 D D D 0 0 0 0 0 D 0 sg of Day4 sqof Day5 0 0 0 0 0 0 O 0 0 0 0 D 0 E 0 0 0 0 0 0 0 0 0 0 0 sum of B 0 0 sum ofc 0 0 sum of D sum of E 0 0 0 0 2 3 1 4 2 BATCH 5 3 6 4. 7 5 8 sum of each column 9 square LO 11 sum of A 12 0 23 square 0 24 25 26 Row nr 27 Column nc L8 N nr*nc 19 p 20 alpha 5% 21 22 Grand Sum 23 Grand Mean SST 25 Streatement 26 MStreatement 27 5Srow 28 SScolumn 29 SSerror 30 MSerror 31 32 33 Numerator dof 34 Denominator dof 35 36 5 5 25 5 0.05 0 0 0 F-Test F-Critical #DIV/0! 3.26 0 0 0 0 0 0.000 4 12 Instructions Q) 1: Repeat class problem of 5x5 Latin square on excel sheet. Analyze and submit the output. Q) 2: Load the following data to excel sheet and analyze it. Submit the data Note: Don't type in TREATEMENT LETTERS in the color coded excel cells. Batches of Raw Materials Operator 1 Operator 2 Operator 3 Operator 4 Operator 5 1 2 3 4 A= 24 C = 18 B=17 D = 26 E=22 B= 20 E = 31 A= 30 C= 24 D = 38 D = 30 A= 26 C= 19 E = 26 B=20 C= 29 D = 24 E =27 B =23 A= 27 E = 24 B = 21 D=31 A=36 C=22 5