欢迎访问《中国农学通报》,

中国农学通报 ›› 2014, Vol. 30 ›› Issue (2): 309-313.doi: 10.11924/j.issn.1000-6850.2013-1468

所属专题: 现代农业发展与乡村振兴 农业气象

• 农业科技信息 • 上一篇    下一篇

基于Microsoft Excel统计函数的农业气象预报模型研究

张梅 陈玉光 李韦禄 关建   

  • 收稿日期:2013-05-24 修回日期:2013-06-05 出版日期:2014-01-15 发布日期:2014-01-15
  • 基金资助:
    辽阳市气象局 “水稻发育期预报技术方法” (201204)。

The Research of Agricultural Meteorological Forecast Model Based on the Microsoft Excel Statistics

  • Received:2013-05-24 Revised:2013-06-05 Online:2014-01-15 Published:2014-01-15

摘要: 为了给当地政府、农业部门、农户提供准确及时的农作物播种期、发育期等农用天气预报,通过日平均气温稳定通过5℃初日与0℃初日间隔日数预报模型和水稻播种-抽穗天数预报模型的建立,介绍Microsoft Excel SLOPE、INTERCEPT、LINEST统计函数在农业气象预报中的应用。实践证明,这3种函数能对已知数据进行最佳线性拟和,可以轻而易举地处理诸多变量之间的相关关系,根据返回的数值数组,可以直接观察到所有自变量与因变量之间的相关程度和F值。因此,利用Microsoft Excel统计函数制作农业气象预报模型,不仅可以大大地减轻劳动强度,而且还可以提高工作效率和预报效果。

关键词: 健康风险评价, 健康风险评价

Abstract: In order to provide sowing time, growth of crops and other agricultural weather forecast accurately and timely for local governments, agricultural sector and farmers, by the establishment of model about the interval number of the average daily temperature through the 5℃ and 0℃ steadily and rice forecast from growing to earing. The author introduced the application of Microsoft Excel SLOPE, INTERCEPT and LINEST the statistics function to the agriculture weather forecasts model. Practices showed that: these three kinds of functions could carry on the best reglin to the known data, and easily deal the relationship between variables, and according to the returned array to observe directly the interrelation between all the independent variables and dependent variable and F value. Therefore, agricultural meteorological forecast model by use of Microsoft Excel statistical function not only can greatly reduce labor intensity, but also improve the work efficiency and prediction effect.