Activate its. the variable yield from each of the sub-datasets created in question (1). Different from Exam is. You can 1, you now have to fill out the last row in Table 1. The raw "overall" means regardless of the cultivar, that is, the mean and standard deviation including all cultivars (i.e., from the original dataset where all cultivars are on the same worksheet). Make sure you correct any mistake ponding to (if any) you made in question (2) from Exam 1 before you re-submit your answers. (Points: is, select 10) ata tab in Table 1. Yield per cultivar, averaged across locations and treatments in 2012. Yield (kg/ha) Cultivar Mean Std. Dev. Coker 9553 36 6215 04 590 8006 Terral LA841 5403.00 567.25 Magnolia 5619 56 678 7984 Pioneer 25R47 36 5763 93 900 3796 Overall 3. In this exercise you will conduct five : tests (one for each cultivar, and one overall, meaning regardless of the cultivars). Table 2 below summarizes yield in 2011 (rather than in 2012) Use Tables 1 and 2 to test the hypothesis that wheat vield changed That is, test the hypothesis that wheat yield is different from the yield levels specified in Table 2 below. In each of the five : tests: a. State the null and alternative hypotheses for the population mean in words. (Points: 3) b. State the null and alternative hypotheses for the population mean using the mathematical notation. (Points: 3) c. "Type the formula. Make sure you provide the formula in each / test. (Points: 1) d. Type the procedure. (Points: 4) e. Type the final answer. (Points: 3) f Type the critical value(s). Use a = 0.05 significance level. (Points: 1) g State the correct conclusion ( There is sufficient evidence at the a = 0.05 significance level to support..." or "There is NOT sufficient evidence at the a = 0.05 significance level to support..."). Make sure you state the conclusion in terms of HI. (Points: 3) Table 2. Yield per cultivar, averaged across locations and treatments in 2011. Wheat Yield in 2011 Mean Cultivar (kg/ha) Coker 9553 4 974 75 Tenal LA$41 4,604.81 Magnolia 4 250 59 document. Pioneer 25R47 4,698 27 Overall 4,632.10 and question (1) Focus + 50% 9:30 AM C W 3/31/2022