非标准大气压下烟叶含水率测试结果的修正

摘要

为了修正高海拔地区(非标准大气压下)烟叶含水率测试结果与低海拔地区(近似标准大气压下)测试结果之间的系统差异,选择了9个实验样品在8个不同海拔高度的实验室[非标准大气压下7个实验室(1#~7#),和一个近似标准大气压下实验室(8#)],进行了含水率测试.分析了大气压与含水率测试值的相关性,及标准与非标准大气压下实验室烟叶含水率测试值的关系.利用LINEST回归函数,建立了非标准大气压下烟叶含水率的修正方程,并重新选择验证样品对修正方程进行了验证.结果表明:①烟叶含水率测定值与大气压力负相关,二者决定系数R2在0.5196~0.9175之间,9个样品的含水率与大气压的相关性均达显著或极显著水平.②通过含水率与大气压之间的相关性拟合了两者之间的优化结果,为三重多项式.③将非标准大气压下验证样品测试结果带入修正方程,将修正值与标准大气压下测定值进行了比较,两者最大偏差绝对值为0.6689%.%In order to investigate the systematic difference of moisture content in tobacco leaf tested in labs in areas of different altitudes above sea level, nine leaf samples were tested in eight labs. The correlation between atmospheric pressure and the measured moisture content was analyzed. The correction equation for moisture content in leaf to standard atmospheric pressure was established via LINEST regression function, and validated. The results showed that: 1)The test value of moisture content in tobacco leaf negatively correlated to atmospheric pressure,their correlation coefficient R2ranged from 0.519 6 to 0.917 5;the correlations between the moisture content in the nine samples and atmospheric pressure all reached significant or extremely significant level. 2)The correlation between the moisture content and atmospheric pressure fitted a triple polynomial best. 3) The corrected test values of the samples under non-standard atmospheric pressure were compared with the values tested under standard atmospheric pressure, and the maximum deviation between them was 0.668 9%.