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

站名：怀柔区正态分布-3.09023231-2.87816174-2.71338341-2.5758293-2.32634787-2.05374891-1.88079361-1.64485363-1.28155157-0.84162123-0.67448975-0.52440051-0.2533471-1.3921E-160.2533471030.5244005130.674489750.8416212341.0364333891.2815515661.6448536271.8807936082.3263478743.090232306相对距离-1-0.93137-0.87805-0.83354-0.75281-0.66459-0.60863-0.53228-0.41471-0.27235-0.21827-0.1697-0.08198-4.5E-170.0819830.1696960.2182650.2723490.335390.414710.5322750.6086250.7528071P-Ⅲ型曲线适线表频率坐标理论值XpKpΦ(0.750)01185.5746882.2514.170.0686261124.7422242.13553.7850.1219481079.71042.053.50.1664611042.5788961.97953.2650.247193977.7962721.85652.8550.335406909.853521.72752.4250.391375868.7718561.64952.1650.467725815.8397121.5491.830.58529737.6265441.40051.3350.727651650.7230241.23550.7850.781735619.1217441.17550.5850.830304593.0506881.1260.420.918017547.2288321.0390.131506.93720.9625-0.1251.081983469.0156640.8905-0.3651.169696431.884160.82-0.61.218265412.133360.7825-0.7251.272349392.382560.745-0.851.33539367.8915680.6985-1.0051.41471341.030480.6475-1.1751.532275305.479040.58-1.41.608625282.5681120.5365-1.5451.752807246.226640.4675-1.7752198.0346880.376-2.08适线 Cs：0.75计算 Cv均值0.277535适线 Cv526.6880.3倍比2.5频率P(%)频率 P0.10.0010.20.0020.3330.003330.50.00510.0120.0230.0350.05100.1200.2250.25300.3400.4500.5600.6700.7750.75800.8850.85900.9950.95970.97990.9999.90.999参数项选择参数年数(n)25图1-3：通州区(1956-2000)年降水量频率曲线图

P-Ⅲ型曲线适线表: n统计参数均值Cv25526.69单位：(mm)保证率 (P)Cs/CvP=20%P=50%P=75%P=95%0.32.5650.7506.9412.1305.5F(0.7)F(0.8)4.14.243.723.853.453.553.223.312.822.892.42.452.152.181.821.841.331.340.790.780.590.580.430.410.140.12-0.12-0.13-0.36-0.37-0.6-0.6-0.72-0.73-0.85-0.85-1.01-1-1.18-1.17-1.42-1.38-1.57-1.52-1.81-1.74-2.14-2.020.70.8皮尔逊-Ⅲ型频率曲线离均系数Φ值表频率P(%)F(0.0)F(0.1)F(0.2)F(0.3)F(0.4)F(0.5)0.13.093.233.383.523.673.810.22.8833.123.243.363.480.3332.712.822.923.033.143.250.52.582.672.762.862.953.0412.332.42.472.542.622.6822.052.112.162.212.262.3131.881.921.9622.042.0851.641.671.71.731.751.77101.281.291.31.311.321.32200.840.840.830.820.820.81250.670.660.650.640.640.62300.520.510.50.480.470.46400.250.240.220.20.190.17500-0.02-0.03-0.05-0.07-0.0860-0.25-0.27-0.28-0.3-0.31-0.3370-0.52-0.53-0.55-0.56-0.57-0.5875-0.67-0.68-0.69-0.7-0.71-0.7180-0.84-0.85-0.85-0.85-0.85-0.8585-1.04-1.04-1.03-1.03-1.03-1.0290-1.28-1.27-1.26-1.24-1.23-1.2295-1.64-1.62-1.59-1.55-1.52-1.4997-1.88-1.84-1.79-1.75-1.7-1.6699-2.33-2.25-2.18-2.1-2.03-1.9699.9-3.09-2.95-2.81-2.67-2.54-2.4 Cs 值00.10.20.30.40.5F(0.6)F(0.7)F(0.8)F(0.9)F(1.0)F(1.1)F(1.2)F(1.3)F(1.4)F(1.5)

3.964.14.244.394.534.674.814.955.095.233.63.723.853.974.094.24.324.444.564.683.353.453.553.653.763.863.954.054.154.243.133.223.313.43.493.583.663.743.833.912.752.822.892.963.023.093.153.213.273.332.352.42.452.52.542.582.622.672.712.742.122.152.182.222.252.282.312.342.372.391.81.821.841.861.881.891.911.921.941.951.331.331.341.341.341.341.341.341.331.330.80.790.780.770.760.740.730.720.710.690.610.590.580.570.550.540.520.510.490.470.440.430.410.40.380.360.350.330.310.30.160.140.120.110.090.070.050.040.020-0.1-0.12-0.13-0.15-0.16-0.18-0.19-0.21-0.22-0.24-0.34-0.36-0.37-0.38-0.39-0.41-0.42-0.43-0.44-0.45-0.59-0.6-0.6-0.61-0.62-0.62-0.63-0.63-0.64-0.64-0.72-0.72-0.73-0.73-0.73-0.74-0.74-0.74-0.73-0.73-0.85-0.85-0.85-0.85-0.85-0.84-0.84-0.83-0.82-0.82-1.02-1.01-1-0.99-0.98-0.97-0.96-0.95-0.93-0.92-1.2-1.18-1.17-1.15-1.13-1.1-1.08-1.06-1.04-1.02-1.45-1.42-1.38-1.35-1.32-1.28-1.24-1.2-1.17-1.13-1.61-1.57-1.52-1.47-1.42-1.38-1.33-1.28-1.23-1.19-1.88-1.81-1.74-1.66-1.59-1.52-1.45-1.38-1.32-1.26-2.27-2.14-2.02-1.9-1.79-1.68-1.58-1.48-1.39-1.310.60.70.80.911.11.21.31.41.5

F(1.6)F(1.7)F(1.8)F(1.9)F(2.0)F(2.1)F(2.2)F(2.3)F(2.4)F(2.5)

5.375.55.645.775.916.046.176.36.426.554.84.915.015.125.225.335.435.535.635.734.344.434.524.614.74.794.884.975.055.133.994.074.154.234.34.374.444.514.584.653.393.443.53.553.613.663.713.763.813.852.782.822.852.882.912.932.962.993.023.042.422.442.462.492.512.532.552.562.572.591.961.971.981.9922222.012.011.331.321.321.311.31.291.281.271.261.250.680.660.640.630.610.590.570.550.540.520.460.440.420.40.390.370.350.330.310.290.280.260.240.220.20.190.170.150.130.11-0.02-0.03-0.05-0.07-0.08-0.1-0.11-0.13-0.15-0.16-0.25-0.27-0.28-0.29-0.31-0.32-0.33-0.34-0.35-0.36-0.46-0.47-0.48-0.48-0.49-0.49-0.5-0.5-0.51-0.51-0.64-0.64-0.64-0.64-0.64-0.64-0.64-0.64-0.63-0.63-0.73-0.72-0.72-0.72-0.71-0.71-0.7-0.69-0.68-0.67-0.81-0.81-0.8-0.79-0.78-0.76-0.75-0.74-0.72-0.71-0.9-0.89-0.87-0.85-0.84-0.82-0.8-0.78-0.77-0.75-0.99-0.97-0.94-0.92-0.895-0.869-0.844-0.82-0.795-0.772-1.1-1.06-1.02-0.98-0.949-0.914-0.879-0.849-0.82-0.791-1.14-1.1-1.06-1.01-0.97-0.935-0.9-0.865-0.83-0.8-1.2-1.14-1.09-1.04-0.989-0.945-0.905-0.867-0.831-0.8-1.24-1.17-1.11-1.05-0.999-0.952-0.909-0.87-0.833-0.81.61.71.81.922.12.22.32.42.5

F(2.6)F(2.7)F(2.8)F(2.9)F(3.0)F(3.1)6.676.796.917.037.157.265.825.926.016.16.26.35.25.285.365.445.515.594.724.784.844.94.965.023.893.933.974.014.054.083.063.093.113.133.153.172.62.612.622.632.642.642.012.012.012.01221.231.221.211.21.181.160.50.480.460.440.420.40.270.250.230.210.190.170.090.080.060.040.030.01-0.17-0.18-0.2-0.21-0.22-0.24-0.37-0.37-0.38-0.39-0.39-0.4-0.51-0.51-0.51-0.51-0.51-0.51-0.62-0.61-0.61-0.6-0.59-0.58-0.66-0.65-0.64-0.63-0.62-0.6-0.7-0.68-0.67-0.66-0.64-0.62-0.73-0.71-0.69-0.67-0.65-0.63-0.748-0.726-0.702-0.68-0.658-0.639-0.764-0.736-0.71-0.687-0.665-0.644-0.769-0.74-0.714-0.69-0.667-0.645-0.769-0.74-0.714-0.69-0.667-0.645-0.769-0.741-0.714-0.69-0.667-0.6452.62.72.82.933.1