Data processing exercise
Student Details  
First Name  Surname  Student No.  Note: do not change any of the model data in red until all the formulas have been inserted and you  
have checked that they are working properly by comparing the results with the model answers.  
Once the formulas are correct all data in red should be replaced by your assigned data  
Data and Analysis – AAS  Don’t forget to plot a calibration graph with error bars showing the 99% confidence interval  
Tablet mass / g  Sample mass / g  Standard  Average  Instrument  Standard  99%  
1.0217  0.5003  Conc  Reading  RSD  Deviation  CI  Use LINEST  
/ppm  /a.u.  /%  /a.u.  /a.u.  
0.00  0.010  5.10  ?  ?  m  ?  ?  c  
10.00  0.042  0.01  ?  ?  S_{slope}  ?  ?  S_{intercept}  
20.00  0.106  0.40  ?  ?  R^{2}  ?  ?  S_{y/x}  
30.00  0.142  0.90  ?  ?  F  ?  ?  Degrees of Freedom  
40.00  0.210  0.80  ?  ?  SS_{reg}  ?  ?  SS_{resid}  
50.00  0.263  0.50  ?  ?  
Sample 1  0.251  0.600  ?  ?  
Sample 2  0.251  0.600  ?  ?  
Number of calibration graph data points  Number of sample repeat measurements  Limit of Detection from graph  
n_{C} =  6  n_{S} =  5  
Choice of uncertainty threshold  
Mean values of calibration graph x and y  k=  3  

?  

?  y_{L} = c + k.Sy/x=  ?  
x_{L} = (y_{L} – c)/m =  ? 

5.829  ppm, expected value for test data  

Σ(x – x)² = (S_{y/x} / S_{slope})^{2} =  ?  
Sample 1  Sample 2  
y_{0} =  0.251  y_{0} =  0.251  
x_{0} = (y_{0} − c) / m =  ?  x_{0} = (y_{0} − c) / m =  ?  
Contributions to uncertainty in x_{0}  Contributions to uncertainty in x_{0}  
1/n_{s}=  ?  If one of these contributions is large it will dominate uncertainty in the determined concentration  1/n_{s}=  ?  If one of these contributions is large it will dominate uncertainty in the determined concentration  
1/n_{c}=  ?  1/n_{c}=  ?  
(y_{0}y)^{2}/m^{2}Σ(x – x)²=  ?  (y_{0}y)^{2}/m^{2}Σ(x – x)²=  ?  
conc = x_{0} =  ?  ppm  conc = x_{0} =  ?  ppm  
s_{X}_{0} =  ?  ppm  s_{X}_{0} =  ?  ppm  
conc = ? × x_{0} =  ? 

974  ppm expected value for test data  conc = ? × x_{0} =  ? 

974  ppm expected value for test data  
s_{conc} = ? × s_{X}_{0} =  ? 

32  ppm expected value for test data  s_{conc} = ? × s_{X}_{0} =  ? 

32  ppm expected value for test data  
Mass Bi in tablet =  ?  mg  Mass Bi in tablet =  ?  mg  
Mass Bi subsalicylate in tablet =  ? 

344  mg expected values for test data  Mass Bi subsalicylate in tablet =  ? 

344  mg expected values for test data  
Uncertainty =  ? 

11  mg expected values for test data  Uncertainty =  ? 

11  mg expected values for test data  
Student Details  
First Name  Surname  Student No.  Note: do not change any of the model data in red until all the formulas have been inserted and you  
have checked that they are working properly by comparing the results with the model answers.  
Once the formulas are correct all data in red should be replaced by your assigned data  
Data and Analysis – ICPOES  Don’t forget to plot a calibration graph with error bars showing the 99% confidence interval  
Tablet mass / g  Sample mass / g  Standard  Average  Instrument  Standard  99%  
1.0217  0.5003  Conc  Reading  RSD  Deviation  CI  Use LINEST  
/ppm  /a.u.  /%  /a.u.  /a.u.  
0.00  68.98  5.10  ?  ?  m  ?  ?  c  
10.00  1047  0.01  ?  ?  S_{slope}  ?  ?  S_{intercept}  
20.00  2014  0.40  ?  ?  R^{2}  ?  ?  S_{y/x}  
30.00  3025  0.90  ?  ?  F  ?  ?  Degrees of Freedom  
40.00  4085  0.80  ?  ?  SS_{reg}  ?  ?  SS_{resid}  
50.00  5182  0.50  ?  ?  
Sample 1  4940  0.600  ?  ?  
Sample 2  4940  0.600  ?  ?  
Number of calibration graph data points  Number of sample repeat measurements  Limit of Detection from graph  
n_{C} =  6  n_{S} =  5  
Choice of uncertainty threshold  
Mean values of calibration graph x and y  k=  3  

?  

?  y_{L} = c + k.Sy/x=  ?  
x_{L} = (y_{L} – c)/m =  ? 

1.588  ppm, expected value for test data  

Σ(x – x)² = (S_{y/x} / S_{slope})^{2} =  ?  
Sample 1  Sample 2  
y_{0} =  4940.000  y_{0} =  4940.000  
x_{0} = (y_{0} − c) / m =  ?  x_{0} = (y_{0} − c) / m =  ?  
Contributions to uncertainty in x_{0}  Contributions to uncertainty in x_{0}  
1/n_{s}=  If one of these contributions is large it will dominate uncertainty in the determined concentration  1/n_{s}=  If one of these contributions is large it will dominate uncertainty in the determined concentration  
1/n_{c}=  1/n_{c}=  
(y_{0}y)^{2}/m^{2}Σ(x – x)²=  (y_{0}y)^{2}/m^{2}Σ(x – x)²=  
conc = x_{0} =  ?  ppm  conc = x_{0} =  ?  ppm  
s_{X}_{0} =  ?  ppm  s_{X}_{0} =  ?  ppm  
conc = ? × x_{0} =  ? 

964.8  ppm expected value for test data  conc = ? × x_{0} =  ? 

964.8  ppm expected value for test data  
s_{conc} = ? × s_{X}_{0} =  ? 

8.7  ppm expected value for test data  s_{conc} = ? × s_{X}_{0} =  ? 

8.7  ppm expected value for test data  
Mass Bi in tablet =  ?  mg  Mass Bi in tablet =  ?  mg  
Mass Bi subsalicylate in tablet =  ? 

341  mg expected values for test data  Mass Bi subsalicylate in tablet =  ? 

341  mg expected values for test data  
Uncertainty =  ?  mg  3  mg expected values for test data  Uncertainty =  ?  mg  3  mg expected values for test data  
Student Details  
First Name  Surname  Student No.  Note: do not change any of the model data until all the formulas have been inserted and you  
have checked that the formulas are working properly by comparing the results with the model answers.  
Data on this sheet is automatically populated from the AAS and ICPOES table  
Data and Analysis – Comparison of Methods  
Back calculate concentration x=(yc)/m  
of standards from regression 


Standard  ICPOES  AAS  ICPOES  AAS  
Conc  Average  Average  /ppm  /ppm  
/ppm  /a.u.  /a.u.  (x)  (y)  
0.00  0.00  (x)  ?  ?  
10.00  0.00  ?  ?  ?  
20.00  0.00  ?  ?  ?  
30.00  0.00  ?  ?  ?  
40.00  0.00  ?  ?  ?  
50.00  0.00  ?  ?  ?  
m  c  
ICPOES  ?  ?  
AAS  ?  ?  
Analysis of AAS vs ICPOES graph  
Use LINEST  0 to 50 ppm  
expected values for test data  
m  ?  ?  c 

m  1.000721585  
S_{slope}  ?  ?  S_{intercept}  c  0.01803961  
R^{2}  ?  ?  S_{y/x} 

R^{2}  0.993512196  
F  ?  ?  Degrees of Freedom 

DoF  4  
SS_{reg}  ?  ?  SS_{resid}  
Use LINEST  0 to 40 ppm  
expected values for test data  
m  ?  ?  c 

m  0.988430573  
S_{slope}  ?  ?  S_{intercept} 

c  0.149175729  
R^{2}  ?  ?  S_{y/x} 

R^{2}  0.988322573  Test data shows no deviation from linearity  
F  ?  ?  Degrees of Freedom 

DoF  3  what does your real data show?  
SS_{reg}  ?  ?  SS_{resid}  