In this activity, you will be performing a single factor ANOVA on the data to determine whether the longevity of male fruitflies is related to their reproductive cycle. Studies have shown that the longevity (life span) of female fruitflies decreases with an increase in reproduction, and this leads to the question related to males.
The design of the study placed male fruitflies in the
following groups: Using Excel, perform a single factor ANOVA to determine if there is a significant difference between any two of the five groups. Be certain to select "new worksheet ply" for the ANOVA output table. If there is a significant difference, you will need to determine the means that are significantly different by doing a post hoc Tukey Test. This data exists in Excel Data format. For your assignment, you will upload a single page pdf in portrait orientation. Your name and class period will be in a header in the upper right-hand corner. The data will not be included; the page will start in cell A1 with the ANOVA output table. Underneath the table you will answer the questions below in complete sentences. Be sure to spell check and proofread your work. Use "wrap text" or another technique to keep your answers to a single printed page. 1. What is the p value? Oh, if you are wondering how one determines "interest" in fruitflies, here is the scoop! Newly inseminated females will not usually mate again for at least two days. So the males in the uninterested groups were always living with newly inseminated females! Copyright © 1997 Central Virginia Governor's School for Science and Technology Lynchburg, VA |