Section 2. The accompanied data is a part of a dataset of measured phosphorus amount (kilograms/hectare/year) by watershed. We want to test whether the mean phosphorus amount is greater than 0.55 kilograms/hectare/year. Using the provided Excel spreadsheet, calculate and report an appropriate test statistic and p-value. (10 pts.) Test statistic: P-value: Source: U.S. Environmental Protection Agency (2016) Total phosphorus in surface water. https://catalog.data.gov/dataset/total-phosphorus-in-surface-water (accessed 7/14/2020) paste your data in this Use this sheet to perform a 1-sample t-test. COUNT MEAN #DIV/0! STANDARD DEVIATION 0.00 #DIV/0! STANDARD ERROR #DIV/0! Confidence Interval 95% Level of Significance 0.05 HYPOTHESIS TEST t-VALUE t-critical #NUM! HYPOTHESIS TEST RESULTS proposed population mean |<<