1 What Limits the Reproductive Success of Migratory Birds? This assignment is based on background information on the following website: . To do this assignment, you will need to use the Data Analysis Add-in for Excel. () Download Warbler Data.xls. The dataset contains the following data: •Predator Abundancerefers to the number of chipmunks and red squirrels detected per hour, on average, during predator observations. Predator abundance data were not collected in 1986, 1987, or 1991. •Food Abundancerefers to the biomass of caterpillars (in milligrams per 100 leaves) on the study plot during the breeding season. Food abundance data were not collected in 1999. •Reproductive Successrefers to the average number of young that left nests ("fledged") per territory in each year. This is a good measure of fecundity in passerine birds. 1. Researchers quantified how food abundance affected warbler reproductive success: a) What is the independent variable in this analysis? (2 pts.) b) What is the dependent variable? (2 pts.) 2. Create a graph of food abundance versus reproductive success. Be sure to label your axes! Add a trendline to your graph. (4 pts.) a)What is the relationship between food abundance and reproductive success? (2 pts.) 3. Test if the relationship you just graphed is statistically significant. To do so, do a regression analysis, using the data analysis add-in. Check the box to save the residuals from this analysis. a)Are the results of your regression statistically significant? What output did you use to make this determination? (3 pts.) b)Part of your output is an R2value. Report the result for this value, and how this result should be interpreted. (3 pts.) c)You saved the residuals from your analysis. What is a residual? Include in your answer how to interpret the sign (positive or negative) of each residual. (4 pts.) What Limits the Reproductive Success of Migratory Birds? Warbler Data Analysis (50 pts.) Learning module developed by K. Langin, H. Sofaer and S. Sillett for Hubbard Brook Research Foundation (2009).
You've reached the end of your free preview.
Want to read all 5 pages?