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...
-
Create a vector (name it vet C) that has 12 elements of which the first is 5, the increment is 4 and the last element is 49. Then, by assigning elements of vctC to new vectors, create the following...
-
What is multivalued dependency? When does it arise?
-
\(1,000 \div 5^{3}-7 \times 8^{4}\) Perform the indicated calculation.
-
Weather Balloons, Inc., makes reusable weather-detecting balloons. Because of a recent recession, management has ordered that standard costs be recomputed. New direct materials price standards are...
-
8:43 100 Q A EXERCISE 11-1 Importing and Exporting Journal Entries LO 4 Selco, a U.S. Company, imports and exports tools, shop equipment, and industrial construction supplies. The company uses a...
-
The half-life for a link on Twitter is 2.8 hours. Write an exponential function T that gives the percentage of engagements remaining on a typical Twitter link after 1 hours. Estimate this percentage...
-
On December 30, you decide to make a $2,900 charitable donation.(Assume you itemize your deductions.)If you are in the 22 percent tax bracket and you expectto itemize your deductions, how much will 1...
-
Consider the challenging conditions that you would face in the situation presented. What would your next step be in confronting the HR challenge faced by the hospital from a competitive standpoint?...
-
A SOP data given in the Excel file. By reading following information, answer appropriately to the questions a) For the data that you have, provide both level and chase. Discuss the main...
-
What mass (in grams) of sodium hydroxide (NaOH, molar mass = 40.0 g.mol-1) is needed to make 57.6 mL of a 0.122 M NaOH solution?
-
Using the scenario provided, respond to the critical-thinking questions. Scenario A nurse employed by a temporary agency is assigned to a neurology unit for a 12-hour shift. On arrival, she discovers...
-
Nykaa is an Indian e-commerce platform that specializes in beauty and wellness products. Founded in 2012 by Falguni Nayar, a former investment banker, the company has become one of the largest...
-
Tri-State Medical Equipment Corporation compra un nuevo caminde reparto grande y financia el 80% de la compra. El ingreso deesta transaccin en los libros de la empresa debe implicaradecuadament 1...
-
What is an access control list?
-
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...
-
Martin is sitting in his bedroom surrounded by dozens of papersgas receipts for his car, a checkbook, a couple of unopened and unpaid bills, paycheck stubs from his work at a day-care center, and...
-
How should you record your income on a cash flow statement?
-
Larrys personal balance sheet shows \($1,200\) in credit card debts; a savings account of \($550;\) and personal property amounting to \($3,700\) in rare stamps. Recently he was promoted at his...
Study smarter with the SolutionInn App