不同温度和压力下空气在水中的溶解度计算公式(4.4-98.9-℃和0-689.476-kpa任意温度和压力点下溶解度)

空气在水中的溶解度拟合求解下方为插入的一个Excel文件，双击可以进行编辑。以下为溶解度计算公式的拟合过程。溶解度溶解度是指溶质在一定量的溶剂中的溶解度极限。它是饱和溶液的浓度。空气在水中的溶解度溶解在水中的空气量随压力升高而增加，随温度升高而降低。考虑所查得数据的整洁性，下文温度采用华氏温度oF，压力单位采用英制压力单位Psig（1psi=6894.76Pa）。其中华氏温度F与摄氏温度C换算关系为F=9/5C+32。空气在水中的溶解度（溶解的空气体积与水体积之比）有以下数据。溶解度[V空气

/V水]温度[oF]表压[psi]020406080100400.02580.06130.09670.13210.16760.203500.02230.05290.08360.11430.14490.1756600.01970.04690.07420.10140.12960.1559700.01770.04230.06690.09160.11620.1408800.01610.03870.06140.0840.10670.1293900.01470.03580.05690.0780.0990.12011000.01360.03340.05320.0730.09280.11261100.01260.03140.05010.06890.08770.10651200.01170.02960.04750.06540.08330.10121300.01070.0280.04520.06240.07960.09681400.00980.02650.04320.05980.07650.09311500.00890.02510.04130.05740.07360.08981600.00790.02370.03950.05530.07110.08691700.00680.02230.03780.05340.06890.08441800.00550.02080.03610.05140.06670.0821900.00410.01920.03440.04960.06470.07992000.00240.01750.03260.04770.06280.07792100.00040.01550.03060.04570.06070.0758拟合得出以下曲线(各定压下空气溶解度与温度关系)：对表中数据转置，重新拟合(各定温下空气溶解度与压力关系)得：以上可得出定温下空气溶解度与压力关系式，各关系式斜率k及截距b如下：kbk*1e8b*1e8400.0017720.02581772002580000500.0015330.02231533002230000600.0013650.01971365001970000700.0012310.01771231001770000800.0011320.01611132001610000900.0010540.014710540014700001000.000990.01369900013600001100.0009390.01269390012600001200.0008950.01178950011700001300.0008610.01078610010700001400.0008330.0098833009800001500.0008090.0089809008900001600.000790.0079790007900001700.0007760.0068776006800001800.0007650.0055765005500001900.0007580.0041758004100002000.0007550.0024755002400002100.0007540.00047540040000对斜率数据和截距数据分别拟合曲线得(横坐标均表示华氏温度)：令斜率k=f1(T)，截距b=f2(T)。若