I this better
File Tools View AG505-Module12-Lab - Compatibility Mode . Saved to this PC - - X MODULE 12 - Post Hoc Tests on One-Way (i) State the null and alternative hypotheses. hypothesis. Make sure you clearly state for Analysis of Variance (Points: 5) which pair you reject or fail to reject the null AG 505- Statistical Methods in Agriculture (i) Copy and paste the SUMMARY table from hypothesis. (Points: 5) Instructor: Dr. Jose Lopez the worksheet ply containing the results in (6) Summarize the conclusions of Tukey's test your Word document. (Points: 10) in a figure by underlining the populations Make sure you submit all your answers to this lab in (ii) Copy and paste the ANOVA table from the means which are not significantly different one Word document. worksheet ply containing the results in your from each other. (Points: 5) Word document. (Points: 10) 1. One measure of the value of a stock is its price to (iii) State the correct conclusion for this hy- (c) Draw boxplots of the three categories to support earnings ratio (or P/E ratio). It is the ratio of the pothesis test ("There is sufficient evidence the analytic results obtained in parts (a) and (b). price of a stock per share to the earnings per share at the a = 0.05 significance level to sup- Don't forget to double check the whiskers of and can be thought of as the price an investor is will- port..." or "There is NOT sufficient evi- each boxplots. ing to pay for $1 of earnings in a company. A stock dence at the a = 0.05 significance level (1) Adjust the horizontal axis of each boxplot so analyst wants to know whether the P/E ratios for to support..."). Make sure you state the that all three boxplots horizontal axes begin three industry categories differ significantly. The conclusion in terms of HI. (Points: 5) at the same value and ends at the same following data represent simple random samples of value. Hint: For an example, see the box- companies from three categories: (1) financial, (2) (b) If the null hypothesis is rejected in part (a), use plots reported in Example 1 of the Module food, and (3) leisure goods. Tukey's test to determine which pairwise means 1 1 Handout. (Points: 5) differ using a familywise error rate of a = 0.05. (1) Copy and paste each boxplot in your word (1) Write down the sample means in ascending document. (Points: 10 per boxplot) order. (Points: 5) (iii) Do the boxplots support the analytic re- (2) Compute the pairwise differences for each sults in part (a) and (b)? Make sure you ex- Source: Yahoo!Finance. pair of sample means. (Points: 5) plain why/how the boxplots support the an- (3) Compute the Tukey's test statistic for each alytic results from part (a) and (b). (Points: (a) Use Microsoft Excel Data Analysis ToolPak to pairwise difference for each pair of sample 5 ) test the null hypothesis that the mean P/E ratio means. (Points: 5) for each category is the same at the a = 0.05 (4) Determine the critical value. (Points: 5) level of significance. Note: The requirements (5) For each pair of sample means, state End of document for a one-way ANOVA are satisfied. whether you reject or fail to reject the null019-2020 DEC X uc.edu/content/enforced/8015-AG50501W-LOPEZ/imscc8c3f758018ad44ee8caboc10a2c68952 + Co V 1. One measure of the value of a stock is its price to earnings ratio (or P/E ratio). It is the ratio of the price of a stock per share to the earnings per share and can be thought of as the price an investor is willing to pay for $1 of earnings in a company. A stock analyst wants to know whether the P/E ratios for three industry categories differ significantly. The following data represent simple random samples of companies from three categories: (1) financial, (2) food, and (3) leisure goods. Financial Food 8.83 Leisure Goods 12.75 19.75 14.10 17.87 13.48 10.12 IS.18 14.42 15 57 22.84 13.48 10.06 13.60 11.27 Source: Yahoo!Finance. (a) Use Microsoft Excel Data Analysis ToolPak to test the null hypothesis that the mean P/E ratio for each category is the same at the a - 0.05 level of significance. Note: The requirements for a one-way ANOVA are satisfied. (1) State the null and alternative hypotheses. (Points: 5) (i) Copy and paste the SUMMARY table from the worksheet ply containing the results in your Word document. (Points: 10) (ii) Copy and paste the ANOVA table from the worksheet ply containing the results in your Word document. (Points: 10) (iii)State the correct conclusion for this hypothesis test ("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: 5) (b) If the null hypothesis is rejected in part (a), use Tukey's test to determine which pairwise means differ using a familywise error rate of a = 0.05. (1) Write down the sample means in ascending order. (Points: 5) (2) Compute the pairwise differences for each pair of sample means. (Points: 5) (3) Compute the Tukey's test statistic for each pairwise difference for each pair of sample means. (Points: 5) (4) Determine the critical value. (Points: 5) (5) For each pair of sample means, state whether you reject or fail to reject the null hypothesis. Make sure you clearly state for which pair you reject or fail to reject the null hypothesis. (Points: 5) (6) Summarize the conclusions of Tukey's test in a figure by underlining the populations means which are not significantly different from each other. (Points: 5) Page I of 2 (c) Draw boxplots of the three categories to support the analytic results obtained in parts (a) and (b). Don't forget to double check the whiskers of each boxplots. (i) Adjust the horizontal axis of each boxplot so that all three boxplots horizontal axes begin at the same value and ends at the same value. Hint: For an example, see the boxplots reported in Example I of the Module I I Handout. (Points: 5) (ii) Copy and paste each boxplot in your word document. (Points: 10 per boxplot) (ili) Do the boxplots support the analytic results in part (a) and (b)? Make sure you explain why/how the boxplots support the analytic results from part (a) and (b)
