CHEM366 Testing Lead Concentration in Lipsticks to make to graphs and do error calculation on excel, (just all of concentration identification and error an

CHEM366 Testing Lead Concentration in Lipsticks to make to graphs and do error calculation on excel, (just all of concentration identification and error analysis) Summary Report
Sample ID
Pb:FlameCont Actual Conc. Pb:FlameCont Actual Conc. Unit
blank 1
0.4726
NONE
blank 2
0.5266
NONE
blank 3
0.3971
NONE
loryal 1
0.4942
NONE
loryal 2
0.5158
NONE
loryal 3
0.4295
NONE
w&w1
0.4187
NONE
w&w2
0.5374
NONE
w&w3
0.4187
NONE
nyx 1
0.4942
NONE
nyx 2
0.4834
NONE
nyx 3
0.505
NONE
Pb
Action
Sample ID
True Value (ppm)
Conc. (ppm)
STD-1
10 ppm standard
10
10.1076
STD-2
10 ppm standard
10
9.8811
STD-AV
10 ppm standard
10
9.9998
STD-1
2 ppm standard
2
1.9832
STD-2
2 ppm standard
2
1.9616
STD-AV
2 ppm standard
2
1.9724
STD-1
1 ppm standard
1
1.0768
STD-2
1 ppm standard
1
1.1092
STD-AV
1 ppm standard
1
1.0876
STD-1
0.5 pmm standard
0.5
0.4403
STD-2
0.5 pmm standard
0.5
0.4618
STD-3
0.5 pmm standard
0.5
0.4403
STD-AV
0.5 pmm standard
0.5
0.4403
UNK1-1
blank 1
0.4726
UNK1-2
blank 1
0.4726
UNK1-AV
blank 1
0.4726
UNK2-1
blank 2
0.5482
UNK2-2
blank 2
0.4618
UNK2-3
blank 2
0.4942
UNK2-AV
blank 2
0.5266
UNK3-1
blank 3
0.4187
UNK3-2
blank 3
0.3755
UNK3-AV
blank 3
0.3971
UNK4-1
loryal 1
0.451
UNK4-2
loryal 1
0.505
UNK4-3
loryal 1
0.4834
UNK4-AV
loryal 1
0.4942
UNK5-1
UNK5-2
UNK5-AV
UNK6-1
UNK6-2
UNK6-AV
UNK7-1
UNK7-2
UNK7-AV
UNK8-1
UNK8-2
UNK8-3
UNK8-AV
UNK9-1
UNK9-2
UNK9-AV
UNK10-1
UNK10-2
UNK10-AV
UNK11-1
UNK11-2
UNK11-AV
UNK12-1
UNK12-2
UNK12-3
UNK12-AV
loryal 2
loryal 2
loryal 2
loryal 3
loryal 3
loryal 3
w&w1
w&w1
w&w1
w&w2
w&w2
w&w2
w&w2
w&w3
w&w3
w&w3
nyx 1
nyx 1
nyx 1
nyx 2
nyx 2
nyx 2
nyx 3
nyx 3
nyx 3
nyx 3
0.505
0.5266
0.5158
0.4295
0.4295
0.4295
0.4403
0.3863
0.4187
0.4726
0.5374
0.5374
0.5374
0.4403
0.4079
0.4187
0.505
0.4834
0.4942
0.505
0.4726
0.4834
0.4295
0.4726
0.5266
0.505
Abs.
0.0894
0.0873
0.0884
0.0141
0.0139
0.014
0.0057
0.006
0.0058
-0.0002
0
-0.0002
-0.0002
0.0001
0.0001
0.0001
0.0008
0
0.0003
0.0006
-0.0004
-0.0008
-0.0006
-0.0001
0.0004
0.0002
0.0003
BG
Pos. VOL Reagent 1 Actual Conc. Actual Conc. Unit
0
1
10
0
-0.0001 1
10
0
0
1
10
0
0
2
10
0
0.0007
2
10
0
0.0004
2
10
0
-0.0003 3
10
0
-0.0008 3
10
0
-0.0006 3
10
0
0.0005
4
10
0
0.0002
4
10
0
0.0004
4
10
0
0.0004
4
10
0
-0.0002 5
10
0
0.4726
NONE
-0.0002 5
10
0
0.4726
NONE
-0.0002 5
10
0
0.4726
NONE
0
6
10
0
0.5482
NONE
0.0002
6
10
0
0.4618
NONE
-0.0002 6
10
0
0.4942
NONE
-0.0001 6
10
0
0.5266
NONE
0.0005
7
10
0
0.4187
NONE
0.0007
7
10
0
0.3755
NONE
0.0006
7
10
0
0.3971
NONE
0.0001
8
10
0
0.451
NONE
-0.0004 8
10
0
0.505
NONE
-0.0005 8
10
0
0.4834
NONE
-0.0004 8
10
0
0.4942
NONE
Date
######
######
######
######
######
######
######
######
######
######
######
######
######
######
######
######
######
######
######
######
######
######
######
######
######
######
######
0.0004 0.0004
0.0006
0
0.0005 0.0002
-0.0003 0.0004
-0.0003 0.0003
-0.0003 0.0004
-0.0002 0.0001
-0.0007 0.0004
-0.0004 0.0002
0.0001 0.0003
0.0007 -0.0004
0.0007 -0.0004
0.0007 -0.0004
-0.0002 0.0003
-0.0005 0.0006
-0.0004 0.0004
0.0004
0
0.0002 0.0002
0.0003 0.0001
0.0004 0.0004
0.0001 0.0004
0.0002 0.0004
-0.0003 0.0005
0.0001 0.0002
0.0006
0
0.0004 0.0001
9
9
9
10
10
10
11
11
11
12
12
12
12
13
13
13
14
14
14
15
15
15
16
16
16
16
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
10
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0.505
0.5266
0.5158
0.4295
0.4295
0.4295
0.4403
0.3863
0.4187
0.4726
0.5374
0.5374
0.5374
0.4403
0.4079
0.4187
0.505
0.4834
0.4942
0.505
0.4726
0.4834
0.4295
0.4726
0.5266
0.505
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
######
######
######
######
######
######
######
######
######
######
######
######
######
######
######
######
######
######
######
######
######
######
######
######
######
######
Time
3:59:18 PM(-0500)
3:59:56 PM(-0500)
3:59:18 PM(-0500)
4:00:11 PM(-0500)
4:00:50 PM(-0500)
4:00:11 PM(-0500)
4:01:05 PM(-0500)
4:01:44 PM(-0500)
4:01:05 PM(-0500)
4:02:00 PM(-0500)
4:02:39 PM(-0500)
4:02:51 PM(-0500)
4:02:00 PM(-0500)
4:03:06 PM(-0500)
4:03:45 PM(-0500)
4:03:06 PM(-0500)
4:04:01 PM(-0500)
4:04:39 PM(-0500)
4:04:52 PM(-0500)
4:04:01 PM(-0500)
4:05:07 PM(-0500)
4:05:46 PM(-0500)
4:05:07 PM(-0500)
4:06:01 PM(-0500)
4:06:40 PM(-0500)
4:06:52 PM(-0500)
4:06:40 PM(-0500)
4:07:08 PM(-0500)
4:07:46 PM(-0500)
4:07:08 PM(-0500)
4:08:02 PM(-0500)
4:08:41 PM(-0500)
4:08:02 PM(-0500)
4:08:56 PM(-0500)
4:09:35 PM(-0500)
4:08:56 PM(-0500)
4:09:50 PM(-0500)
4:10:29 PM(-0500)
4:10:41 PM(-0500)
4:10:29 PM(-0500)
4:10:57 PM(-0500)
4:11:35 PM(-0500)
4:10:57 PM(-0500)
4:11:51 PM(-0500)
4:12:30 PM(-0500)
4:11:51 PM(-0500)
4:12:45 PM(-0500)
4:13:24 PM(-0500)
4:12:45 PM(-0500)
4:13:40 PM(-0500)
4:14:19 PM(-0500)
4:14:31 PM(-0500)
4:14:19 PM(-0500)
Pb
Action
UNK1-1
UNK1-2
UNK1-3
UNK1-AV
UNK2-1
UNK2-2
UNK2-3
UNK2-AV
UNK3-1
UNK3-2
UNK3-3
UNK3-AV
UNK4-1
UNK4-2
UNK4-3
UNK4-AV
UNK5-1
UNK5-2
UNK5-3
UNK5-AV
UNK6-1
UNK6-2
UNK6-3
UNK6-AV
UNK7-1
UNK7-2
UNK7-3
UNK7-AV
UNK8-1
UNK8-2
UNK8-3
UNK8-AV
UNK9-1
UNK9-2
UNK9-AV
UNK10-1
UNK10-2
UNK10-AV
UNK11-1
Sample ID
True Value (ppb) Conc. (ppb) Abs.
BG
DI water
0,0017
-0,0002
DI water
0,0008
-0,0002
DI water
0,0011
-0,0005
DI water
0,001
-0,0004
Wet & Wild-1
0,0024
0,0253
Wet & Wild-1
0,0012
0,0227
Wet & Wild-1
0,0017
0,0223
Wet & Wild-1
0,002
0,0238
Wet & Wild-2
0,0021
0,0235
Wet & Wild-2
0,0014
0,0021
Wet & Wild-2
0,0021
0,0276
Wet & Wild-2
0,0021
0,0256
Wet & Wild-3
0,0618
0,0017
Wet & Wild-3
0,092
0,0012
Wet & Wild-3
0,0485
0,0012
Wet & Wild-3
0,0552
0,0014
Nyx-1
0,0087
0,0003
Nyx-1
0,0072
0,0002
Nyx-1
0,0079
0,0002
Nyx-1
0,0076
0,0002
Nyx-2
0,0302
0,0011
Nyx-2
0,0687
0,0015
Nyx-2
0,0699
0,0011
Nyx-2
0,0693
0,0013
Nyx-3
0,188
0,0011
Nyx-3
0,1408
0,0011
Nyx-3
0,1631
0,0015
Nyx-3
0,1756
0,0013
Experimental Control-1
0,0017
-0,0002
Experimental Control-1
0,0012
0
Experimental Control-1
0,0017
0
Experimental Control-1
0,0017
-0,0001
Experimental Control-2
0,0375
0,0002
Experimental Control-2
0,0354
0,0003
Experimental Control-2
0,0364
0,0002
Experimental Control-3
0,0568
0,0003
Experimental Control-3
0,0536
0,0003
Experimental Control-3
0,0552
0,0003
Loreal-1
0,0563
0,0037
UNK11-2
UNK11-AV
UNK12-1
UNK12-2
UNK12-AV
UNK13-1
UNK13-2
UNK13-3
UNK13-AV
UNK14-1
UNK14-2
UNK14-3
UNK14-AV
UNK15-1
UNK15-2
UNK15-3
UNK15-AV
UNK16-1
UNK16-2
UNK16-AV
UNK17-1
UNK17-2
UNK17-3
UNK17-AV
UNK18-1
UNK18-2
UNK18-3
UNK18-AV
Loreal-1
Loreal-1
Loreal-2
Loreal-2
Loreal-2
Loreal-3
Loreal-3
Loreal-3
Loreal-3
Standard-50ppb
Standard-50ppb
Standard-50ppb
Standard-50ppb
Standard-40ppb
Standard-40ppb
Standard-40ppb
Standard-40ppb
Standard-20ppb
Standard-20ppb
Standard-20ppb
Standard-10ppb
Standard-10ppb
Standard-10ppb
Standard-10ppb
Standard-5ppb
Standard-5ppb
Standard-5ppb
Standard-5ppb
0,0572
0,0568
0,0107
0,0114
0,011
0,1254
0,1071
0,1041
0,1056
0,2303
0,2647
0,2733
0,269
0,0636
0,0713
0,0716
0,0714
0,3571
0,3542
0,3556
0,0278
0,0201
0,0255
0,0266
0,0098
0,0148
0,0154
0,0151
0,0034
0,0036
0,0018
0,0012
0,0015
0,0024
0,0018
0,0012
0,0015
0,0017
0,0018
0,0015
0,0016
0,0006
0,0005
0,0005
0,0005
0,0014
0,0017
0,0016
-0,0002
-0,0002
0
-0,0001
-0,0002
0,0002
0
0,0001
Pos.
VOL
1
1
1
1
2
2
2
2
3
3
3
3
4
4
4
4
5
5
5
5
6
6
6
6
7
7
7
7
8
8
8
8
9
9
9
10
10
10
11
Reagent 1 R2
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Actual Conc. Actual Conc. Unit
Date
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
NONE
2/6/2019
Time
4:14:27 PM(-0500)
4:16:23 PM(-0500)
4:18:21 PM(-0500)
4:16:23 PM(-0500)
4:20:20 PM(-0500)
4:22:19 PM(-0500)
4:24:17 PM(-0500)
4:20:20 PM(-0500)
4:26:16 PM(-0500)
4:28:15 PM(-0500)
4:30:13 PM(-0500)
4:26:16 PM(-0500)
4:32:12 PM(-0500)
4:34:10 PM(-0500)
4:36:15 PM(-0500)
4:32:12 PM(-0500)
4:38:20 PM(-0500)
4:40:25 PM(-0500)
4:42:30 PM(-0500)
4:40:25 PM(-0500)
4:44:35 PM(-0500)
4:46:40 PM(-0500)
4:48:45 PM(-0500)
4:46:40 PM(-0500)
4:50:50 PM(-0500)
4:52:55 PM(-0500)
4:54:59 PM(-0500)
4:50:50 PM(-0500)
4:57:04 PM(-0500)
4:59:09 PM(-0500)
5:01:14 PM(-0500)
4:57:04 PM(-0500)
5:03:19 PM(-0500)
5:05:24 PM(-0500)
5:03:19 PM(-0500)
5:13:58 PM(-0500)
5:15:53 PM(-0500)
5:13:58 PM(-0500)
5:17:58 PM(-0500)
11
11
12
12
12
13
13
13
13
14
14
14
14
15
15
15
15
16
16
16
17
17
17
17
18
18
18
18
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
20
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
NONE
2/6/2019
2/6/2019
2/6/2019
2/6/2019
2/6/2019
2/6/2019
2/6/2019
2/6/2019
2/6/2019
2/6/2019
2/6/2019
2/6/2019
2/6/2019
2/6/2019
2/6/2019
2/6/2019
2/6/2019
2/6/2019
2/6/2019
2/6/2019
2/6/2019
2/6/2019
2/6/2019
2/6/2019
2/6/2019
2/6/2019
2/6/2019
2/6/2019
5:20:03 PM(-0500)
5:17:58 PM(-0500)
5:22:08 PM(-0500)
5:24:13 PM(-0500)
5:22:08 PM(-0500)
5:26:18 PM(-0500)
5:28:23 PM(-0500)
5:30:28 PM(-0500)
5:28:23 PM(-0500)
5:32:33 PM(-0500)
5:34:38 PM(-0500)
5:36:42 PM(-0500)
5:34:38 PM(-0500)
5:38:47 PM(-0500)
5:40:52 PM(-0500)
5:42:57 PM(-0500)
5:40:52 PM(-0500)
5:45:02 PM(-0500)
5:47:07 PM(-0500)
5:45:02 PM(-0500)
5:49:12 PM(-0500)
5:51:17 PM(-0500)
5:53:28 PM(-0500)
5:49:12 PM(-0500)
5:55:33 PM(-0500)
5:57:38 PM(-0500)
5:59:49 PM(-0500)
5:57:38 PM(-0500)
14:27 PM(-0500)
16:23 PM(-0500)
18:21 PM(-0500)
16:23 PM(-0500)
20:20 PM(-0500)
22:19 PM(-0500)
24:17 PM(-0500)
20:20 PM(-0500)
26:16 PM(-0500)
28:15 PM(-0500)
30:13 PM(-0500)
26:16 PM(-0500)
32:12 PM(-0500)
34:10 PM(-0500)
36:15 PM(-0500)
32:12 PM(-0500)
38:20 PM(-0500)
40:25 PM(-0500)
42:30 PM(-0500)
40:25 PM(-0500)
44:35 PM(-0500)
46:40 PM(-0500)
48:45 PM(-0500)
46:40 PM(-0500)
50:50 PM(-0500)
52:55 PM(-0500)
54:59 PM(-0500)
50:50 PM(-0500)
57:04 PM(-0500)
59:09 PM(-0500)
01:14 PM(-0500)
57:04 PM(-0500)
03:19 PM(-0500)
05:24 PM(-0500)
03:19 PM(-0500)
13:58 PM(-0500)
15:53 PM(-0500)
13:58 PM(-0500)
17:58 PM(-0500)
20:03 PM(-0500)
17:58 PM(-0500)
22:08 PM(-0500)
24:13 PM(-0500)
22:08 PM(-0500)
26:18 PM(-0500)
28:23 PM(-0500)
30:28 PM(-0500)
28:23 PM(-0500)
32:33 PM(-0500)
34:38 PM(-0500)
36:42 PM(-0500)
34:38 PM(-0500)
38:47 PM(-0500)
40:52 PM(-0500)
42:57 PM(-0500)
40:52 PM(-0500)
45:02 PM(-0500)
47:07 PM(-0500)
45:02 PM(-0500)
49:12 PM(-0500)
51:17 PM(-0500)
53:28 PM(-0500)
49:12 PM(-0500)
55:33 PM(-0500)
57:38 PM(-0500)
59:49 PM(-0500)
57:38 PM(-0500)
Chemistry 366 Homework Problem Set
Widener University
Dr. Van Bramer
January 2019
Propagation of Error and Statistics Worksheet
A 25 mL class A pipet and an Ohaus Explorer model EX124 analytical balance are used to obtain the
following experimental data:
Mass Beaker
Mass w
solution
1.
2.
3.
4.
5.
6.
Trial 1 (g)
54.6003
80.2180
Trial 2 (g)
54.5996
80.1141
Trial 3 (g)
54.6003
80.0187
Trial 4 (g)
54.5987
80.6504
Trial 5 (g)
54.5995
80.7774
Calculate the density of the solution for each trial
Use propagation of error to determine the uncertainty in the density of the solution for a single trial.
Determine the average density for the solution.
Determine the standard deviation for the density of the solution.
Determine the 90% confidence interval for the density of the solution.
Determine the 95% confidence interval for the density of the solution.
A set of salt water standards is created by weighing sodium chloride, adding to a 100 mL class A volumetric
flask and diluting to the mark. 25 mL of this solution is transferred into a beaker with a class A volumetric
pipet.
Solution
Number
1
2
3
4
5
6
Mass NaCl (g)
1.0547
1.9865
3.0058
4.0987
4.9984
6.0245
Volumetric Flask
(mL)
100
100
100
100
100
100
Pipet (mL)
Mass Beaker
25
25
25
25
25
25
68.40121569
68.40067581
68.40119039
68.40023532
68.4013874
68.40093462
Mass Beaker w
solution
93.56275305
93.7401003
93.92849894
94.13449573
94.2988315
94.50244286
1. Create a calibration curve for these standards with the density as a function of salinity (ppt – parts
per thousand).
2. Use the calibration curve and the average salinity for the 5 trials to determine
a. The salinity of the unknown solution
b. The uncertainty in the salinity of the unknown solution – use the equation for determining the
uncertainty in a predicted x value on the statistics equations and tables document.
3. Use the calibration curve and the density for each of the 5 trials of the sample to calculate the
salinity for each of the 5 trials and use these results to determine
a. The average salinity for the solution
b. The standard deviation for the salinity of the solution
c. The 90% confidence interval for the salinity of the solution
d. The 95% confidence interval for the salinity of the solution

Purchase answer to see full
attachment