13. You've probably heard that Hurricane Harvey was a 100+ year storm event. However, your current graph doesn't show that. In your data, what is the recurrence interval for the flooding from Hurricane Harvey, and why isn't it over 100? 14. Using your trendline equation, we can calculate what the discharge of a 100year event should be. You know what m, x, and b are in the equation, just substitute the values. What is the discharge for the 100year event based on the trendline? 15. The discharge in Buffalo Bayou for Hurricane Harvey was 32,600 cfs, which is very different from the 100year discharge you calculated in question 14. So, what is the true recurrence interval for a discharge of 32,600 based on your equation? For this question, we'll need to solve for x in the line equation instead of y because now we know what y {32,600 cfs} is and need to figure out :4. You can manipulate the line equation variables to isolate x; we've done this on several previous assignments. Enter this equation in excel =exp((yb)/m) and substitute the values accordingly. What is the true recurrence interval for the stream discharge associated with Hurricane Harvey? Date ( water Recurrence Interval [8] Peak Discharge (cls) |Rank A-[N+1/m 4/24/1949 3,420 67 10/3/1949 6500 35 TEST/BL/E 1700 73 4/14/1952 2320 5/18/1953 4800 53 B/2/1954 4020 57 2/3/1955 2310 69 1/23/1956 820 74 3/19/1957 2800 64 10/18/1957 7300 27 4/12/1959 6060 37 6/23/1960 7270 26 2/18/1961 42 6/4/1962 4310 56 11/27/1962 2630 67 3/3/1964 2650 66 12/10/19 64 1920 72 4/14/1956 5150 50 9/21/1967 2100 70 5/10/1968 4400 55 2/21/1969 DEGZ 63 5/21/1970 4050 10/27/1970 7320 25 3/21/1972 9300 15 ELOT/ET/9 8570 19 PLOT/ET/G 6070 36 6/10/1975 DETS 47 6/15/1976 5650 45 9/3/1977 2810 65 6/7/1978 4A 9/19/1979 9310 14 1/72/1530 3630 59 8/31/1931 8530 17 5/13/1932 5770 41 8/18/1983 8490 20 1/9/1934 2040 71 10/25/1984 6800 32 11/24/1535 5670 43 7/9/1537 5270 49 3/17/1538 3560 61 5/18/1989 9000 16 4/36/1590 4520 54 4/5/1941 4840 52 3/4/1942 12500 3/1/1993 6710 11/16/1943 5890 40 10/18/1994 8450 21 12/18/1945 5370 48 3/12/1547 7650 23 13400 6 11/13/1948 7550 24 4/12/2000 3560 6/9/2001 14000 5 8/15/20 02 7160 28 10/29/2002 8630 1B 11/17/2003 10100 11 11/73/2004 6060 37 12/14/2006 6800 32 10/16/2006 9350 13 9/13/2008 10100 11 4/23/2009 10900 10 7/2/2010 7940 22 12/29/2010 5540 46 1/9/2012 7160 28 9/21/2013 6940 31 10/31/2013 5920 39 5/26/2015 17400 4/18/2016 15700 8/23/2017 32600 7/4/2018 12000 72 9/19/2019 20900 9/22/2020 DOCE 8/19/2021 5060 51 1/9/2022 7120 30 77