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...
-
Suppose that we need a way of computing whether the number of bits in a 32-bit word is odd or even. Devise an algorithm for performing this computation as fast as possible. You may use up to 256 KB...
-
30. Figure shows two plane mirrors parallel to each other and an object O placed between them. Then the distance of the first three images from the mirror M2 will be: (in cm) 5cm 15cm M (1) 5, 10, 15...
-
Describe the purpose and process of utilization review.
-
How does perception affect behavior?
-
Sarif is interested in an alternative investment strategy fund with an investment mandate focused on anticipating movements in the market prices of commodities. What type of strategy would this type...
-
Kansas Corp., an American company, has a payment of 5 million due to Tuscany Corp. one year from today. At the prevailing spot rate of 0.90 /$, this would cost Kansas $5,555,556, but Kansas faces the...
-
Larry's tax basis in his partnership interest at the beginning of the year was $27,500. If his share of the partnership debt increased by $13,000 during the year and his share of partnership income...
-
16. 17. 18. 19. 20. A hydraulic system contains one small piston with an area of 2 sq. in. and one large piston with an area of 10 sq. in. If a force of 70 pounds is applied to the small piston, what...
-
A force is given as F=-yzi -xzj-xyk (a) Show that this force is conservative. (b) Calculate the corresponding potential energy V as a function of x, y, and z. (c) Show that the mechanical energy E...
-
A 4-kg block moves down a rough 37 incline a distance of 5 m from point A to point B. As shown in the figure below, a horizontal force of magnitude F = 10 N is applied to the block between these two...
-
Two metal rods, one silver and the other copper, are both attached to a steam chamber as shown in the figure, with a temperature of 100C, at one end, and an ice water bath, with a temperature of 0C,...
-
In which direction does the orange gear wheel rotate when the blue one is rotated in the direction of the arrow? in the same direction as the green one in the same direction as the red one in the...
-
Image transcription text How do remarkable checks and stores on the way influence the bank compromise process? 6. What are a few normal reasons for inconsistencies between the bank proclamation and...
-
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...
-
The following are summaries of the cash book and bank accounts of J. Duncan who does not keep his books using the double entry system. You are required to: (a) Calculate the value of J. Duncan's...
-
Read the following and answer the questions below. On 31 December 2015 the bank column of C. Tench's cash book showed a debit balance of 1,500. The monthly bank statement written up to 31 December...
-
The bank columns in the cash book for June 2016 and the bank statement for that month for D. Hogan are as follows: You are required to: () Write the cash book up to date to take the above into...
Study smarter with the SolutionInn App