Answer:
A) You will get the Mean, Sample variance and standard deviation, Minimum, maximum, range, and Boxplot.
B) The two-way ANOVA (analysis of variance) model is used for the two factors.
C) Outputs are obtained
D) Here, P-value (= 0.0377) < α (= 0.05). There is evidence that the treatments differ with respect to emerging plants.
Step-by-step explanation:
(A)
Use the MegaStat add-in in Excel to draw the boxplot and to find; the group counts, means, standard deviations, variances, minimums, maximums, and ranges for the 5 treatment groups.
In another Excel worksheet. Enter the data in 5 different columns, each column representing a treatment, and the first row holding the treatment names.
Go to Add-Ins > MegaStat > Descriptive Statistics.
Enter Sheet1!$A$1:$E$5 in Input range.
Tick on Mean, Sample variance and standard deviation, Minimum, maximum, range, and Boxplot.
Click OK.
(B)
Since there are two factors affecting the outcomes- the five treatments (Control, Arasan, Spergon, Semesan, and Fermate), and the four blocks, the two-way ANOVA (analysis of variance) model must be used.
(C)
We have used the Data Analysis tool-pack in Excel to construct the analysis of variance table.
We have arranged the data and entered it as follows:
Control, Arasan, Spergon, Semesan, Fermate
Block 1: 86 98 96 97 91
Block 2: 90 94 90 95 93
Block 3: 88 93 91 91 95
Block 4: 87 89 92 92 95
Go to Data > Data Analysis > Anova: Two-Factor Without Replication > OK.
In Input Range, enter $A$1:$E$6; tick on labels, enter Alpha as 0.05, and click OK.
The following output is obtained. Note that the analysis of variance table is given under “ANOVA” in the output.
(D)
In the analysis of variance table above, the “Rows” under “Sources of Variation” correspond to the treatments (as the observations under each treatment are noted along a row), whereas the “Columns” title relates to the block effects.
The P-value for Rows, hat is, for the treatments is 0.0377 (4 decimal places).
The level of significance is given as α = 0.05.
In this case, the null hypothesis is that, there is no significant difference between the 5 treatments, and the alternative hypothesis should be that, not all the treatments have the same effect.
The rejection rule for a test using the P-value is: Reject the null hypothesis, if P-value ≤ α. Otherwise, fail to reject the null hypothesis.
=