1. You are working with a colleague to measure the carbonate chemistry of a set of water samples. Unfortunately your colleague is a bit sloppy, and when you look at the data, you realize there must have been some errors in the measurements. Blank cells in the table below mean your colleague didn't collect data for that species in that sample. For each sample (#1-6), EITHER explain why at least some measurements for that sample must be in error OR fill in the missing data with reasonable values. (Note: you can assume the precision of the measurements is ±1mM, so inconsistencies below that level do not necessarily indicate errors.) Sample pH [H2CO3*] (MM) [HCO3] (mM) [CO3²-] (MM) Total C (mM) 1 12.0 195 199 2 3.1 155 520 3 1000 100 1101 4 7.4 317 317 50 CO 248 248 1675 6 8.3 97 402

Appl Of Ms Excel In Analytical Chemistry
2nd Edition
ISBN:9781285686691
Author:Crouch
Publisher:Crouch
Chapter4: Least-squares And Calibration Methods
Section: Chapter Questions
Problem 1P
Question
1. You are working with a colleague to measure the carbonate chemistry of a set of
water samples. Unfortunately your colleague is a bit sloppy, and when you look at the
data, you realize there must have been some errors in the measurements. Blank cells
in the table below mean your colleague didn't collect data for that species in that
sample. For each sample (#1-6), EITHER explain why at least some measurements for
that sample must be in error OR fill in the missing data with reasonable values. (Note:
you can assume the precision of the measurements is ±1mM, so inconsistencies below
that level do not necessarily indicate errors.)
Sample
pH
[H2CO3*] (MM) [HCO3] (mM) [CO3²-] (MM)
Total C (mM)
1
12.0
195
199
2
3.1
155
520
3
1000
100
1101
4
7.4
317
317
50
CO
248
248
1675
6
8.3
97
402
Transcribed Image Text:1. You are working with a colleague to measure the carbonate chemistry of a set of water samples. Unfortunately your colleague is a bit sloppy, and when you look at the data, you realize there must have been some errors in the measurements. Blank cells in the table below mean your colleague didn't collect data for that species in that sample. For each sample (#1-6), EITHER explain why at least some measurements for that sample must be in error OR fill in the missing data with reasonable values. (Note: you can assume the precision of the measurements is ±1mM, so inconsistencies below that level do not necessarily indicate errors.) Sample pH [H2CO3*] (MM) [HCO3] (mM) [CO3²-] (MM) Total C (mM) 1 12.0 195 199 2 3.1 155 520 3 1000 100 1101 4 7.4 317 317 50 CO 248 248 1675 6 8.3 97 402
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
steps

Unlock instant AI solutions

Tap the button
to generate a solution

Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Appl Of Ms Excel In Analytical Chemistry
Appl Of Ms Excel In Analytical Chemistry
Chemistry
ISBN:
9781285686691
Author:
Crouch
Publisher:
Cengage
Chemistry: The Molecular Science
Chemistry: The Molecular Science
Chemistry
ISBN:
9781285199047
Author:
John W. Moore, Conrad L. Stanitski
Publisher:
Cengage Learning