4. Use a damage-frequency relationship in given Table. Calculate damage reduction to decide on best option of flood protection, which provides maxim benefit. Please, use Excel to solve this problem. (10 points) Damage-Frequency Relationship Exceed Existing Dyke Upstream Probability Condition system diversion Channel Modification Detention Basin ($M) ($M) ($M) ($M) ($M) 0.2 0 0 0 0 0 0.1 9 0 0 0 0 0.07 15 0 0 0 0 0.05 19.5 11.7 1.8 4 6 0.02 33 19.8 9 12 20 0.01 45 27 18 18 24 0.005 60 36 27 27 42 0.002 75 45 38.7 40 60 0.001 81 48.6 42.3 43 70 0.0005 85.5 51.3 49.5 50 80