P-III曲线水文频率计算Excel程序

经验频率计算表
经验频率 P(%) 正态分布 相对距离 频率坐标 样本系列 0.001 0.10 -3.09023 -1 0 0.038462 3.85 -1.76883 -0.57239 0.427608 789.8 0.076923 7.69 -1.42608 -0.46148 0.538521 753.6 0.115385 11.54 -1.19838 -0.3878 0.612204 744.6 0.153846 15.38 -1.02008 -0.3301 0.669903 658.4 0.192308 19.23 -0.86942 -0.28135 0.718654 647.7 0.230769 23.08 -0.73632 -0.23827 0.761728 645.9 0.269231 26.92 -0.61514 -0.19906 0.80094 643.3 0.307692 30.77 -0.5024 -0.16258 0.837423 639.4 0.346154 34.62 -0.39573 -0.12806 0.871943 634.7 0.384615 38.46 -0.29338 -0.09494 0.905062 614.5 0.423077 42.31 -0.19403 -0.06279 0.937212 560.6 0.461538 46.15 -0.09656 -0.03125 0.968754 530.2 0.5 50.00 -1.4E-16 -4.5E-17 1 508.4 0.538462 53.85 0.096559 0.031246 1.031246 489.4 0.576923 57.69 0.194028 0.062788 1.062788 483.2 0.615385 61.54 0.293381 0.094938 1.094938 460 0.653846 65.38 0.395725 0.128057 1.128057 456.5 0.692308 69.23 0.502402 0.162577 1.162577 434.4 0.730769 73.08 0.615141 0.19906 1.19906 434.4 0.769231 76.92 0.736316 0.238272 1.238272 402.6 0.807692 80.77 0.869424 0.281346 1.281346 364.9 0.846154 84.62 1.020076 0.330097 1.330097 353.2 0.884615 88.46 1.19838 0.387796 1.387796 349.3 0.923077 92.31 1.426077 0.461479 1.461479 302.8 0.961538 96.15 1.768825 0.572392 1.572392 265.4 0.999 99.90 3.090232 1 2 526.688
站Байду номын сангаас： 怀柔区
年份 1985 1994 1991 1987 1996 1998 1982 1986 1984 1988 1990 1989 2003 2001 1995 1979 1981 1983 1992 1993 1997 2002 2000 1980 1999 计算参数 系列样本 年份 789.8 753.6 744.6 658.4 647.7 645.9 643.3 639.4 634.7 614.5 560.6 530.2 508.4 489.4 483.2 460 456.5 434.4 434.4 402.6 364.9 353.2 349.3 302.8 265.4 526.688 均值 1985 1994 1991 1987 1996 1998 1982 1986 1984 1988 1990 1989 2003 2001 1995 1979 1981 1983 1992 1993 1997 2002 2000 1980 1999 样本排序 序号 25 789.8 1 753.6 2 744.6 3 658.4 4 647.7 5 645.9 6 643.3 7 639.4 8 634.7 9 614.5 10 560.6 11 530.2 12 508.4 13 489.4 14 483.2 15 460 16 456.5 17 434.4 18 434.4 19 402.6 20 364.9 21 353.2 22 349.3 23 302.8 24 265.4 25 0.277535 25 Cv值 系列数 n