Do you need this or any other assignment done for you from scratch?
We have qualified writers to help you.
We assure you a quality paper that is 100% free from plagiarism and AI.
You can choose either format of your choice ( Apa, Mla, Havard, Chicago, or any other)
NB: We do not resell your papers. Upon ordering, we do an original paper exclusively for you.
NB: All your data is kept safe from the public.
Use the rubric attached bellow and follow the instructions.
Submission instructi
Use the rubric attached bellow and follow the instructions.
Submission instructions:
Turn in this assignment as a single Word document file (no pictures) by clicking on “Submit Assignment” located at the top right hand side of this page. You will need to create graphs using Excel then insert them into your Word document. Refer to the grading rubric for this assignment to see how you will be scored.
Assignment instructions:
The goal of this exercise is to prepare you for dealing with experimental data from an organic matter decomposition experiment, and demonstrate for you the importance of ‘quality’ and site conditions in determining rates of decomposition. Below the assignment instructions is a table of data for the decomposition of two types of plant material (Component A, Component B) which were both placed (using litter bags) at two different field sites (Site 1 and Site 2). Litter bags were retrieved during each sampling event and weighed after drying to determine the litter mass remaining (g) and samples were analyzed for total C content (TC as % dry wt) using elemental combustion.
Based on the data perform the following tasks:
1. Using Excel, make a graph (XY scatter, not a line graph) to show changes with time (x variable) in litter Mass Remaining (y variable). Using the Mass remaining plot, determine the decay constants (k) for each species type/site combination by using the ‘best fit line’ tool from Excel (select data series, right click and choose add trendline, exponential) to add an exponential fit curve through the Mass Remaining data. Be sure to have enough (at least 4) decimals in your fit equation to allow you to see differences between the constants for each line. You must state your k values. Put all four component/site combinations on each graph. Be sure to label your axes (with units), and label (legend) which symbol corresponds to each component/site combination (there should be 4 lines).
2. Similar to question 1, using Excel, make 2 graphs (XY scatter, not line graphs) to show changes with time (x variable) in TC (% dw), and the Total Mass (g) of C (must calculate as Litter Mass x TC%). There is no need to fit lines or show equations. Make one chart for each parameter (i.e., 2 graphs), and put all four component/site combinations on each graph. On the C% graph be sure to include 0 on the scale of the y-axis. Remember to label your axes (with appropriate units), and label (legend) which symbol corresponds to each component/site combination (there should be 4 data series).
** Based on the above analysis, answer the following questions:**
3. During decomposition, what is happening to the amount of C in the litter? Do the concentration (TC%) data show this? Why or Why not?
4. Which litter component is of a better ‘quality’ as we discussed in the course? What data support your conclusion, and what do you think could be responsible for the ‘quality’ differences….e.g., what plant part could each represent?
5. Which site is more conducive to decomposition? Compare the sites…..e.g., What variables/conditions (as discussed in lecture) could explain the differences between the sites?
Days of decompositionSite 1- Species ASite 2- Species ASite 1- Species BSite 2- Species B
———-Dry weight mass remaining (g) ———-
0100100100100
1697.198.190.795.3
3389.997.483.492.7
7577.89372.587.3
20459.886.748.675.3
33545.580.933.461.2
4543877.623.650.6
————Total C Content (% dw)————
039.6039.9943.2043.20
1640.1040.0543.0042.90
3340.5039.9043.4043.20
7540.1040.0042.8042.90
20439.8039.6043.1042.60
33540.0540.0243.2043.15
45440.0039.6043.2042.70
Do you need this or any other assignment done for you from scratch?
We have qualified writers to help you.
We assure you a quality paper that is 100% free from plagiarism and AI.
You can choose either format of your choice ( Apa, Mla, Havard, Chicago, or any other)
NB: We do not resell your papers. Upon ordering, we do an original paper exclusively for you.
NB: All your data is kept safe from the public.
Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount