The data shown here are observations collected from an experiment that compared three treatments, A, B, and C, within each of five blocks, using a randomized block design:

MS Excel output for Exercise 11.34

Use the Excel ouput to analyze the experiment. Investigate possible differences in the block and/or treatment means and, if any differences exist, use an appropriate method to specifically identify where the differences lie. Has blocking been effective in this experiment? Present your results in the form of a report.

Block Treatment 23 5Total 2.1 2.6 19 3.2 2.7 12.5 3.4 3.8 3.6 4.1 3.9 18.8 3.0 3.6 3.2 3.9 3.9 7.6 8.5 10.0 8.7 11.2 10.5 48.9 Total Anova: Two-Factor Without Replication SUMMARYCountSum Aerage Vriance 0.265 3.76 0.073 3.52 0.167 3 8.5 2.833 0.443 103.333 0.413 0.79 3 11.2 3.733 0.223 0.48 5 12.5 5 18.8 5 17.6 2.5 2.9 3 10.5 3.5 ANOVA Source of Variation Rows Columns Error Total P-value Fcrit SS 4.476 1.796 0.224 6.496 14 df 2 2.238 79.929 0.000 4.459 4 0.449 16.036 0.001 3.838 8 0.028 MS