基于Excel平台土壤含水量多元回归预测模型

摘要

Soil moisture content is expressed in soil moisture levels,reflecting the most direct and important indicator of drought. Soil moisture forecast to reflect the future development trend of a certain period of agricultural drought,for carrying out the drought early warning,command and leadership at all levels and departments to provide decision-making basis for drought mitigation. In this paper, precipitation,evaporation,wind and other sources of information as influencing factors measured to Excel as technology platforms, creating a multiple regression model for soil moisture prediction. The forecast model creation method is simple, easy to transform and transfer.%土壤含水量是表述土壤干湿程度,反映旱情最直接的重要指标. 土壤含水量预测能够反映未来某一时段农牧业旱情发展趋势,为开展旱情预警、各级领导和政府部门指挥抗旱减灾提供决策性依据.以降水、蒸发、风速等实测信息源为影响因子,以Excel为技术平台,创建了土壤含水量多元回归预测模型. 该预测模型创建方法简单易行,便于改造和移植,有进一步推广价值.