Diana_Cuevas_The_Homecoming_Workbook

xlsx

School

Arizona State University *

*We aren’t endorsed by this school

Course

BIO 182

Subject

Statistics

Date

Feb 20, 2024

Type

xlsx

Pages

21

Uploaded by DoctorCloverGorilla182

Report
tree ID Presence of a novel symbiont Growth rate of a tree (cm/d) 1 present 0.044 2 present 0.035 3 present 0.053 4 present 0.035 5 present 0.021 6 present 0.033 7 present 0.026 8 present 0.024 9 present 0.046 10 present 0.022 11 present 0.033 12 present 0.043 13 present 0.053 14 present 0.037 15 present 0.028 16 present 0.056 17 present 0.048 18 present 0.060 19 present 0.041 20 present 0.012 21 present 0.012 22 present 0.048 23 present 0.016 24 present 0.027 25 present 0.027 26 present 0.033 27 present 0.026 28 present 0.038 29 present 0.019 30 present 0.041 31 present 0.046 32 present 0.059 33 present 0.039 34 present 0.047 35 present 0.030 36 present 0.025 37 present 0.041 38 present 0.032 39 present 0.045 40 present 0.017 41 present 0.029 42 present 0.028 43 present 0.050 44 present 0.001
45 present 0.032 46 present 0.044 47 present 0.034 48 present 0.033 49 absent 0.017 50 absent 0.017 51 absent 0.016 52 absent 0.003 53 absent 0.003 54 absent 0.011 55 absent 0.015 56 absent 0.009 57 absent 0.011 58 absent 0.009 59 absent 0.005 60 absent 0.017 61 absent 0.016 62 absent 0.014 63 absent 0.017 64 absent 0.011 65 absent 0.007 66 absent 0.012 67 absent 0.024 68 absent 0.004 69 absent 0.001 70 absent 0.018 71 absent 0.013 72 absent 0.014 73 absent 0.010 74 absent 0.012 75 absent 0.003 76 absent 0.022 77 absent 0.018 78 absent 0.005 79 absent 0.015 80 absent 0.031 81 absent 0.017 82 absent 0.006 83 absent 0.020 84 absent 0.010 85 absent 0.009 86 absent 0.011 87 absent 0.015 88 absent 0.014 89 absent 0.014
90 absent 0.024 91 absent 0.006 92 absent 0.018 93 absent 0.008 94 absent 0.008 95 absent 0.000 96 absent 0.029
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
The data in this sheet will be used for assignment questions 1-4. Use the Excel sheet (tab) labeled " Question 1 " for all calculations, modeling, and graphing.
tree ID Presence of a novel symbiont Growth rate of a tree (cm/d) dummy Absent 1 present 0.044 1 Mean 0.013 2 present 0.035 1 SD 0.007 3 present 0.053 1 4 present 0.035 1 A -0.00012 5 present 0.021 1 B 0.0088 6 present 0.033 1 C -0.1372 7 present 0.026 1 8 present 0.024 1 #5 0.017 9 present 0.046 1 #6 0.005 10 present 0.022 1 11 present 0.033 1 12 present 0.043 1 13 present 0.053 1 14 present 0.037 1 15 present 0.028 1 16 present 0.056 1 17 present 0.048 1 18 present 0.060 1 19 present 0.041 1 20 present 0.012 1 21 present 0.012 1 22 present 0.048 1 23 present 0.016 1 24 present 0.027 1 25 present 0.027 1 26 present 0.033 1 27 present 0.026 1 28 present 0.038 1 29 present 0.019 1 30 present 0.041 1 31 present 0.046 1 32 present 0.059 1 33 present 0.039 1 34 present 0.047 1 35 present 0.030 1 36 present 0.025 1 37 present 0.041 1 38 present 0.032 1 39 present 0.045 1 40 present 0.017 1 41 present 0.029 1 42 present 0.028 1 43 present 0.050 1 44 present 0.001 1 0.000 0.005 0.010 0.015 0.020 0.025 0.030 0.035 0.040 0.045 0.050 Growth rate of a tree (cm d-1)
45 present 0.032 1 46 present 0.044 1 47 present 0.034 1 48 present 0.033 1 49 absent 0.017 0 50 absent 0.017 0 51 absent 0.016 0 52 absent 0.003 0 53 absent 0.003 0 54 absent 0.011 0 55 absent 0.015 0 56 absent 0.009 0 57 absent 0.011 0 58 absent 0.009 0 59 absent 0.005 0 60 absent 0.017 0 61 absent 0.016 0 62 absent 0.014 0 63 absent 0.017 0 64 absent 0.011 0 65 absent 0.007 0 66 absent 0.012 0 67 absent 0.024 0 68 absent 0.004 0 69 absent 0.001 0 70 absent 0.018 0 71 absent 0.013 0 72 absent 0.014 0 73 absent 0.010 0 74 absent 0.012 0 75 absent 0.003 0 76 absent 0.022 0 77 absent 0.018 0 78 absent 0.005 0 79 absent 0.015 0 80 absent 0.031 0 81 absent 0.017 0 82 absent 0.006 0 83 absent 0.020 0 84 absent 0.010 0 85 absent 0.009 0 86 absent 0.011 0 87 absent 0.015 0 88 absent 0.014 0 89 absent 0.014 0
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
90 absent 0.024 0 91 absent 0.006 0 92 absent 0.018 0 93 absent 0.008 0 94 absent 0.008 0 95 absent 0.000 0 96 absent 0.029 0
Present 0.035 0.013 For questions 1-4, refer to the sheet ( labeled “ DATA- Growth of ruil trees ,” trees in the presence or absence of a trees per treatment). Use this Excel sheet for calculations, m calculated values to the nearest thous example, if you calculate the value as Refer to the lab packet document for instructions. Absent Present Presence of a novel symbiont
(tab) in this Excel workbook ” containing the growth rate of ruil novel symbiont (sample size = 48 modeling, and graphing. Round all sandth of a decimal place. For s 3.8218, round to 3.822. specific Excel formatting
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
Soil moisture (%) Per capita rate of change (ruils/ruil/y) 15 0.005 20 0.017 25 0.022 30 0.026 35 0.020 40 0.036 45 0.021 50 4.154E-05
The data in this sheet will be used for assignment questions 7-9. Use the Excel sheet (tab) labeled " Question 7 " for all calculations, modeling, and graphing.
Soil moisture (%) Per capita rate of change (ruils/ruil/y) 15 0.005 A -8.00E-05 20 0.017 B 0.0053 25 0.022 C -0.0582 30 0.026 35 0.020 #8 2.82E-02 0.028 29% 40 0.036 #9 2.29E-02 0.023 24% 45 0.021 50 4.154E-05 10 15 20 25 30 35 40 45 50 -0.040 -0.030 -0.020 -0.010 0.000 0.010 0.020 0.030 0.040 f(x) = − 8.07582608704085E-05 x² + 0.005306616217482 x − 0.05819606555635 Soil moisture (%) Per capita rate of change (ruils/ruil/y)
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
For questions 7-9, refer to the sheet ( labeled “ DATA- Symbiont present ,” co capita rates of change for 8 populatio populations). Use this Excel sheet for calculations, m calculated values to the nearest thou example, if you calculate the value as Refer to the lab packet document for instructions. 55
(tab) in this Excel workbook ontaining soil moistures and per ons of ruil trees (sample size = 8 modeling, and graphing. Round all usandth of a decimal place. For s 3.8218, round to 3.822. r specific Excel formatting
Year Number of trees 0 20985 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 The data in this sheet will be u Use the Excel sheet (tab) labe modeling, 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
44 45 46 47 48 49 50
used for assignment questions 12-13. eled " Question 13 " for all calculations,
Year Number of trees 0 20985 1 21468 2 21961 3 22467 4 22983 5 23512 6 24053 7 24606 8 25172 9 25751 10 26343 11 26949 12 27569 13 28203 14 28851 15 29515 16 30194 17 30888 18 31599 19 32326 20 33069 21 33830 22 34608 23 35404 24 36218 25 37051 26 37903 27 38775 28 39667 29 40579 30 41512 31 42467 32 43444 33 44443 34 45465 35 46511 36 47581 37 48675 38 49795 39 50940 40 52112 41 53310 42 54536 43 55791
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
44 57074 45 58387 46 59729 47 61103 48 62509 49 63946 50 65417
For questions 12-13, refer to the sheet (tab) in this E labeled “ DATA- Ruil population size ,” containing the the population at present (time = 0). Assume a per c change (r) equal to the per capita rate of change you population of ruil trees when the novel symbiont is p moisture is 25%. Use this Excel sheet for calculations, modeling, and g calculated values to the nearest whole number. For e calculate the value as 3.8215, round to 4.
Excel workbook e number of ruils in capita rate of u estimated for a present and the soil graphing. Round all example, if you
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