1-The attached excel file includes 30-year daily precipitation data. Based on your student number find your...

Transcribed Image Text:

1-The attached excel file includes 30-year daily precipitation data. Based on your student number find your column number from the table below and separate your data in the excel file and: 1) Sort the precipitation data from largest to smallest, (2) separate the topmost 5% of them, and (3) find the relationship between precipitation depth and return period by using all formula given in the table below. (do like the example in Page 28 of the 2nd part of the lecture notes) No.:: 1 2 x|m 3 4 S 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 229 28 30 Student number No.: 180406131 31 190406113 32 200406145 33 190406185 200406019 180406119 190406057 180406033 190406071 200406589 190406099 190406045 190406181 190406001 200406129 200406917 200406407 190406063 180406041 190406017 190406081 190406127 190406105 190406103 190406111 190406141 190406175 190406093 190406101 180406079 34 35 36 37 T 38 L 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 Student number 180406905 190406041 190406133 210406877 190406125 190406219 190406135 190406037 200406741 210406375 200406135 190406167 180406107 180406057 190406019 200406853 190406053 180406913 200406919 190406193 190406077 180406071 190406067 170406015 190406151 190406087 210406373 190406147 190406049 1-The attached excel file includes 30-year daily precipitation data. Based on your student number find your column number from the table below and separate your data in the excel file and: 1) Sort the precipitation data from largest to smallest, (2) separate the topmost 5% of them, and (3) find the relationship between precipitation depth and return period by using all formula given in the table below. (do like the example in Page 28 of the 2nd part of the lecture notes) No.:: 1 2 x|m 3 4 S 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 229 28 30 Student number No.: 180406131 31 190406113 32 200406145 33 190406185 200406019 180406119 190406057 180406033 190406071 200406589 190406099 190406045 190406181 190406001 200406129 200406917 200406407 190406063 180406041 190406017 190406081 190406127 190406105 190406103 190406111 190406141 190406175 190406093 190406101 180406079 34 35 36 37 T 38 L 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 Student number 180406905 190406041 190406133 210406877 190406125 190406219 190406135 190406037 200406741 210406375 200406135 190406167 180406107 180406057 190406019 200406853 190406053 180406913 200406919 190406193 190406077 180406071 190406067 170406015 190406151 190406087 210406373 190406147 190406049

Answer rating: 100% (QA)

Step 1 Sort the precipitation data from largest to smallest To sort the precipitation data from larg... View the full answer