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.