In: Math
Plot | Nutrients added | # of species |
1 | 0 | 36 |
2 | 0 | 36 |
3 | 0 | 32 |
4 | 1 | 34 |
5 | 2 | 33 |
6 | 3 | 30 |
7 | 1 | 20 |
8 | 3 | 23 |
9 | 4 | 21 |
10 | 4 | 16 |
What effect do nutrient additions have on plant species diversity? Long-term experiments at the Rothamstead Experimental Station in the U.K. sought to investigate the relationship, with some interesting findings.
The data can be found in the linked Google Sheets
document - you'll want to copy it to Excel and use the
Data Analysis ToolPak.
1) Produce a scatter plot of the data (click here for a generic
youtube video on creating a scatter plot from excel data - this is
for informational purposes only - it's not your data)
2) Add the least-squares regression line to your scatter plot. (click here for a generic youtube video on adding trendlines to scatter plots - this is for informational purposes only - it's not your data)
3) Test the hypothesis of no treatment effect on the number of plant species.