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
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Algebra: Structure And Method, Book 1
Algebra
ISBN:
9780395977224
Author:
Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:
McDougal Littell
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Algebra: Structure And Method, Book 1
Algebra
ISBN:
9780395977224
Author:
Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:
McDougal Littell
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL