'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'''''''''''''''''''''' ADVANCED EXCEL '''''''''''''''''''''
''''''''''' for scientific data analysis 2nd ed. '''''''''''
''''''''''''''''''''''' R. de Levie '''''''''''''''''''''''
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'''''''''''''*********************************'''''''''''''
'''''''''''''* *'''''''''''''
'''''''''''''* SAMPLE DATA *'''''''''''''
'''''''''''''* *'''''''''''''
'''''''''''''*********************************'''''''''''''
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
''''''''''''''''''''''''''''''''''''''''''''' © R. de Levie
'''''''''''''''''''''''''''''''''''''''''''''v 8, Aug. 2008
The sample data listed here are those used as examples in
The second edition of my book Advanced Excel for scientific
data analysis, and are listed for the convenience of
readers who want to reproduce those examples for practice,
and prefer to download them rather than to type them in.
They are listed in the order in which they appear in the
text, and are identified by section, table, or exercise,
plus page number. They are provided as a Word text file.
Highlight the block of data (with or without their column
headings), copy them to the clipboard, then simply paste
them into the Excel worksheet.
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
''''''''''''''''''''''''''''''''''' Exercise 2.9.1 page 88:
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Data from K. Pearson, Phil. Mag. 2 (1901) 559.
yx
5.90.0
5.40.9
4.41.8
4.6 2.6
3.53.3
3.74.4
2.85.2
2.86.1
2.46.5
1.57.4
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'''''''''''''''''''''''''''''''''' Exercise 2.11.1 page 92:
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Data from N. R. Draper & H. Smith, Applied Regression
Analysis, Wiley, 2nd ed., 1981, Table 1.1 on p. 9,
copyright (c) 1981, John Wiley & Sons, and used by
permission.
yx
10.9835.3
11.1329.7
12.5130.8
8.4058.8
9.2761.4
8.7371.3
6.3674.4
8.5076.7
7.8270.7
9.1457.5
8.2446.4
12.1928.9
11.8828.1
9.5739.1
10.9446.8
9.5848.5
10.0959.3
8.1170.0
6.8370.0
8.8874.5
7.6872.1
8.4758.1
8.8644.6
10.3633.4
11.0828.6
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
''''''''''''''''''''''''''''''''''''' Table 2.13.1 page 97:
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Data from M.-H. Kim, M. Song & S.-Y. Ly, J. Chem. Educ.
78 (2001) 238, copyright (c) 2001, Division of Chemical
Education, Inc. of the American Chemical Society, and
used by permission from the Journal of Chemical Education.
V / mLt / deg C
3.800.0
3.904.8
3.988.9
4.1018.2
4.2023.4
4.4028.2
4.5034.6
4.8043.5
5.1550.0
5.7560.0
6.0061.7
7.2572.0
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
''''''''''''''''''''''''''''''''' Exercise 2.15.1 page 105:
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Data from G. R. Bruce & P. S. Gill, Anal. Chem. 76 (1999)
805, copyright (c) 1999, American Chemical Society, and
used by permission from Analytical Chemistry.
Vi / mLR
0.00.86
0.51.11
1.01.44
1.51.74
2.02.04
2.52.33
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'''''''''''''''''''''''''''''''''''' Section 2.17 page 109:
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Data kindly provided by Prof. E. Meyer, as described in
J. Chem. Educ. 74 (1997) 1339, and used by his permission.
t/deg Cp/torr
99.19740.4
97.55700.6
96.18660.7
94.39628.4
85.90443.2
63.62172.3
70.39235.1
76.78308.7
81.63375.5
87.26469.6
90.40529.3
99.21740.4
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
''''''''''''''''''''''''''''''''''''' Section 3.3 page 118:
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Data kindly provided by Prof. C. J. Pursell, as described
in J. Chem. Educ. 76 (1999) 827, and used by his permission.
vibrational wave#
quantum#
1817702
1917797
2017889
2117979
2218064
2318149
2418235
2518318
2618396
2718471
2818546
2918618
3018688
3118755
3218825
3318889
3418954
3519019
3619077
3719131
3819186
3919238
4019286
4119339
4219384
4319429
4419467
4519512
4619546
4719585
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'''''''''''''''''''''''''''''''''' Exercise 3.6.1 page 127:
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Data from R. W. Schwenz & W. F. Polik, J. Chem. Educ.,
76 (1999) 1302, copyright (c) 1999, Division of Chemical
Education, Inc. of the American Chemical Society, and
used by permission from the Journal of Chemical Education.
v"v'J"J'nu
01012905.995
01122925.581
01232944.577
01342962.955
01452980.689
01562997.788
01673014.202
01783029.941
01893044.965
019103059.234
0110113072.771
0111123085.600
0112133097.550
0113143108.914
0114153119.418
0115163129.099
01102864.834
01212843.315
01322821.249
01432798.641
01542775.499
01652751.817
01762727.624
01872702.907
01982677.697
011092651.932
0111102625.689
0112112598.979
0113122571.861
0114132544.220
0115142516.141
02015687.494
02125705.926
02235723.158
02345739.109
02455753.793
02565767.262
02675779.441
02785790.312
02895799.833
029105808.141
02105646.969
02215624.896
02325601.612
02435577.185
02545551.571
02655524.865
02765496.971
02875467.968
02985437.895
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'''''''''''''''''''''''''''''''''''' Table 3.13.1 page 140:
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Data from J. J. Leary & E. B. Messick, Anal. Chem.
57 (1985) 956, copyright (c) 1985, American Chemical
Society, and used by permission from Analytical Chemistry.
x/vol%y/area%
108.16
2015.9
3022.7
4031.5
5039.8
6049.4
7059.7
8070.6
9083.6
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'''''''''''''''''''''''''''''''''' Section 3.14.1 page 144:
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Data kindly provided by Prof. Caryn Sanford Seney,
as described in J. Chem. Educ. 78 (2001) 1221, and
used by her permission.
yx/%
00.0
1100.7
2.5194.8
5420.7
7.5667.2
10874.6
151359.1
201764.9
252287.9
302769.2
353230.1
37.53532.1
403708.1
42.53998.2
454295.9
47.54526.1
504799.8
605763.9
706817.4
807974.0
909048.7
100 10352.6
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'''''''''''''''''''''''''''''''''''' Section 3.15 page 149:
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Data from H. Woods, H. H. Steinour & H. R. Starke, Ind.
Eng. Chem. 24 (1932) 1207, copyright (c) 1935, American
Chemical Society, and used by permission from Industrial
and Engineering Chemistry.
y x1x2x3x4
78.5726660
74.21291552
104.31156820
87.61131847
95.9752633
109.21155922
102.7371176
72.51312244
93.12541822
115.92147426
83.81402134
113.31166912
109.41068812
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'''''''''''''''''''''''''''''''''''' Table 3.19.1 page 166:
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Data from G. N. Wilkinson, Biochem. J. 80 (1961) 324,
copyright (c) 1961, the Biochemical Society, and used
by permission from Portland Press Ltd.
s v
mMmM / 3 min / mg enzyme
0.138 0.148
0.220 0.171
0.291 0.234
0.560 0.324
0.766 0.390
1.460 0.493
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'''''''''''''''''''''''''''''''''''' Table 3.22.1 page 172:
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Data reported by M. S. Kim, M. Burkart & M.-H. Kim in
J. Chem. Educ. 83 (2006) 1884, copyright (c) 2006,
Division of Chemical Education, Inc. of the American
Chemical Society, and used by permission from the
Journal of Chemical Education.
C A
M
0.025 0.097
0.050 0.216
0.100 0.434
0.150 0.620
0.200 0.796
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
''''''''''''''''''''''''''''''''''''' Table 4.1.1 page 181:
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Data reported by S. Bluestone in J. Chem. Educ. 78 (2001)
215, copyright (c) 2001, Division of Chemical Education,
Inc. of the American Chemical Society, and used by
permission from the Journal of Chemical Education.
v Bexp w
cm-1 1E-181E-3
2.272.01105.10
2.722.50032.77
3.182.93691.60
3.633.28581.89
4.083.55032.07
4.543.73162.27
4.993.82693.09
5.453.84773.09
5.903.80273.91
6.353.70255.10
6.813.55515.92
7.263.37736.94
7.713.17528.26
8.172.953510.00
8.622.72818.26
9.082.49576.94
9.532.27215.10
9.982.05523.91
10.441.84383.09
10.891.64882.07
11.341.46722.07
11.801.29731.89
12.251.14381.89
12.711.00191.89
13.160.87712.07
13.610.76482.27
14.070.66312.50
14.520.57492.77
14.97 0.49652.77
15.430.42652.77
15.880.36692.27
16.340.31361.89
16.790.26841.48
17.240.22871.28
17.700.19451.11
18.150.16570.98
18.610.13960.92
19.060.11850.82
19.510.10030.59
19.970.08460.33
20.420.07170.13
20.870.05870.04
21.330.04590.01
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
''''''''''''''''''''''''''''''''''''' Section 4.2 page 184:
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Data reported by R. D. Verma in J. Chem. Phys. 32
(1960) 738, copyright (c) 1960, American Institute
of Physics, and used by permission from the Journal
of Chemical Physics.
vU(r)r
cmpm
11212547.52228.8
10712532.22228.8
10512522.32228.8
10312509.82228.8
10112495.02228.8
9912476.92228.8
9712454.62228.9
9512427.12228.9
9312393.42228.9
9112352.32229.0
8912302.32229.0
8512170.52229.1
8212039.72229.2
7811824.50229.4
7411562.11229.6
7011251.24229.8
6610893.54230.1
6210490.72230.5
5810045.19230.9
549559.11231.5
509034.45232.1
468474.73232.8
427882.80233.6
387260.45234.6
346608.93235.8
305930.54237.1
265226.63238.6
224498.49240.3
183747.28242.3
142973.82244.6
102179.06247.4
61363.60251.0
2527.44256.4
0102.08262.1
0102.08271.7
2527.44279.0
61363.60287.4
102179.06294.0
142973.82300.1
183747.28305.6
224498.49311.1
265226.63316.4
305930.54321.7
346608.93327.3
387260.45332.9
427882.80338.9
468474.73345.1
509034.45351.7
549559.11359.1
5810045.19367.1
6210490.72376.0
6610893.54386.1
7011251.24397.3
7411562.11410.8
7811824.50426.3
8212039.72444.8
8512170.52462.8
8912302.32494.2
9112352.32513.3
9312393.42535.4
9512427.12556.3
9712454.62577.8
9912476.92601.0
10112495.02626.3
10312509.82652.2
10512522.32682.3
10712532.22723.6
11212547.52881.4
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
''''''''''''''''''''''''''''''''''''' Table 4.4.1 page 204:
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Data reported by A. L. Soli in The Chemical
Educator9 (2004) 42, copyright (c) 2004,
American Chemical Society, and used by
permission from The Chemical Educator.
VbpH Vb pH Vb pH
mL mL mL
0.004.4117.006.9228.189.11
0.495.0618.006.9828.309.30
1.005.3619.017.0528.509.64
2.005.6520.007.1228.709.90
2.905.7821.007.2028.9310.05
4.105.9822.007.2829.2010.18
4.956.0823.007.3829.5110.31
6.026.1923.967.4830.0110.44
7.306.2925.007.6230.8010.60
8.006.3426.007.7931.4810.71
9.006.4226.507.9232.5110.85
10.106.5026.758.0033.4110.94
11.006.5526.978.0734.5111.04
12.006.6127.358.2235.0011.07
13.006.6827.518.3036.0211.14
14.026.7327.708.4337.0011.21
14.986.7927.908.6138.0011.26
16.006.8628.038.8139.1111.32
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
''''''''''''''''''''''''''''''''''''' Table 4.5.1 page 208:
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Data kindly provided by Prof. O. C. Salter of Moravian
College, BethlehemPA, and used by his permission.
tIexp
00.2006
10.1798
20.1550
30.1504
40.1431
50.1325
60.1234
70.1174
80.1171
90.1126
100.1079
110.1056
120.1048
130.1024
140.0857
150.0959
160.0964
170.0897
180.0904
190.0916
200.0898
210.0908
220.0852
230.0843
240.0857
250.0834
260.0865
270.0871
280.0836
290.0825
300.0762
310.0794
320.0823
330.0766
340.0785
350.0776
360.0773
370.0765
380.0767
390.0750
400.0752
410.0743
420.0739
430.0740
440.0739
450.0726
460.0730
470.0727
480.0741
490.0727
500.0715
510.0715
520.0709
530.0705
540.0713
550.0709
560.0695
570.0703
580.0714
590.0696
600.0695
610.0675
620.0670
630.0694
640.0771
650.0677
660.0665
670.0678
680.0640
690.0675
700.0672
710.0673
720.0670
730.0665
740.0667
750.0660
760.0668
770.0661
780.0668
790.0669
800.0664
810.0660
820.0653
830.0663
840.0583
850.0662
860.0659
870.0638
880.0635
890.0649
900.0644
910.0646
920.0646
930.0641
940.0641
950.0645
960.0638
970.0634
980.0638
990.0605
1000.0619
1010.0632
1020.0635
1030.0626
1040.0635
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'''''''''''''''''''''''''''''''''' Exercise 4.7.1 page 214:
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Normalized absorbances as a function of wavelength, kindly
provided by Prof. Harry A. Frank of the University of
Connecticut.
AChlorophyll aCP29XanthophyllChlorophyll b
nm
3500.235390.235030.230170.02942
3510.232030.235070.226880.03004
3520.23048 0.23576 0.22384 0.03138
3530.23222 0.23854 0.22063 0.03121
3540.23531 0.24469 0.21765 0.03323
3550.23960 0.25103 0.21536 0.03411
3560.24396 0.25621 0.21198 0.03504
3570.24833 0.26195 0.20938 0.03571
3580.25194 0.26972 0.20745 0.03867
3590.25554 0.27813 0.20620 0.03931
3600.25889 0.28636 0.20494 0.04140
3610.26187 0.29548 0.20275 0.04341
3620.26544 0.30470 0.20088 0.04638
3630.26916 0.31400 0.19881 0.04791
3640.27322 0.32164 0.19669 0.05250
3650.27842 0.32983 0.19457 0.05587
3660.28425 0.33925 0.19275 0.05820
3670.29028 0.34956 0.19036 0.06134
3680.29666 0.35997 0.18940 0.06543
3690.30265 0.37110 0.18770 0.07062
3700.30896 0.38302 0.18596 0.07400
3710.31551 0.39577 0.18479 0.07768
3720.32212 0.40796 0.18388 0.08201
3730.32878 0.41935 0.18305 0.08581
3740.33522 0.42964 0.18141 0.09078
3750.34214 0.43891 0.17913 0.09477
3760.34852 0.44755 0.17793 0.09823
3770.35536 0.45440 0.17659 0.10234
3780.36229 0.46021 0.17491 0.10632
3790.36860 0.46659 0.17448 0.11056
3800.37393 0.47206 0.17250 0.11598
3810.37910 0.47780 0.16871 0.12207
3820.38414 0.48070 0.16687 0.12733
3830.38829 0.48463 0.16555 0.13486
3840.39208 0.48896 0.16422 0.14429
3850.39715 0.49151 0.16129 0.15287
3860.40100 0.49402 0.15712 0.15882
3870.40470 0.49678 0.15265 0.16980
3880.40746 0.50020 0.14894 0.18071
3890.41137 0.50588 0.14584 0.19062
3900.41594 0.51059 0.14344 0.20128
3910.41990 0.51215 0.13951 0.20897
3920.42388 0.51513 0.13545 0.21877
3930.42664 0.52067 0.13153 0.22540
3940.43015 0.52896 0.12830 0.23608
3950.43462 0.53608 0.12637 0.24423
3960.43937 0.54310 0.12467 0.25262
3970.44549 0.54912 0.12125 0.26022
3980.45168 0.55613 0.11949 0.26542
3990.45827 0.56797 0.11857 0.27234
4000.46660 0.58192 0.11852 0.27846
4010.47681 0.59509 0.11839 0.28581
4020.48817 0.60884 0.11662 0.29385
4030.50030 0.62421 0.11705 0.3015
4040.51420 0.64273 0.11676 0.31123
4050.52827 0.66292 0.11822 0.32293
4060.54279 0.68531 0.11880 0.33754
4070.55803 0.70664 0.12268 0.35129
4080.57586 0.72507 0.12487 0.36818
4090.59503 0.74200 0.12799 0.36861
4100.61383 0.75895 0.13200 0.40600
4110.63223 0.77460 0.13426 0.42817
4120.65152 0.78729 0.13786 0.44659
4130.67121 0.79883 0.14128 0.46643
4140.68756 0.81097 0.14678 0.48508
4150.70440 0.81950 0.15432 0.50462
4160.72102 0.82328 0.16095 0.52344
4170.73483 0.82701 0.16726 0.54354
4180.74586 0.83099 0.17636 0.55359
4190.75580 0.83439 0.18421 0.56507
4200.76586 0.83826 0.19395 0.57565
4210.77408 0.84272 0.20422 0.58162
4220.77882 0.85091 0.21424 0.58597
4230.78405 0.86286 0.22627 0.58708
4240.78933 0.87591 0.23800 0.58766
4250.79601 0.89127 0.25273 0.59026
4260.80526 0.90475 0.26795 0.59048
4270.81753 0.91690 0.28061 0.59256
4280.83015 0.93305 0.29350 0.59463
4290.84453 0.95389 0.30898 0.60039
4300.86330 0.98000 0.32454 0.60877
4310.88249 0.98318 0.33890 0.62538
4320.90204 0.99785 0.35400 0.63920
4330.92471 1.00000 0.36744 0.66058
4340.94771 0.99212 0.38002 0.68036
4350.96587 0.98695 0.39116 0.70911
4360.98096 0.97303 0.40472 0.74025
4370.99342 0.94546 0.41884 0.77556
4380.99971 0.91431 0.43131 0.80763
4391.00000 0.87241 0.44382 0.83395
4400.99531 0.82926 0.45742 0.87289
4410.98428 0.77381 0.47310 0.89661
4420.96443 0.71177 0.48884 0.92254
4430.94341 0.66586 0.50560 0.94013
4440.91653 0.60871 0.52202 0.95567
4450.88493 0.54461 0.54322 0.96089
4460.85239 0.49115 0.56554 0.96418
4470.81862 0.43865 0.59071 0.96958
4480.78475 0.39050 0.61781 0.95983
4490.75275 0.34331 0.64790 0.95086
4500.72038 0.29782 0.67609 0.94000
4510.69293 0.26220 0.70746 0.92614
4520.66904 0.22875 0.73981 0.89343
4530.64834 0.19431 0.77024 0.87202
4540.63162 0.16651 0.80364 0.84881
4550.62019 0.14140 0.83351 0.82747
4560.61270 0.11826 0.86303 0.80713
4570.60811 0.09898 0.89247 0.78101
4580.60697 0.07905 0.91800 0.76353
4590.60706 0.06513 0.93725 0.74468
4600.60905 0.05780 0.95778 0.73593
4610.61439 0.04934 0.97813 0.73327
4620.61873 0.03835 0.99022 0.73308
4630.62255 0.02719 0.99619 0.74179
4640.62392 0.01714 1.00000 0.75625
4650.62374 0.01464 0.99956 0.77757
4660.62217 0.01879 0.99599 0.80314
4670.62133 0.02291 0.98699 0.82744
4680.62054 0.02062 0.97659 0.86333
4690.61690 0.01671 0.96243 0.89050
4700.61320 0.01992 0.94485 0.93002
4710.61065 0.01832 0.92203 0.94995
4720.60751 0.01074 0.89660 0.96168
4730.60192 0.00458 0.86974 0.98483
4740.59460 0.00608 0.83965 0.99110
4750.58974 0.01274 0.81220 1.00000
4760.58577 0.01033 0.77921 0.98871
4770.58017 0.00977 0.74955 0.97234
4780.57509 0.01049 0.71186 0.94994
4790.57005 0.00985 0.67503 0.92376
4800.56627 0.01065 0.63703 0.87567
4810.56146 0.00795 0.59980 0.83327
4820.55614 0.00921 0.56522 0.78674
4830.55155 0.01002 0.52742 0.74613
4840.54623 0.00766 0.48536 0.69357
4850.53896 0.00396 0.43710 0.63029
4860.53764 0.01116 0.40743 0.59098
4870.51724 0.00901 0.39395 0.52366
4880.51112 0.01227 0.37401 0.47888
4890.51871 0.01343 0.34071 0.42379
4900.50262 0.01055 0.30864 0.39083
4910.49091 0.01194 0.28786 0.34550
4920.48192 0.01567 0.26578 0.30118
4930.47389 0.01654 0.24147 0.26131
4940.46144 0.01290 0.22407 0.23807
4950.44722 0.01724 0.20860 0.20686
4960.43589 0.01926 0.18971 0.18149
4970.42000 0.01118 0.17579 0.15206
4980.40148 0.01237 0.16125 0.13499
4990.38476 0.01489 0.14659 0.11473
5000.36200 0.00991 0.13819 0.10396
5010.34106 0.01865 0.12222 0.09013
5020.32166 0.01839 0.11254 0.07821
5030.29847 0.01504 0.10296 0.06665
5040.27805 0.02299 0.10137 0.05903
5050.25928 0.02620 0.09852 0.05284
5060.24035 0.02545 0.08849 0.04678
5070.22112 0.02292 0.08462 0.04206
5080.20551 0.02753 0.08237 0.03742
5090.19249 0.02781 0.08361 0.03382
5100.17824 0.02697 0.08709 0.03049
5110.16612 0.02863 0.08254 0.02709
5120.15380 0.02597 0.07638 0.02540
5130.14142 0.02947 0.07785 0.02337
5140.13338 0.03316 0.07154 0.02172
5150.12605 0.03627 0.06660 0.01996
5160.11938 0.03518 0.06731 0.01869
5170.11276 0.03372 0.07217 0.01733
5180.10775 0.03837 0.07649 0.01614
5190.10382 0.04012 0.07306 0.01487
5200.09990 0.03930 0.06399 0.01434
5210.09562 0.02941 0.09023 0.01353
5220.09395 0.02943 0.08404 0.01301
5230.09131 0.02810 0.08161 0.01240
5240.08901 0.03446 0.08123 0.01167
5250.08881 0.03641 0.07040 0.01071
5260.08757 0.03902 0.06731 0.01068
5270.08205 0.03495 0.07021 0.01011
5280.08010 0.03683 0.07797 0.00979
5290.07934 0.04067 0.07977 0.00902
5300.07833 0.04268 0.07015 0.00929
5310.07752 0.04274 0.06391 0.00879
5320.07867 0.04917 0.06868 0.00807
5330.07933 0.05292 0.07212 0.00752
5340.07963 0.05557 0.07642 0.00693
5350.07823 0.05577 0.07697 0.00716
5360.07652 0.05788 0.07108 0.00680
5370.07681 0.06210 0.06980 0.00606
5380.07958 0.06596 0.06955 0.00591
5390.08237 0.07225 0.07032 0.00542
5400.08035 0.07791 0.07600 0.00508
5410.07921 0.07704 0.08288 0.00523
5420.08203 0.08276 0.08252 0.00466
5430.08360 0.08560 0.08700 0.00501
5440.08463 0.08103 0.08745 0.00397
5450.08294 0.07554 0.08476 0.00346
5460.08423 0.08221 0.08017 0.00409
5470.08484 0.09181 0.08483 0.00411
5480.08644 0.09581 0.08922 0.00362
5490.08557 0.09098 0.08837 0.00432
5500.08213 0.07973 0.08422 0.00376
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'''''''''''''''''''''''''''''''''' Section 4.11.1 page 224:
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Data from Y. Bard, Nonlinear Parameter Estimation,
Academic Press 1974 p. 124, copyright (c) 1974,
Academic Press, and used by permission.
T ty
oKhrs
1000.100.980
1000.200.983
1000.300.955
1000.400.979
1000.500.993
2000.050.626
2000.100.544
2000.150.455
2000.200.225
2000.250.167
3000.020.566
3000.040.317
3000.060.034
3000.080.016
3000.100.066
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'''''''''''''''''''''''''''''''''''' Section 4.13 page 229:
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Data from E. S. Eppright, H. M. Fox, B. A. Fryer,
G. H. Lamkin, V. M. Vivian & E. S. Fuller, World
Rev. Nutrition Dietetics 14 (1972) 269, copyright
(c) 1972, K. Karger AG, and used by permission.
w/hage
pounds
/inch/months
0.460.5
0.471.5
0.562.5
0.613.5
0.614.5
0.675.5
0.686.5
0.787.5
0.698.5
0.749.5
0.7710.5
0.7811.5
0.7512.5
0.8013.5
0.7814.5
0.8215.5
0.7716.5
0.8017.5
0.8118.5
0.7819.5
0.8720.5
0.8021.5
0.8322.5
0.8123.5
0.8824.5
0.8125.5
0.8326.5
0.8227.5
0.8228.5
0.8629.5
0.8230.5
0.8531.5
0.8832.5
0.8633.5
0.9134.5
0.8735.5
0.8736.5
0.8737.5
0.8538.5
0.9039.5
0.8740.5
0.9141.5
0.9042.5
0.9343.5
0.8944.5
0.8945.5
0.9246.5
0.8947.5
0.9248.5
0.9649.5
0.9250.5
0.9151.5
0.9552.5
0.9353.5
0.9354.5
0.9855.5
0.9556.5
0.9757.5
0.9758.5
0.9659.5
0.9760.5
0.9461.5
0.9662.5
1.0363.5
0.9964.5
1.0165.5
0.9966.5
0.9967.5
0.9768.5
1.0169.5
0.9970.5
1.0471.5
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'''''''''''''''''''''''''''''''''' Section 4.21.1 page 247:
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Data from T. Witt, as listed in D. M. Bates &
D. G. Watts, Nonlinear Regression Analysis and
its Applications, Wiley 1988, p. 275, copyright
(c) 1988, John Wiley & Sons, and used by permission.
t yp
oCkAtm
05.105950.001000
05.107160.001000
05.790570.363166
06.361130.805500
06.387050.740803
07.385111.407470
07.973291.868090
09.156302.572020
010.472503.285100
011.927203.907470
012.426204.125470
254.542230.001000
255.297820.422941
255.824520.805500
256.226541.168370
256.705151.505920
257.573382.237290
257.716592.339960
258.344962.813940
259.523333.647270
2510.354004.216890
2511.984405.064290
2512.443505.280880
384.298650.001000
384.660600.191084
385.172750.516822
385.807541.008730
386.118981.298470
386.232061.375820
386.649631.737990
386.855301.948960
387.741012.749240
387.967312.922240
388.804453.636720
389.342254.044600
3810.510904.849800
3811.821505.605780
3813.068006.273850
993.374170.001000
993.380990.001000
994.087660.402195
994.457830.685950
995.206751.423640
995.769882.103670
995.839192.219700
996.291012.791430
996.726353.534750
997.132104.107890
997.327194.213370
997.768834.937710
998.323295.640940
998.913626.344170
999.983347.469350
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'''''''''''''''''''''''''''''''''' Section 4.21.2 page 248:
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Data from W. H. Sachs, Technometrics
18 (1976) 161, and used by permission.
Va pH
mL
1.69510.002
2.4029.820
2.7439.739
3.1959.643
3.5999.559
4.1049.457
4.6789.339
4.9909.276
5.5899.145
6.1908.994
6.7908.830
7.0908.731
7.2948.660
7.6608.497
8.0978.230
8.3867.991
8.6717.735
9.0707.430
9.5317.194
9.9807.026
10.4106.889
10.8406.777
11.2806.675
11.7306.578
12.2306.474
12.7256.378
13.2296.280
13.7266.184
14.2256.078
14.7275.959
15.2215.837
15.7205.686
16.2205.489
16.6345.249
16.8595.045
17.0004.852
17.1014.656
17.1404.552
17.1704.453
17.2284.220
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'''''''''''''''''''''''''''''''''' Section 4.21.4 page 252:
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Data from H. G. Thornton, Ann. Appl. Biol. (1922) 265,
as quoted in A. J. Lotka, Elements of Mathematical
Biology, Williams & Wilkins 1924) p. 70.
At
cmdays
0.240
2.781
13.532
36.33
47.54
49.45