Veronica_Perez_Act_III_The_Hatching_Workbook (1)

xlsx

School

Arizona State University *

*We aren’t endorsed by this school

Course

181

Subject

Statistics

Date

Feb 20, 2024

Type

xlsx

Pages

26

Uploaded by DrElement444

Report
Prey density (prey/km2) Growth rate (owls/year) 17198 0.34 16509 -0.56 18739 0.01 17203 -0.49 13792 -0.42 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 The data in this sheet will be used for assignment qu Use the Excel sheet (tab) labeled " Question 3 " for al calculations, modeling, and graphing. 5000 10000 15000 -1.50 -1.00 -0.50 0.00 0.50 1.00 1.50 2.00 Prey Density vs. O Growth rate (owls/year)
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 -2.00 -1.50 Pr
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
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
22740 0.12 17079 -0.16 18647 0.73 20039 0.73 11705 -1.09
uestion 3. ll 20000 25000 30000 35000 Owl population
rey Density (prey/km2)”
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Prey density (prey/km2) Growth rate (owls/year) 17198 0.34 16509 -0.56 18739 0.01 17203 -0.49 13792 -0.42 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 Create a single plot of a linear relationship between the prey density and the growth rat both populations from 1971 to 2020. Refer to the lab packet for formatting and rounding instructions. 5000 10000 15000 20000 -1.00 -0.50 0.00 0.50 1.00 1.50 2.00 Prey Density vs. Owl po Growth rate (owls/year)
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 Formula Column1 22583 -0.19 Slope 0.000108 14589 -1.16 Intercept -2.07717 20298 -0.63 SD 0.609421 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 -2.00 -1.50 -1.00 Prey D
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
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
22740 0.12 17079 -0.16 18647 0.73 20039 0.73 11705 -1.09
te of 0 25000 30000 35000 opulation
Density (prey/km2)”
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Year Population A Prey density (prey/km2) Population B Prey density (prey/km2) 1971 17198 17299 1972 16509 19105 1973 18739 13957 1974 17203 15910 1975 13792 21505 1976 20485 29552 1977 17255 24082 1978 17614 26588 1979 21289 13769 1980 21794 19077 1981 15045 15201 1982 21098 15786 1983 18849 22658 1984 11368 18688 1985 21337 16926 1986 19907 14443 1987 15496 21627 1988 16113 16567 1989 17048 17487 1990 13569 21201 1991 15517 22389 1992 13531 9973 1993 16950 18282 1994 18271 26543 1995 18376 23181 1996 17046 16335 1997 21931 16124 1998 19111 26146 1999 21015 18771 2000 19202 19206 2001 20598 19418 The data in this she questions 8-13 and Use the Excel shee density " and " Q14 calculations, mode
2002 18776 16166 2003 17604 24332 2004 12342 15757 2005 15574 16922 2006 15002 19531 2007 21681 23037 2008 14914 15640 2009 15157 23886 2010 16567 21201 2011 21123 21493 2012 18010 15626 2013 20701 17134 2014 21264 19717 2015 22583 15755 2016 14589 22740 2017 20298 17079 2018 20290 18647 2019 16494 20039 2020 11376 11705
eet will be used for assignment d 14-19. ets (tabs) labeled " Q8-13 Pop A prey 4-19 Pop B prey density " for all eling, and graphing.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Year Population A Prey density (prey/km2) 1984 11368 2020 11376 2004 12342 1992 13531 1990 13569 1975 13792 2016 14589 2008 14914 2006 15002 1981 15045 2009 15157 1987 15496 1991 15517 2005 15574 1988 16113 2019 16494 Column1 Column2 1972 16509 Mean 17752 2010 16567 SD 2924.69858 1993 16950 Median 17609 1996 17046 Min 11368 1989 17048 Max 22583 1971 17198 1974 17203 1977 17255 2003 17604 1978 17614 bins Bina Frequency 2012 18010 11,000 bins Frequency 1994 18271 12,000 11,000 0 1995 18376 13,000 12,000 2 1973 18739 14,000 13,000 1 2002 18776 15,000 14,000 3 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-13. Use this Excel sheet for calculations. Round all calculated values to the nearest whole number . For example, if you calculate the value as 3.8218, round to 4. 3 4 5 6 7 8 9 10 Frequency
1983 18849 16,000 15,000 2 1998 19111 17,000 16,000 6 2000 19202 18,000 17,000 5 1986 19907 19,000 18,000 7 2018 20290 20,000 19,000 6 2017 20298 21,000 20,000 3 1976 20485 22,000 21,000 5 2001 20598 23,000 22,000 9 2013 20701 23,000 1 1999 21015 More 0 1982 21098 2011 21123 2014 21264 1979 21289 1985 21337 2007 21681 1980 21794 1997 21931 2015 22583 0 1 2 3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
3 4 5 6 7 8 9 0 Population A from 1971-2020 Frequency
11,000 12,000 13,000 14,000 15,000 16,000 17,000 18,000 19,000 20,000 21,000 22,000 23,000 More 0 1 2 3 Prey A Density (Prey/km2)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Year Population B Prey density (prey/km2) 1971 17299 1972 19105 1973 13957 1974 15910 1975 21505 1976 29552 1977 24082 1978 26588 1979 13769 1980 19077 1981 15201 1982 15786 1983 22658 1984 18688 1985 16926 1986 14443 Column1 Column2 1987 21627 1988 16567 Mean 19084 1989 17487 Min 9973 1990 21201 Max 29552 1991 22389 SD 4030.151 1992 9973 Median 18729 1993 18282 1994 26543 1995 23181 Bins Bins Frequency 1996 16335 11,000 11000 1 1997 16124 12,000 12000 1 1998 26146 13,000 13000 0 1999 18771 14,000 14000 2 2000 19206 15,000 15000 1 2001 19418 16,000 16000 7 Use the raw data for the prey densities of Population B from 1971 to 2020 (sample size = 50 years) in this tab to perform probability calculations. These are for questions 14-19. Use this Excel sheet for calculations. Round all calculated values to the nearest whole number . For example, if you calculate the value as 3.8218, round to 4. 3 4 5 6 7 8 9 10 Popu Frequency
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
2002 16166 17,000 17000 6 2003 24332 18,000 18000 4 2004 15757 19,000 19000 4 2005 16922 20,000 20000 6 2006 19531 21,000 21000 1 2007 23037 22,000 22000 5 2008 15640 23,000 23000 3 2009 23886 More 9 2010 21201 2011 21493 2012 15626 2013 17134 2014 19717 2015 15755 2016 22740 2017 17079 2018 18647 2019 20039 2020 11705 11000 12000 13000 14000 15000 0 1 2 3 Populatio
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
ulation B from 1971-2020 Frequency
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
16000 17000 18000 19000 20000 21000 22000 23000 More on B Prey density (prey/km2)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Column E Count of bins 11,000 1 12,000 1 13,000 1 14,000 1 15,000 1 16,000 1 bins 1 Total Result 7
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help