In Excel, draw dominance-diversity curves with species of non-grass along the X-axis and In(p) along the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
In Excel, draw dominance-diversity curves with species of non-grass along the X-axis and In(p) along the Y-axis. In other words, make a line graph with natural log (In) proportion of cover on the vertical axis and the species ordered by abundance on the horizontal axis. Label the y-axis as the In proportion of non-grass cover and x-axis as non-grass species. You should have two lines, one for each lawn, on one graph. Make a caption for the graph that adds context and include how many different species were on each lawn. Add the Shannon index value in a text box above each line on the graph. Delete gridlines, but you can keep the legend that says which site is which. Change the colors if you want. Please answer the following questions in a text box in your excel file below your graph (be careful, text boxes in excel don't have spell check): 1. Compare the lines for the two lawns. Were the patterns similar or different in the two lawns? How so? 2. Did the two lawns that your class surveyed have similar or different species richnesses? Give the species richness of each lawn. (Species richness = # of different species represented; it is simply the species count) 3. Compare the two lawns' Shannon index values. Which lawn has more diversity of broad- leafed (non-grass) plants? (The higher the Shannon index value, the higher the species richness and evenness) Please upload your calculations, graph, caption, and brief answers to these 3 questions as an Excel Species Medicago lupulina (Black Medick) Cotula australis (Brass Buttons) Medicago polymorpha (Bur Medick) Malva parviflora (Little Mallow) Ssymbrium irio (London Rocket) Cyclospermum leptophyllum (Marsh Parlsey) Dichondra micrantha (Pony's Foot) Capsella bursapastoris (Shepherd's Purse) Oxalis corniculata (Sorrel) Sonchus oleraceus (Sow Thistle) Veronica arvensis (Speedwell) Trifolium fragiferum (Strawberry Clover) Lepidium didymum (Swine Cress) Trifolium repens (White Clover) Unknown Grass Bare Ground Total Individuals Disturbed p (Proportion) In(p) (Natural Log Proportion) 7 1 2 0 0 0 16 0 1 1 3 29 0 218 0 184 18 480 ■ Species Medicago lupulina (Black Medick) Cotula australis (Brass Buttons) Medicago polymorpha (Bur Medick) Malva parviflora (Little Mallow) Ssymbrium irio (London Rocket) Cyclospermum leptophyllum (Marsh Parlsey) Dichondra micrantha (Pony's Foot) Capsella bursapastoris (Shepherd's Purse) Oxalis corniculata (Sorrel) Sonchus oleraceus (Sow Thistle) Veronica arvensis (Speedwell) Trifolium fragiferum (Strawberry Clover) Lepidium didymum (Swine Cress) Trifolium repens (White Clover) Unknown Grass Bare Ground Total Individuals Undisturbed p (Proportion) In(p) (Natural Log Proportion) 32 0 2 22 1 31 0 9 0 1 3 64 10 48 1 192 64 480 In Excel, draw dominance-diversity curves with species of non-grass along the X-axis and In(p) along the Y-axis. In other words, make a line graph with natural log (In) proportion of cover on the vertical axis and the species ordered by abundance on the horizontal axis. Label the y-axis as the In proportion of non-grass cover and x-axis as non-grass species. You should have two lines, one for each lawn, on one graph. Make a caption for the graph that adds context and include how many different species were on each lawn. Add the Shannon index value in a text box above each line on the graph. Delete gridlines, but you can keep the legend that says which site is which. Change the colors if you want. Please answer the following questions in a text box in your excel file below your graph (be careful, text boxes in excel don't have spell check): 1. Compare the lines for the two lawns. Were the patterns similar or different in the two lawns? How so? 2. Did the two lawns that your class surveyed have similar or different species richnesses? Give the species richness of each lawn. (Species richness = # of different species represented; it is simply the species count) 3. Compare the two lawns' Shannon index values. Which lawn has more diversity of broad- leafed (non-grass) plants? (The higher the Shannon index value, the higher the species richness and evenness) Please upload your calculations, graph, caption, and brief answers to these 3 questions as an Excel Species Medicago lupulina (Black Medick) Cotula australis (Brass Buttons) Medicago polymorpha (Bur Medick) Malva parviflora (Little Mallow) Ssymbrium irio (London Rocket) Cyclospermum leptophyllum (Marsh Parlsey) Dichondra micrantha (Pony's Foot) Capsella bursapastoris (Shepherd's Purse) Oxalis corniculata (Sorrel) Sonchus oleraceus (Sow Thistle) Veronica arvensis (Speedwell) Trifolium fragiferum (Strawberry Clover) Lepidium didymum (Swine Cress) Trifolium repens (White Clover) Unknown Grass Bare Ground Total Individuals Disturbed p (Proportion) In(p) (Natural Log Proportion) 7 1 2 0 0 0 16 0 1 1 3 29 0 218 0 184 18 480 ■ Species Medicago lupulina (Black Medick) Cotula australis (Brass Buttons) Medicago polymorpha (Bur Medick) Malva parviflora (Little Mallow) Ssymbrium irio (London Rocket) Cyclospermum leptophyllum (Marsh Parlsey) Dichondra micrantha (Pony's Foot) Capsella bursapastoris (Shepherd's Purse) Oxalis corniculata (Sorrel) Sonchus oleraceus (Sow Thistle) Veronica arvensis (Speedwell) Trifolium fragiferum (Strawberry Clover) Lepidium didymum (Swine Cress) Trifolium repens (White Clover) Unknown Grass Bare Ground Total Individuals Undisturbed p (Proportion) In(p) (Natural Log Proportion) 32 0 2 22 1 31 0 9 0 1 3 64 10 48 1 192 64 480
Expert Answer:
Answer rating: 100% (QA)
The highest proportion of injuries resulting in tarsal fractures was observed for the 02 mm layer Th... View the full answer
Related Book For
Managerial Accounting An Introduction to Concepts Methods and Uses
ISBN: 978-0324639766
10th Edition
Authors: Michael W. Maher, Clyde P. Stickney, Roman L. Weil
Posted Date:
Students also viewed these accounting questions
-
What is the ethics of care? a. What unethical actions by the wrongdoers and their supporters in the 1MDB scandal case have violated the ethics of care? b. How have the unethical actions by the...
-
Read Case Problem Where's My Cart? Write a 1,050- to 1,400-word paper in which you address the following questions: Identify waste in the current production process. How does the pager suggest you...
-
In problem 3.1 at the end of Chapter 3, you calculated measures of central tendency for six variables for freshman and seniors. Three of those variables are reproduced here. Calculate the mean (if...
-
1. A projectile is launched in a vertical plane, at an angle 0 with initial velocity vo. It must be caught in a frictionless circular tube of radius R in such a way that the trajectory of the...
-
Tort claims survive the death of the tortfeasor, and the damages are payable from the wrongdoer's estate. Assume a wrongdoer commits a tort that meets the requirements for punitive damages, but...
-
At a given temperature and pressure, do you think the mass diffusivity of air in water vapor will be equal to the mass diffusivity of water vapor in air? Explain.
-
Hassink Housewares Ltd produces furniture and is evaluating the purchase of a new machine that will cost \($1\) 138 200 and have no residual value. Annual net cash inflows (including tax payments)...
-
Theory of constraints, contribution margin , sensitivity analysis. Fun Time Toys (FTT) produces dolls in two processes: molding and assembly. FTT is currently producing two models: Chatty Chelsey and...
-
What is the purpose of the Fed's Discount Window that offers the Discount Rate?
-
When selecting a cloud vendor to host your enterprise data and apps, you need to evaluate the service level agreement (SLA). a.Research the SLAs of two cloud vendors, such as Rackspace, Amazon, or...
-
). Sketch the following planes (101), (121), (100), (011), (001).
-
Research and post your findings on the differences between Linux and Unix operating systems.?
-
Explain the relationship between media industries and 'ideology'. Do mediareinforce or contest the dominant ideology of our times? Please provide an example that support your answer.
-
State the three motivating criteria that define information entropy. Try to express each in your own words? Suppose a coin is weighted such that, when it is tossed and lands on a table, it comes up...
-
What is the intended goal of the visualization? Does it accomplish this? Why? Do you think the visualization is effective in displaying the data? Why? Is there anything to improve upon? Why? What...
-
What are the two types of modes the VI text editor in the UNIX operating system?
-
I really need help with number 13. Below is my scanner.l file and my tokens.h file, it will not compile the way it needs to. I need to know how to format it in my scanner.l file under char_literals. ...
-
What are the risks and liability factors in an audit? What are the implications to the auditor? What are the implications to the organization? How can the auditor mitigate these risks and liability...
-
Because of high sales for July, Radios, Inc., a producer of two-way radios, plans to produce and sell 20,000 radios, using all available capacity. Managers at Radios, Inc., anticipates costs for the...
-
What are the three most important elements of service for each of the following products? a. Bridal gown b. Refrigerator c. English course at a university d. Cruise on a Princess ship e. Freshly...
-
Regis Corporation, a manufacturer of vases to hold flowers, decided in October Year 1 that it needed cash to continue operations. It began negotiating for a one-month bank loan of $100,000 starting...
-
Describe which characteristics of HR metrics and workforce analytics are likely to result in greater return on investment and organizational impact.
-
Why are information security and privacy important considerations in the design, development, and maintenance of an HRIS?
-
List and discuss the major information security and privacy threats to organizations.
Study smarter with the SolutionInn App