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 |<<
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 |<<
Oh no! Our experts couldn't answer your question.
Don't worry! We won't leave you hanging. Plus, we're giving you back one question for the inconvenience.
Submit your question and receive a step-by-step explanation from our experts in as fast as 30 minutes.
You have no more questions left.
Message from our expert:
It looks like you may have submitted a graded question that, per our Honor Code, experts cannot answer. We've credited a question to your account.
Your Question:
Recommended textbooks for you
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL