DocumentCode
2803868
Title
Application of excel in hydrologic frequency computation
Author
Meng, Caixia ; Xu, Fang ; Zhang, Yi
Author_Institution
Sch. of River & Ocean Eng., Chongqing Jiaotong Univ., Chongqing, China
fYear
2011
fDate
15-17 July 2011
Firstpage
2922
Lastpage
2925
Abstract
Because of the complex in calculating with coefficient Φ in P-III frequency curve and the difficultin planning with normal probability paper in existing frequency computation, so excel cannot be applied directly to the frequency computation. Plan the normal probability paper in existing frequency computation using the the formidable graph function of Excel software, calculate the coefficient Φ in P-III frequency curve using of Excel software built-in functions. Practice shows that this method is accurate, Application easy, is artistic for charting, and has better practical values.
Keywords
geophysics computing; hydrological techniques; Excel software; P-III frequency curve coefficient; formidable graph function; hydrologic frequency computation; normal probability analysis; Educational institutions; Presses; Probability; Software; Soil; Water conservation; Water resources; Excel; coefficient Ø; frequency curve; probability diagram);
fLanguage
English
Publisher
ieee
Conference_Titel
Mechanic Automation and Control Engineering (MACE), 2011 Second International Conference on
Conference_Location
Hohhot
Print_ISBN
978-1-4244-9436-1
Type
conf
DOI
10.1109/MACE.2011.5987599
Filename
5987599
Link To Document