Q3-7 Linear Relationship
| Prey Density (prey/km2) |
Growth Rate (owls/year) |
| 17198 |
0.34 |
| 16509 |
-0.56 |
| 18739 |
0.01 |
| Slope: |
| 17203 |
-0.49 |
| Intercept: |
| 13792 |
-0.42 |
| Standard Deviation: |
| 20485 |
0.65 |
| 17255 |
-1.13 |
| 17614 |
0.19 |
| 21289 |
1.10 |
| 21794 |
-0.11 |
| 15045 |
-1.39 |
| 21098 |
-0.47 |
| 18849 |
-0.79 |
| 11368 |
-1.20 |
| 21337 |
0.59 |
| 19907 |
0.16 |
| 15496 |
0.54 |
| 16113 |
0.46 |
| 17048 |
-0.43 |
| 13569 |
0.12 |
| 15517 |
-0.73 |
| 13531 |
-1.01 |
| 16950 |
0.62 |
| 18271 |
0.59 |
| 18376 |
0.39 |
| 17046 |
-0.67 |
| 21931 |
1.14 |
| 19111 |
0.98 |
| 21015 |
-0.10 |
| 19202 |
0.95 |
| 20598 |
0.55 |
| 18776 |
-0.75 |
| 17604 |
-1.08 |
| 12342 |
0.29 |
| 15574 |
-1.09 |
| 15002 |
-0.78 |
| 21681 |
1.25 |
| 14914 |
-0.00 |
| 15157 |
-0.18 |
| 16567 |
0.12 |
| 21123 |
0.04 |
| 18010 |
-0.94 |
| 20701 |
-0.23 |
| 21264 |
0.46 |
| 22583 |
-0.19 |
| 14589 |
-1.16 |
| 20298 |
-0.63 |
| 20290 |
-0.64 |
| 16494 |
-0.87 |
| 11376 |
-1.17 |
| 17299 |
0.43 |
| 19105 |
0.82 |
| 13957 |
-1.16 |
| 15910 |
-0.14 |
| 21505 |
0.66 |
| 29552 |
0.18 |
| 24082 |
0.64 |
| 26588 |
-0.08 |
| 13769 |
-0.74 |
| 19077 |
0.26 |
| 15201 |
-0.73 |
| 15786 |
-0.08 |
| 22658 |
1.24 |
| 18688 |
-0.59 |
| 16926 |
-1.18 |
| 14443 |
-0.68 |
| 21627 |
-0.72 |
| 16567 |
-0.24 |
| 17487 |
-0.53 |
| 21201 |
-0.55 |
| 22389 |
-0.07 |
| 9973 |
-1.56 |
| 18282 |
-0.16 |
| 26543 |
0.99 |
| 23181 |
-0.28 |
| 16335 |
-0.55 |
| 16124 |
0.70 |
| 26146 |
0.20 |
| 18771 |
0.65 |
| 19206 |
0.17 |
| 19418 |
0.76 |
| 16166 |
0.35 |
| 24332 |
1.04 |
| 15757 |
-1.18 |
| 16922 |
-0.91 |
| 19531 |
0.70 |
| 23037 |
1.36 |
| 15640 |
-0.85 |
| 23886 |
1.00 |
| 21201 |
-0.70 |
| 21493 |
0.06 |
| 15626 |
-0.02 |
| 17134 |
0.35 |
| 19717 |
-0.26 |
| 15755 |
-0.90 |
| 22740 |
0.12 |
| 17079 |
-0.16 |
| 18647 |
0.73 |
| 20039 |
0.73 |
| 11705 |
-1.09 |
Create a single plot of a linear relationship between the prey density and the growth rate of both populations from 1971 to 2020.
Round to the nearest ten-thousandths place or four numbers after the decimal. For example, if a number looks like 1.034581, you would round to 1.0346.
Refer to Acts 1 and 2 for figure formatting and formulas. You will be graded on your ability to format figures and utilize formulas to calculate the slope, intercept, and standard deviation for independent and dependent variables.
Q8-12 Pop A Prey Density
| Year |
Population A Prey Density (prey/km2) |
| 1971 |
22583 |
| 1972 |
21931 |
| Mean: |
| 1973 |
21794 |
| Standard Deviation: |
| 1974 |
21681 |
| Median: |
| 1975 |
21337 |
| 1976 |
21289 |
| 1977 |
21264 |
| Bin Ranges |
Bins |
Frequency |
| 1978 |
21123 |
| 11000-12000 |
12000 |
| 1979 |
21098 |
| 12000-13000 |
13000 |
| 1980 |
21015 |
| 13000-14000 |
14000 |
| 1981 |
20701 |
| 14000-15000 |
15000 |
| 1982 |
20598 |
| 15000-16000 |
16000 |
| 1983 |
20485 |
| 16000-17000 |
17000 |
| 1984 |
20298 |
| 17000-18000 |
18000 |
| 1985 |
20290 |
| 18000-19000 |
19000 |
| 1986 |
20097 |
| 19000-20000 |
20000 |
| 1987 |
20010 |
| 20000-21000 |
21000 |
| 1988 |
19937 |
| 21000-22000 |
22000 |
| 1989 |
19586 |
| 22000-23000 |
23000 |
| 1990 |
19123 |
| 1991 |
19111 |
| 1992 |
19101 |
| 1993 |
19086 |
| 1994 |
18983 |
| 1995 |
18861 |
| 1996 |
18762 |
| 1997 |
18532 |
| 1998 |
18010 |
| 1999 |
17203 |
| 2000 |
17198 |
| 2001 |
17048 |
| 2002 |
17046 |
| 2003 |
16567 |
| 2004 |
16509 |
| 2005 |
16494 |
| 2006 |
16113 |
| 2007 |
15574 |
| 2008 |
15517 |
| 2009 |
15496 |
| 2010 |
15157 |
| 2011 |
14932 |
| 2012 |
14914 |
| 2013 |
14589 |
| 2014 |
13792 |
| 2015 |
13569 |
| 2016 |
13531 |
| 2017 |
12723 |
| 2018 |
12342 |
| 2019 |
11376 |
| 2020 |
11368 |
Use the raw data for prey densities of Population A from 1971 to 2020 (sample size = 50 years) in this tab to perform probability calculations.
These are for questions 8-12.
8. Calculate the mean
9. Calculate the standard deviation
10. Calculate the median
11. Generate a frequency distribution plot
Round to the nearest whole number. For example, if a number looks like 1.972, you would round to 2.
Refer to Acts 1 and 2 for formatting and formulas. You will be graded on your ability to format figures and utilize formulas to calculate the slope, intercept, and standard deviation.
Q13-18 Pop B Prey Density
| Year |
Population B Prey density (prey/km2) |
| 1971 |
29552 |
| 1972 |
26588 |
| Mean: |
| 1973 |
26543 |
| Standard Deviation: |
| 1974 |
25691 |
| Median: |
| 1975 |
24332 |
| 1976 |
24082 |
| 1977 |
23886 |
| Bin Ranges |
Bins |
Frequency |
| 1978 |
23181 |
| 8000-10000 |
10000 |
| 1979 |
23037 |
| 10000-12000 |
12000 |
| 1980 |
22740 |
| 12000-14000 |
14000 |
| 1981 |
22658 |
| 14000-16000 |
16000 |
| 1982 |
21978 |
| 16000-18000 |
18000 |
| 1983 |
21627 |
| 18000-20000 |
20000 |
| 1984 |
21505 |
| 20000-22000 |
22000 |
| 1985 |
21493 |
| 22000-24000 |
24000 |
| 1986 |
21201 |
| 24000-26000 |
26000 |
| 1987 |
21201 |
| 26000-28000 |
28000 |
| 1988 |
20039 |
| 28000-30000 |
30000 |
| 1989 |
19717 |
| 1990 |
19531 |
| 1991 |
19418 |
| 1992 |
19206 |
| 1993 |
19105 |
| 1994 |
19077 |
| 1995 |
18771 |
| 1996 |
18688 |
| 1997 |
18647 |
| 1998 |
18282 |
| 1999 |
18563 |
| 2000 |
17299 |
| 2001 |
17134 |
| 2002 |
17079 |
| 2003 |
16926 |
| 2004 |
16922 |
| 2005 |
16567 |
| 2006 |
16335 |
| 2007 |
16166 |
| 2008 |
16124 |
| 2009 |
15910 |
| 2010 |
15786 |
| 2011 |
15757 |
| 2012 |
15755 |
| 2013 |
15640 |
| 2014 |
15626 |
| 2015 |
14783 |
| 2016 |
13896 |
| 2017 |
13957 |
| 2018 |
13769 |
| 2019 |
11705 |
| 2020 |
9973 |
Use the raw data for prey densities of Population B from 1971 to 2020 (sample size = 50 years) in this tab to perform probability calculations.
These are for questions 13-18.
13. Calculate the mean
14. Calculate the standard deviation
15. Calculate the median
16. Generate a frequency distribution plot
Round to the nearest whole number. For example, if a number looks like 1.972, you would round to 2.
Refer to Acts 1 and 2 for formatting and rounding instructions. You will be graded on your ability to format figures and utilize formulas to calculate the slope, intercept, and standard deviation.
Q19-22 Expected Growth
|
| Copied from Q3-7 |
|
| Slope: |
|
| Intercept: |
|
| Standard Deviation: |
|
| Copied from Q8-12 |
|
| Mean: |
|
| Median: |
|
| Copied from Q13-18 |
|
| Mean: |
|
| Median: |
|
|
| Growth Rate |
|
| Expected Population Growth A |
|
| Expected Population Growth B |
You will need to use the linear relationship or slope from Q3-7. You will then, depending upon your interpretation of the normality of the distribution, need to use the median, or the mean, and the standard deviation of Population A and Population B to calculate the respective growth rates in Q12 and Q17.
Keep this formula in mind:
𝜇=aP+b
"𝜇" = expected growth rates for populations
"a" = slope
"P" = mean or median prey density
"b" = intercept
You will be graded on your ability to utilize formulas to calculate the expected population growth for A and B. Round to the nearest ten-thousandths place or four numbers after the decimal. For example, if a number looks like 1.034581, you would round to 1.0346.
Q27 Growth Probability
|
| Copied from Q3-7 or Q19-22 |
|
| Slope: |
|
| Intercept: |
|
| Standard Deviation: |
|
| Possible Prey Densities |
Expected Growth Rate |
Probabilites growth is > 0 |
Percentages of Growth |
|
| 17458 |
|
| 19318 |
|
| 22109 |
|
| 25829 |
Given the predicted prey densities to choose from,you will finally calculate the probabilities and select the one that will give >80% chance of causing a positive growth rate. (Hint: This is a two-step process)
Step 1. Calculate the expected growth rate using using the linear relationship from Q3-7 and Q19-22.
Keep this formula in mind:
𝜇=aP+b
"𝜇" = expected growth rate
"a" = slope
"P" = possible prey density
"b" = intercept
Step 2. Using the expected growth rate calculated for each of the prey densities, calculate the probabilities that the growth rate is > 0. We are assuming a normal distribution to calculate the probabilities. The expected growth rate is going to act like an average in your probability calculations. Once calculated demonstrate the copy and Paste Values into "Percentages of Growth" to find your answer.
You will be graded on your ability to utilize formulas to calculate the Expected Growth Rates AND Probabilities Growth >0.
TA Sheet
| TA Use Only |
| ERROR:#N/A |
| ERROR:#N/A |
| ERROR:#N/A |
| ERROR:#N/A |
| ERROR:#N/A |
| ERROR:#N/A |
| ERROR:#N/A |
| ERROR:#N/A |
| ERROR:#N/A |
| ERROR:#N/A |
| ERROR:#N/A |
| ERROR:#N/A |
| ERROR:#N/A |
| ERROR:#N/A |
| ERROR:#N/A |
| ERROR:#N/A |
| ERROR:#N/A |
| ERROR:#N/A |
| ERROR:#N/A |
| ERROR:#N/A |
| ERROR:#N/A |