P-III曲线水文频率计算Excel程序表格文件下载.xls

P-III曲线水文频率计算Excel程序表格文件下载.xls

《P-III曲线水文频率计算Excel程序表格文件下载.xls》由会员分享，可在线阅读，更多相关《P-III曲线水文频率计算Excel程序表格文件下载.xls（10页珍藏版）》请在冰点文库上搜索。

站站名名：

@#@怀柔区经验频率计算表年份系列样本年份样本排序序号经验频率P（%）正态分布相对距离频率坐标样本系列250.0010.10-3.09023-101985789.81985789.810.0384623.85-1.76883-0.572390.427608789.81994753.61994753.620.0769237.69-1.42608-0.461480.538521753.61991744.61991744.630.11538511.54-1.19838-0.38780.612204744.61987658.41987658.440.15384615.38-1.02008-0.33010.669903658.41996647.71996647.750.19230819.23-0.86942-0.281350.718654647.71998645.91998645.960.23076923.08-0.73632-0.238270.761728645.91982643.31982643.370.26923126.92-0.61514-0.199060.80094643.31986639.41986639.480.30769230.77-0.5024-0.162580.837423639.41984634.71984634.790.34615434.62-0.39573-0.128060.871943634.71988614.51988614.5100.38461538.46-0.29338-0.094940.905062614.51990560.61990560.6110.42307742.31-0.19403-0.062790.937212560.61989530.21989530.2120.46153846.15-0.09656-0.031250.968754530.22003508.42003508.4130.550.00-1.4E-16-4.5E-171508.42001489.42001489.4140.53846253.850.0965590.0312461.031246489.41995483.21995483.2150.57692357.690.1940280.0627881.062788483.219794601979460160.61538561.540.2933810.0949381.0949384601981456.51981456.5170.65384665.380.3957250.1280571.128057456.51983434.41983434.4180.69230869.230.5024020.1625771.162577434.41992434.41992434.4190.73076973.080.6151410.199061.19906434.41993402.61993402.6200.76923176.920.7363160.2382721.238272402.61997364.91997364.9210.80769280.770.8694240.2813461.281346364.92002353.22002353.2220.84615484.621.0200760.3300971.330097353.22000349.32000349.3230.88461588.461.198380.3877961.387796349.31980302.81980302.8240.92307792.311.4260770.4614791.461479302.81999265.41999265.4250.96153896.151.7688250.5723921.572392265.4计算参数526.6880.277535250.99999.903.09023212526.688均值Cv值系列数n站站名名：

@#@怀柔区P-型曲线适线表频频率率P（%）P（%）频率P正态分布相对距离频率坐标理理论论值值XpXpKp（0.750）F（0.7）F（0.7）0.10.10.001-3.09023-101185.5751185.5752.2514.174.10.20.20.002-2.87816-0.931370.0686261124.7421124.7422.13553.7853.720.3330.3330.00333-2.71338-0.878050.1219481079.711079.712.053.53.450.50.50.005-2.57583-0.833540.1664611042.5791042.5791.97953.2653.22110.01-2.32635-0.752810.247193977.7963977.79631.85652.8552.82220.02-2.05375-0.664590.335406909.8535909.85351.72752.4252.4330.03-1.88079-0.608630.391375868.7719868.77191.64952.1652.15550.05-1.64485-0.532280.467725815.8397815.83971.5491.831.8210100.1-1.28155-0.414710.58529737.6265737.62651.40051.3351.3320200.2-0.84162-0.272350.727651650.723650.7231.23550.7850.7925250.25-0.67449-0.218270.781735619.1217619.12171.17550.5850.5930300.3-0.5244-0.16970.830304593.0507593.05071.1260.420.4340400.4-0.25335-0.081980.918017547.2288547.22881.0390.130.1450500.5-1.4E-16-4.5E-171506.9372506.93720.9625-0.125-0.1260600.60.2533470.0819831.081983469.0157469.01570.8905-0.365-0.3670700.70.5244010.1696961.169696431.8842431.88420.82-0.6-0.675750.750.674490.2182651.218265412.1334412.13340.7825-0.725-0.7280800.80.8416210.2723491.272349392.3826392.38260.745-0.85-0.8585850.851.0364330.335391.33539367.8916367.89160.6985-1.005-1.0190900.91.2815520.414711.41471341.0305341.03050.6475-1.175-1.1895950.951.6448540.5322751.532275305.479305.4790.58-1.4-1.4297970.971.8807940.6086251.608625282.5681282.56810.5365-1.545-1.5799990.992.3263480.7528071.752807246.2266246.22660.4675-1.775-1.8199.999.90.9993.09023212198.0347198.03470.376-2.08-2.14适适线线CsCs：

@#@0.750.750.70.7参数项年数（n）计算Cv均值适线Cv倍比选择参数25250.2775350.277535526.688526.6880.30.32.52.5图1-3：

@#@通州区（1956-2000）年降水量频率曲线图P-型曲线适线表:

@#@单位：

@#@（mm）统计参数保证率（P）n均值CvCs/CvP=20%P=50%P=75%P=95%25526.690.32.5650.7506.9412.1305.5皮尔逊-型频率曲线离均系数值表F（0.8）F（0.8）频频率率P（%）P（%）F（0.0）F（0.0）F（0.1）F（0.1）F（0.2）F（0.2）F（0.3）F（0.3）F（0.4）F（0.4）F（0.5）F（0.5）F（0.6）F（0.6）F（0.7）F（0.7）4.240.10.13.093.233.383.523.673.813.964.13.850.20.22.8833.123.243.363.483.63.723.550.3330.3332.712.822.923.033.143.253.353.453.310.50.52.582.672.762.862.953.043.133.222.89112.332.42.472.542.622.682.752.822.45222.052.112.162.212.262.312.352.42.18331.881.921.9622.042.082.122.151.84551.641.671.71.731.751.771.81.821.3410101.281.291.31.311.321.321.331.330.7820200.840.840.830.820.820.810.80.790.5825250.670.660.650.640.640.620.610.590.4130300.520.510.50.480.470.460.440.430.1240400.250.240.220.20.190.170.160.14-0.1350500-0.02-0.03-0.05-0.07-0.08-0.1-0.12-0.376060-0.25-0.27-0.28-0.3-0.31-0.33-0.34-0.36-0.67070-0.52-0.53-0.55-0.56-0.57-0.58-0.59-0.6-0.737575-0.67-0.68-0.69-0.7-0.71-0.71-0.72-0.72-0.858080-0.84-0.85-0.85-0.85-0.85-0.85-0.85-0.85-18585-1.04-1.04-1.03-1.03-1.03-1.02-1.02-1.01-1.179090-1.28-1.27-1.26-1.24-1.23-1.22-1.2-1.18-1.389595-1.64-1.62-1.59-1.55-1.52-1.49-1.45-1.42-1.529797-1.88-1.84-1.79-1.75-1.7-1.66-1.61-1.57-1.749999-2.33-2.25-2.18-2.1-2.03-1.96-1.88-1.81-2.0299.999.9-3.09-2.95-2.81-2.67-2.54-2.4-2.27-2.140.80.8CsCs值值000.10.10.20.20.30.30.40.40.50.50.60.60.70.7F（0.8）F（0.8）F（0.9）F（0.9）F（1.0）F（1.0）F（1.1）F（1.1）F（1.2）F（1.2）F（1.3）F（1.3）F（1.4）F（1.4）F（1.5）F（1.5）F（1.6）F（1.6）F（1.7）F（1.7）F（1.8）F（1.8）4.244.394.534.674.814.955.095.235.375.55.643.853.974.094.24.324.444.564.684.84.915.013.553.653.763.863.954.054.154.244.344.434.523.313.43.493.583.663.743.833.913.994.074.152.892.963.023.093.153.213.273.333.393.443.52.452.52.542.582.622.672.712.742.782.822.852.182.222.252.282.312.342.372.392.422.442.461.841.861.881.891.911.921.941.951.961.971.981.341.341.341.341.341.341.331.331.331.321.320.780.770.760.740.730.720.710.690.680.660.640.580.570.550.540.520.510.490.470.460.440.420.410.40.380.360.350.330.310.30.280.260.240.120.110.090.070.050.040.020-0.02-0.03-0.05-0.13-0.15-0.16-0.18-0.19-0.21-0.22-0.24-0.25-0.27-0.28-0.37-0.38-0.39-0.41-0.42-0.43-0.44-0.45-0.46-0.47-0.48-0.6-0.61-0.62-0.62-0.63-0.63-0.64-0.64-0.64-0.64-0.64-0.73-0.73-0.73-0.74-0.74-0.74-0.73-0.73-0.73-0.72-0.72-0.85-0.85-0.85-0.84-0.84-0.83-0.82-0.82-0.81-0.81-0.8-1-0.99-0.98-0.97-0.96-0.95-0.93-0.92-0.9-0.89-0.87-1.17-1.15-1.13-1.1-1.08-1.06-1.04-1.02-0.99-0.97-0.94-1.38-1.35-1.32-1.28-1.24-1.2-1.17-1.13-1.1-1.06-1.02-1.52-1.47-1.42-1.38-1.33-1.28-1.23-1.19-1.14-1.1-1.06-1.74-1.66-1.59-1.52-1.45-1.38-1.32-1.26-1.2-1.14-1.09-2.02-1.9-1.79-1.68-1.58-1.48-1.39-1.31-1.24-1.17-1.110.80.80.90.9111.11.11.21.21.31.31.41.41.51.51.61.61.71.71.81.8F（1.9）F（1.9）F（2.0）F（2.0）F（2.1）F（2.1）F（2.2）F（2.2）F（2.3）F（2.3）F（2.4）F（2.4）F（2.5）F（2.5）F（2.6）F（2.6）F（2.7）F（2.7）F（2.8）F（2.8）F（2.9）F（2.9）5.775.916.046.176.36.426.556.676.796.917.035.125.225.335.435.535.635.735.825.926.016.14.614.74.794.884.975.055.135.25.285.365.444.234.34.374.444.514.584.654.724.784.844.93.553.613.663.713.763.813.853.893.933.974.012.882.912.932.962.993.023.043.063.093.113.132.492.512.532.552.562.572.592.62.612.622.631.9922222.012.012.012.012.012.011.311.31.291.281.271.261.251.231.221.211.20.630.610.590.570.550.540.520.50.480.460.440.40.390.370.350.330.310.290.270.250.230.210.220.20.190.170.150.130.110.090.080.060.04-0.07-0.08-0.1-0.11-0.13-0.15-0.16-0.17-0.18-0.2-0.21-0.29-0.31-0.32-0.33-0.34-0.35-0.36-0.37-0.37-0.38-0.39-0.48-0.49-0.49-0.5-0.5-0.51-0.51-0.51-0.51-0.51-0.51-0.64-0.64-0.64-0.64-0.64-0.63-0.63-0.62-0.61-0.61-0.6-0.72-0.71-0.71-0.7-0.69-0.68-0.67-0.66-0.65-0.64-0.63-0.79-0.78-0.76-0.75-0.74-0.72-0.71-0.7-0.68-0.67-0.66-0.85-0.84-0.82-0.8-0.78-0.77-0.75-0.73-0.71-0.69-0.67-0.92-0.895-0.869-0.844-0.82-0.795-0.772-0.748-0.726-0.702-0.68-0.98-0.949-0.914-0.879-0.849-0.82-0.791-0.764-0.736-0.71-0.687-1.01-0.97-0.935-0.9-0.865-0.83-0.8-0.769-0.74-0.714-0.69-1.04-0.989-0.945-0.905-0.867-0.831-0.8-0.769-0.74-0.714-0.69-1.05-0.999-0.952-0.909-0.87-0.833-0.8-0.769-0.741-0.714-0.691.91.9222.12.12.22.22.32.32.42.42.52.52.62.62.72.72.82.82.92.9F（3.0）F（3.0）F（3.1）F（3.1）7.157.266.26.35.515.594.965.024.054.083.153.172.642.64221.181.160.420.40.190.170.030.01-0.22-0.24-0.39-0.4-0.51-0.51-0.59-0.58-0.62-0.6-0.64-0.62-0.65-0.63-0.658-0.639-0.665-0.644-0.667-0.645-0.667-0.645-0.667-0.645333.13.10.10.20.512510203040506070809095989999.599.899.921.510.5002004006008001000120014001600180020002200240026002800300032003400360038004000频率P（%）年降水量（mm）统计参数保证率（P）Cs/CvCv均值nP=20%P=50%P=75%P=95%25526.690.32.5650.7506.9412.1305.5P-型曲线适线表:

@#@单位：

@#@（mm）图1-3：

@#@通州区（1956-2000）年降水量频率曲线图0.3频率坐标标注频率P（%）重现期频率P正态分布相对距离频率坐标频率标注0.10.1100010000.0010.001-3.09023-3.09023-1-100000.25000.002-2.87816-0.931370.06862600.52000.005-2.57583-0.833540.166461011000.01-2.32635-0.752810.24719302500.02-2.05375-0.664590.33540605200.05-1.64485-0.532280.467725010100.1-1.28155-0.414710.5852902050.2-0.84162-0.272350.7276510303.3333330.3-0.5244-0.16970.8303040402.50.4-0.25335-0.081980.91801705020.5-1.4E-16-4.5E-1710601.6666670.60.2533470.0819831.0819830701.4285710.70.5244010.1696961.1696960801.250.80.8416210.2723491.2723490901.1111110.91.2815520.414711.414710951.0526320.951.6448540.5322751.5322750981.0204080.982.0537490.6645941.6645940991.0101010.992.3263480.7528071.752807099.51.0050250.9952.5758290.8335391.833539099.81.0020040.9982.8781620.9313741.931374099.999.91.0010011.0010010.9990.9993.0902323.090232112200YY轴轴坐坐标标上上下下限限：

@#@Xp下限0频率坐标网格表Xp上限4000频率P（%）重现期频率P正态分布相对距离频率坐标频率网格0.10.1100010000.0010.001-3.09023-3.09023-1-100000.25000.002-2.87816-0.931370.06862600.25000.002-2.87816-0.931370.06862640000.3333.33330.003-2.74778-0.889180.11081700.3333.33330.003-2.74778-0.889180.11081740000.42500.004-2.65207-0.858210.1417900.42500.004-2.65207-0.858210.1417940000.52000.005-2.57583-0.833540.16646100.52000.005-2.57583-0.833540.166461400011000.01-2.32635-0.752810.247193011000.01-2.32635-0.752810.24719340002500.02-2.05375-0.664590.33540602500.02-2.05375-0.664590.3354064000333.333330.03-1.88079-0.608630.3913750333.333330.03-1.88079-0.608630.39137540004250.04-1.75069-0.566520.43347804250.04-1.75069-0.566520.43347840005200.05-1.64485-0.532280.46772505200.05-1.64485-0.532280.4677254000616.666670.06-1.55477-0.503130.4968750616.666670.06-1.55477-0.503130.4968754000714.285710.07-1.47579-0.477570.5224340714.285710.07-1.47579-0.477570.5224344000812.50.08-1.40507-0.454680.5453180812.50.08-1.40507-0.454680.5453184000911.111110.09-1.34076-0.433870.5661310911.111110.09-1.34076-0.433870.56613140001010