降水集中度与集中期的Excel计算方法研究

发布时间：2018-03-06 16:49

本文选题：相关关系　切入点：时空分布特征　出处：《人民黄河》2017年04期 　论文类型：期刊论文

【摘要】：以河南省1967—2015年49个站汛期逐日降水量为基本数据,运用Excel 2007的函数功能,将研究时段内各日以对应方位角的弧度值表示,由ATAN2函数取得arctan函数值,从而实现降水集中度和集中期的计算。同时,利用Excel2007折线图功能绘制各站汛期PCD和PCP的时间演变曲线,利用地统计分析插值功能绘制空间分布等值线图。结果表明:1该计算方法使海量数据及其处理条理化,统计计算简单化,计算成果更为准确、直观,易于推广应用,并提高了工作效率;2单站历年汛期的降水集中度和集中期具有峰、谷交替与阶段性变化的特点;3河南省汛期降水集中度和集中期的空间分布总体呈准纬向分布;4单站历年汛期的降水集中度与集中期大多成反相关关系,区域降水集中度与集中期之间成显著的正相关关系。
[Abstract]:Taking the daily precipitation of 49 stations in Henan Province from 1967-2015 as the basic data, using the function of Excel 2007, each day in the study period is expressed by the radians corresponding to the azimuth angle, and the arctan function value is obtained from the ATAN2 function. In order to realize the calculation of precipitation concentration and concentration period, at the same time, the time evolution curves of PCD and PCP in flood season are drawn by using the function of Excel2007 broken line diagram. Using the function of geostatistical analysis and interpolation to draw the isoline map of spatial distribution, the result shows that the calculation method of "1: 1" makes mass data and its processing orderly, the statistical calculation is simple, the calculation results are more accurate, intuitive and easy to be popularized and applied. In addition, the working efficiency is improved. The precipitation concentration degree and the concentration period of the single station in the flood season over the years are peak. The characteristics of the alternate and periodic changes in the valley are as follows: (3) the precipitation concentration degree and spatial distribution in the flood season in Henan Province are generally quasi-zonal distribution, the precipitation concentration degree of the single station in the past years is mostly inversely correlated with the concentration period. There is a significant positive correlation between regional precipitation concentration and concentration period.
【作者单位】：青海大学水利电力学院;
【基金】：国家自然科学基金资助项目(41571276) 河南省重点科技攻关计划项目(152102110096)
【分类号】：P333.1

【相似文献】