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
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);
Conference_Titel :
Mechanic Automation and Control Engineering (MACE), 2011 Second International Conference on
Conference_Location :
Hohhot
Print_ISBN :
978-1-4244-9436-1
DOI :
10.1109/MACE.2011.5987599
