biology 181

profileshameeka44
LastName_FirstName_SR_Act_3_Workbook1.xlsx

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