Question: Use Excel to solve it easier the problem below. Send the file here. Test Content 1. Infiltration capacity data obtained in a flooding-type infiltration test
Use Excel to solve it easier the problem below. Send the file here.



Test Content 1. Infiltration capacity data obtained in a flooding-type infiltration test given below: Time . 5 10 15 25 45 60 75 90 110 130 {min) Cumul ative Depth {cm) 1.75 3.00 3.95 5.50 7.25 8.30 9.30 10.20 11.28 12.36 Obtain the best values of the parameters in Horton's infiltration capacity equation to represent the data set. Note: Horton's equation is applicable from time 0 to t.. therefore, do not consider points corresponding to fc. (f: is the steady-state infiltration capacity value) fc=3.2cm/h Question 1 15 Points Horton's Equation Initial Infiltration Capacity, fy in cm/h Round to the nearest two (2) decimal places Do not include units 18.78 Integer, decimal, or E notation allowed Question 2 15 Points Horton's Equation Horton's Decay Coefficient Round to the nearest four (4) decimal places Do not include units 4.5330 Integer, decimal, or E notation allowedQuestion 3 Kostiakov's Equation a (alpha) Round to the nearest four (4) decimal places Do not include units Add your answer Integer, decimal, or E notation allowed Question 4 Kostiakov's Equation Kk Round to the nearest four (4) decimal places Do not include units Add your answer Integer, decimal, or E notation allowed 15 Points 15 Points
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
