不同溫度和壓力下空氣在水中的溶解度計(jì)算公式(4.4-98.9-℃和0-689.476-kpa任意溫度和壓力點(diǎn)下溶解度)

空氣在水中的溶解度擬合求解下方為插入的一個(gè)Excel文件，雙擊可以進(jìn)行編輯。以下為溶解度計(jì)算公式的擬合過(guò)程。溶解度溶解度是指溶質(zhì)在一定量的溶劑中的溶解度極限。它是飽和溶液的濃度。空氣在水中的溶解度溶解在水中的空氣量隨壓力升高而增加，隨溫度升高而降低?？紤]所查得數(shù)據(jù)的整潔性，下文溫度采用華氏溫度oF，壓力單位采用英制壓力單位Psig（1psi=6894.76Pa）。其中華氏溫度F與攝氏溫度C換算關(guān)系為F=9/5C+32?？諝庠谒械娜芙舛龋ㄈ芙獾目諝怏w積與水體積之比）有以下數(shù)據(jù)。溶解度[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擬合得出以下曲線(各定壓下空氣溶解度與溫度關(guān)系)：對(duì)表中數(shù)據(jù)轉(zhuǎn)置，重新擬合(各定溫下空氣溶解度與壓力關(guān)系)得：以上可得出定溫下空氣溶解度與壓力關(guān)系式，各關(guān)系式斜率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對(duì)斜率數(shù)據(jù)和截距數(shù)據(jù)分別擬合曲線得(橫坐標(biāo)均表示華氏溫度)：令斜率k=f1(T)，截距b=f2(T)。若