Construct a calibration curve: (a) Subtract the blank value (9.1) from all other values (this means that your first data point will be 0,0). Then use the LINEST calculation of least squares to find the slope and intercept and their uncertainties. slope 869 intercept (b) Replicate measurements of an unknown gave 152.1, 152.4, 153.9, and 152.7 mV, and a blank gave 9.1, 9.4, 10.6, and 9.0 mV. Subtract the average blank from the average unknown to find the average corrected signal for the unknown. 143.25 Check the number of significant figures. (c) Find the concentration of the unknown and its uncertainty.

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 9P
icon
Related questions
Question
There is a Canvas AUDIO tutorial available for this problem. This question requires the use of a spread sheet (Excel) to calculate the LINEST uncertainty in the Linear Least
Squares best fit line, and the associated unknown sample. You'll be reproducing the calculations in Figure 4-13 in the 7th Addition of Harris. The instructions for using LINEST
are on the previous page. Here are mass spectrometric signals for methane in H2.
CH4 (vol %): 0
0.062 0.122 0.245 0.486 0.971
1.921
Signal (mV): 9.1 47.5
95.6 193.8 387.5 812.5 1671.9
Construct a calibration curve: (a) Subtract the blank value (9.1) from all other values (this means that your first data point will be 0,0). Then use the LINEST
calculation of least squares to find the slope and intercept and their uncertainties.
slope
869
intercept
(b) Replicate measurements of an unknown gave 152.1, 152.4, 153.9, and 152.7 mV, and a blank gave 9.1, 9.4, 10.6, and 9.0 mV. Subtract the average blank from
the average unknown to find the average corrected signal for the unknown.
4.0 143.25
Check the number of significant figures.
(c) Find the concentration of the unknown and its uncertainty.
0.19
+ 0.01
vol%
Transcribed Image Text:There is a Canvas AUDIO tutorial available for this problem. This question requires the use of a spread sheet (Excel) to calculate the LINEST uncertainty in the Linear Least Squares best fit line, and the associated unknown sample. You'll be reproducing the calculations in Figure 4-13 in the 7th Addition of Harris. The instructions for using LINEST are on the previous page. Here are mass spectrometric signals for methane in H2. CH4 (vol %): 0 0.062 0.122 0.245 0.486 0.971 1.921 Signal (mV): 9.1 47.5 95.6 193.8 387.5 812.5 1671.9 Construct a calibration curve: (a) Subtract the blank value (9.1) from all other values (this means that your first data point will be 0,0). Then use the LINEST calculation of least squares to find the slope and intercept and their uncertainties. slope 869 intercept (b) Replicate measurements of an unknown gave 152.1, 152.4, 153.9, and 152.7 mV, and a blank gave 9.1, 9.4, 10.6, and 9.0 mV. Subtract the average blank from the average unknown to find the average corrected signal for the unknown. 4.0 143.25 Check the number of significant figures. (c) Find the concentration of the unknown and its uncertainty. 0.19 + 0.01 vol%
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Statistics and Analytical Chemistry
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, chemistry and related others by exploring similar questions and additional content below.
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
Principles of Instrumental Analysis
Principles of Instrumental Analysis
Chemistry
ISBN:
9781305577213
Author:
Douglas A. Skoog, F. James Holler, Stanley R. Crouch
Publisher:
Cengage Learning
Fundamentals Of Analytical Chemistry
Fundamentals Of Analytical Chemistry
Chemistry
ISBN:
9781285640686
Author:
Skoog
Publisher:
Cengage