3. Suppose you are studying the distribution of zinc in a lake and want to know if there is a significant difference between the concentration of Zn²+ at the sediment-water interface and its concentration at the air-water interface. You collect samples from six locations-near the lake's center, near its drainage outlet, etc.-obtaining the results (in mg/L) shown in the table. Using this data, determine if there is a significant difference between the concentration of Zn²+ at the two interfaces at. Complete this analysis treating the data as paired. Location 1 2 3 4 5 6 Air-Water Interface 0.430 0.266 0.457 0.531 0.707 0.716 Sediment- Water Interface 0.415 0.238 0.390 0.410 0.605 0.609

Calculus For The Life Sciences
2nd Edition
ISBN:9780321964038
Author:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Chapter1: Functions
Section1.2: The Least Square Line
Problem 5E
icon
Related questions
Question

Please do this on MS EXCEL. Please show the step by step process on EXCEL. So I can use it as a guide. Thank you. 

 
3. Suppose you are studying the distribution of zinc in a lake and want to know if there is a significant difference
between the concentration of Zn2+ at the sediment-water interface and its concentration at the air-water
interface. You collect samples from six locations-near the lake's center, near its drainage outlet, etc.-obtaining the
results (in mg/L) shown in the table. Using this data, determine if there is a significant difference between the
concentration of Zn2+ at the two interfaces at. Complete this analysis treating the data as paired.
Sediment-
Air-Water
Location
Water
Interface
Interface
1
0.430
0.415
2
0.266
0.238
3
0.457
0.390
4
0.531
0.410
0.707
0.605
6
0.716
0.609
5.
Transcribed Image Text:3. Suppose you are studying the distribution of zinc in a lake and want to know if there is a significant difference between the concentration of Zn2+ at the sediment-water interface and its concentration at the air-water interface. You collect samples from six locations-near the lake's center, near its drainage outlet, etc.-obtaining the results (in mg/L) shown in the table. Using this data, determine if there is a significant difference between the concentration of Zn2+ at the two interfaces at. Complete this analysis treating the data as paired. Sediment- Air-Water Location Water Interface Interface 1 0.430 0.415 2 0.266 0.238 3 0.457 0.390 4 0.531 0.410 0.707 0.605 6 0.716 0.609 5.
Expert Solution
steps

Step by step

Solved in 4 steps with 7 images

Blurred answer
Similar questions
Recommended textbooks for you
Calculus For The Life Sciences
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
College Algebra
College Algebra
Algebra
ISBN:
9781938168383
Author:
Jay Abramson
Publisher:
OpenStax