Need help setting up the excel and how to solve 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 mparison Dif 5 vs 0 40 Total 43.93 75 vs 25 4( 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: 50 vs 0