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.