Diana_Cuevas_A_Tangled_Web_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

27

Uploaded by DoctorCloverGorilla182

Report
Historical densities of trees (m2 per km2) 27948 28496 24621 26349 26987 28287 27058 26814 28012 28626 28042 26806 28373 27248 26907 25527 27102 26370 26808 28259 26898 26383 26342 24866 25701 27721 26186 27426 26609 26896 27157 The data in this sheet will be u Use the Excel sheets (tabs) lab all calculations, modeling, and
used for assignment questions 1-4. beled " Question 3 " and " Question 4 " for d graphing.
For question 3 Umbrella tree 31). Complete the "Question 3" E or PDF and cop Refer to the la
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, refer to the sheet (tab) in this Excel workbook labeled “ DATA- e densities ,” containing historical densities of umbrella trees (N = bar plots shown below and add your two bar plots to this Excel sheet when done. These plots should be formatted as a JPG py/pasted into this sheet. ab packet document for specific instructions.
Historical densities of trees (m2 per km2) Historical densities of trees (m2 per km2) 27948 24621 28496 24866 24621 25527 26349 25701 26987 26186 28287 26342 27058 26349 26814 26370 28012 26383 28626 26609 28042 26806 26806 26808 28373 26814 27248 26896 26907 26898 25527 26907 27102 26987 26370 27058 26808 27102 28259 27157 26898 27248 26383 27426 26342 27721 24866 27948 25701 28012 27721 28042 26186 28259 27426 28287 26609 28373 26896 28496 27157 28626
values bins frequency 23000-24000 24000 0 24000-25000 25000 2 25000-26000 26000 2 26000-27000 27000 13 27000-28000 28000 7 28000-29000 29000 7 For question 4, refer to the sheet (tab DATA- Umbrella tree densities ,” con umbrella trees (N = 31). Use this Excel sheet for calculations, m calculated values to the nearest whol calculate the value as 3.8218, round t Refer to the lab packet document for instructions. 23000- 24000 24000- 25000 25000- 26000 26000- 27000 27000- 28000 28000- 29000 0 2 4 6 8 10 12 14 Frequency distribution of historical densities (m2/km2) of umbrella trees Density (m2/km2)” 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
b) in this Excel workbook labeled ntaining historical densities of modeling, and graphing. Round all le number. For example, if you to 4. r specific Excel formatting
Historical densities of gliders (per km2) 409.4 377.9 415.2 361.7 478.0 307.1 399.3 380.8 398.3 324.1 428.0 503.8 365.3 322.4 409.7 396.0 456.9 348.4 465.4 419.5 401.1 433.6 530.6 428.4 383.6 385.2 386.8 359.5 478.1 455.6 392.0 383.4 418.4 420.9 444.8 425.3 312.3 372.3 367.3 462.9 344.3 403.9 428.1 426.1 The data in this sheet will be u 17. Use the Excel sheets (tabs) lab for all calculations, modeling,
450.2 394.2 352.3 456.3 387.0 365.3 450.1 471.8 407.3 405.3 451.7 433.5 394.8 415.2 399.5 332.6 420.3 476.1 413.8 417.4 355.1 469.6 282.2 373.7 513.1 398.1 322.5 421.1 427.5 467.2 293.6 342.8 440.6 390.0 297.3 408.9 409.5 367.2 430.5 390.2 303.4 418.1 418.0 351.8 356.9
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
327.5 406.9 329.7 407.5 417.6 442.0 336.7 398.7 448.5 383.3 268.9
used for assignment questions 13-15 and beled " Question 15 " and " Question 17 " , and graphing.
For question 1 Spotted glider 100). Complete the "Question 15" JPG or PDF and Refer to the la
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
15, refer to the sheet (tab) in this Excel workbook labeled “ DATA- r densities ,” containing historical densities of spotted gliders (N = bar plots shown below and add your two bar plots to this " Excel sheet when done. These plots should be formatted as a d copy/pasted into this sheet. ab packet document for specific instructions.
Historical densities of gliders (per km2) Historical densities of gliders (per km2) 409.4 268.9 bins 377.9 282.2 250-300 415.2 293.6 300-350 361.7 297.3 350-400 478.0 303.4 400-450 307.1 307.1 450-500 399.3 312.3 500-550 380.8 322.4 398.3 322.5 324.1 324.1 428.0 327.5 503.8 329.7 365.3 332.6 322.4 336.7 409.7 342.8 396.0 344.3 456.9 348.4 348.4 351.8 465.4 352.3 419.5 355.1 401.1 356.9 433.6 359.5 530.6 361.7 428.4 365.3 383.6 365.3 385.2 367.2 386.8 367.3 359.5 372.3 478.1 373.7 455.6 377.9 392.0 380.8 383.4 383.3 418.4 383.4 420.9 383.6 444.8 385.2 425.3 386.8 312.3 387.0 372.3 390.0 367.3 390.2 462.9 392.0 344.3 394.2 403.9 394.8 428.1 396.0 426.1 398.1 0 5 10 15 20 25 30 35 40 Frequ uals/k Frequency
450.2 398.3 394.2 398.7 352.3 399.3 456.3 399.5 387.0 401.1 365.3 403.9 450.1 405.3 471.8 406.9 407.3 407.3 405.3 407.5 451.7 408.9 433.5 409.4 394.8 409.5 415.2 409.7 399.5 413.8 332.6 415.2 420.3 415.2 476.1 417.4 413.8 417.6 417.4 418.0 355.1 418.1 469.6 418.4 282.2 419.5 373.7 420.3 513.1 420.9 398.1 421.1 322.5 425.3 421.1 426.1 427.5 427.5 467.2 428.0 293.6 428.1 342.8 428.4 440.6 430.5 390.0 433.5 297.3 433.6 408.9 440.6 409.5 442.0 367.2 444.8 430.5 448.5 390.2 450.1 303.4 450.2 418.1 451.7 418.0 455.6 351.8 456.3 356.9 456.9
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
327.5 462.9 406.9 465.4 329.7 467.2 407.5 469.6 417.6 471.8 442.0 476.1 336.7 478.0 398.7 478.1 448.5 503.8 383.3 513.1 268.9 530.6
values frequency 300 4 350 13 400 31 450 35 500 14 550 3 0 For question 17, refer to the sheet (tab) in th DATA- Spotted glider densities ,” containing spotted gliders (N = 100). Use this Excel sheet for calculations, modelin calculated values to the nearest tenth of a de if you calculate the value as 3.8218, round to Refer to the lab packet document for specific instructions.v 250-300 300-350 350-400 400-450 450-500 500-550 0 5 0 5 0 5 0 5 0 uency distribution of historical densities (individ- km2) of spotted gliders Density (individuals/km2)”
his Excel workbook labeled historical densities of ng, and graphing. Round all ecimal place. For example, o 3.8. c 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
boreblaster daggerjaw flamster frogcat boreblaster daggerjaw flamster frogcat grabbins legs lyrac ridgehead sonar x x spotted gliders x torch umbrella tree boreblaster: daggerjaw: flamster: frogcat: 1 0 1 1 Potential predators Number of predators for: (do NOT adjust; this will auto-calculate) For question 28, use the matrix above to show the connections between p In this matrix, potential predators are listed in rows and potential prey are in the columns that reflect known species of prey (based on the Field Gu Leave a cell blank if no evidence of predation exists in the Field Guide of A Example: if the field guide indicated daggerjaws as being predators of bore
grabbins legs lyrac ridgehead sonar spotted gliders x x x x x x grabbins: legs: lyrac: ridgehead: sonar: spotted gliders: 0 1 2 1 1 1 Potential prey predators and prey in the Allurian Forest community. e listed in columns. For each potential predator, place an “X” uide). Alluria. eblasters, you would add an "X" to cell C4 in this matrix.
torch umbrella tree x boreblaster: 1 daggerjaw: 3 flamster: 1 frogcat: 1 grabbins: 1 x legs: 1 lyrac: 0 x ridgehead: 1 sonar: 2 x spotted gliders: 2 torch: 0 umbrella tree: 0 torch: umbrella tree: 1 3 Number of prey for: (do NOT adjust; this will auto-calculate)
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
Ridgehead Grabbins Spotted gliders Boreblaster Umbrella trees For question 29, use the blank food web above to illustrate the flow o the Allurian Forest community. Arrows indicate the direction that energy flows, from species of prey of predators. Click on each blank box above to select the appropriat from the dropdown menu. Use your answers from the matrix in question 28 to help guide your w Each Allurian Forest species will be used once in this food web.
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
Daggerjaw Sonar Legs Frogcat Torch Lyrac of energy between each species in to species te species work. Screenshot showing a dropdown menu
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
Flamster
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
Ridgehead - Grabbins - Spotted gliders + Boreblaster Umbrella trees - For question 32, use the food web above to illustrate the the direct and in relationships. To help you get started, your answers have been copied ove Step 1: Take the blue arrow located to the right of this text box and posi believe has started preying on grabbins. You may reposition and adjust th Step 2: Click on the blank box to the right of each species, and select eit from the dropdown menu, to indicate the direct and indirect effects of t relationship. Select a "+" next to species whose abundance should increa predator of grabbins. Place a "-" next to species whose abundance should new predator of grabbins. If you think a species' abundance will remain th to that box.
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
Daggerjaw + - Legs - Frogcat - Torch + ndirect effects of changes to predator-prey er from the "Question 29" sheet. ition it to point from the grabbins to the species you he size of the arrow as needed. ther a "+" or "-" symbol this new predator-prey ase because of the new d decrease because of the he same, place a "0" next Screenshot showing a dropdown menu
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
Sonar + Flamster - Lyrac + Use this arrow, repositioning and resizing it as needed for Step 1:
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