水文频率曲线简捷计算和绘图技巧

332002$∥332002$2002-02-269912010.1968.!φpKpExcelGAMMAINVφpKpExcelP-Ⅲ..!ExcelP-ⅢφpP333.9B1000-0860200207-0052-02530001P-Ⅲφp.φp1～3φpCs5.ExcelφpP-Ⅲ.1ExceIExcel.Excel2000300Г.2ExceIφp2.1!pP-Ⅲfx=βαГαx-a0α-1e-βx-a01xppXpX≥xp=∞xp!fxdx2t=βx-a012p=1Гα∞tp!tα-1e-tdt314α=4C2sφp=Cs2tp-2CsKp=φpCv+1xp=Kpx3ptpαCsxCvCsφpKpxp3tp31-p=1Гαtp0!tα-1e-tdt44Гtp4Г.2.2ГГtp13Excel.Excel=fxGAMMAINV.GAMMAINVГ3ProbabilityAlphaBeta.ProbabilityГ41-pAlphaα=4/Cs2Beta1ГBeta=1.GAMMAINV3Гtp.GAMMAINV±3×10-7.!#$%&$’()%*$’+,-.,%(/(0$%1+23+$$%3+24(56778(6952332002$∥100#N/A.tpφpKpxp.GAMMAINVφpxp13.3P-ⅢExcelP-Ⅲ.3.13.1.1.p=50%p=0.01%Lp=up-u0.01%5Lppuppu0.01%p=0.01%-3.719.upu0.01%ExcelNORMSINVpNORMSINV±3×10-7.3.1.2Excel.P=99.99%.x.0.00.0..3.2P-Ⅲ3.1.12.2...4Excel.A3A4B5ISO9001.1.P-ⅢφpJ.19972.2.ГJ.199912.3.ⅢJ.20011.4.M.1983.5.ExcelJ.20015.53