Question: Can anyone help me s send me the excel portion and how they solved it 4) An experiment was conducted to compare 4 types of
Can anyone help me s send me the excel portion and how they solved it

4) An experiment was conducted to compare 4 types of upland rice varieties (A, B, C, D) if they differed in yield. Each variety was replicated five times. The yield was as follows: Variety Average A 6.95 B 4.5 C 3.8 D 3.7 Conduct an ANOVA by hand to see if there are any significant differences at 0.05 level between the three varieties in yield. a) Make an ANOVA table and calculate the rest of the required values to complete your ANOVA table. Base from t - statistic make your conclusion at a = 0.05 level of significance. (5 points) ANOVA Source of Variation diSS MS F F crit Between Groups 34.53 Within Groups omparison Dif 5 vs 0 40 Total 43.93 75 vs 25 41 b) Based from your ANOVA result, is it appropriate to conduct an LSD test? 75 vs 50 4 If it is appropriate, conduct an LSD test at a = 0.05. (5 points) Calculate your LSD Value
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
