1.It is desired to compare 3 hospitals with regards to the number of deaths per quarter. A sample of death records were selected from the records of each hospital and number of deaths are given below. From these data. suggest a difference in the number of death per quarter among three hospitals: Hospital I: 8, 10, 7, 14,11; Hospital II: 7, 5, 10, 9, 9; Hospital III: 12, 9, 13, 12, 14. Test at 5% level of significance.

a)SSC=40, SSE=60, F=4, Ho is rejected.

b)SSC=4, SSE=16, F=2, Ho is rejected.

c)SSC=40, SSE=10, F=4, Ho is rejected.

2.Set up a two way ANOVA table for the following per hectare yield for 4 varieties of wheat A, B, C & D on 3 plots: Plot I: yield of A 3, B 4, C 6, D 6. Plot II: yield of A 6, B 4, C 5, D 3. Plot III: yield of A 6, B 6, C 4, D 7.

a)F1=0.663, F2=0.08

b)F1=0.08, F2=0.663

c)F1= 0.22, F2=2.64

3.The study of performance of 3 detergents(A, B & C) in 3 different water temperatures were recorded with specially designed equipment. The following whiteness readings were recorded: Cold water: A 57, B 55, C 67; Warm water: A 49, B 52, C 68; Hot water A 54, B46, C 58. Perform a two way analysis using 5% level of significance given that F at 5%= 6.94.

a)F1=9.99, F2= 2.33, Ho is rejected in both cases.

b)F1=2.33, F2=9.99, Ho is accepted in both cases.

c)F1=9.85, F2=2.38, Ho is rejected in both cases.

Please explain in detail using excel and using all the formulas