3501 Water Research Engineering
Autor: thilininw • February 3, 2016 • Course Note • 822 Words (4 Pages) • 1,448 Views
University of New South Wales
School of Civil and Environmental Engineering
CVEN3501
Water Resources Engineering
[pic 1]
Assignment Two
Lecturer: Dr Fiona Johnson
Thilini Wanigathunga
Z3417035
Question 1
Firstly, all the flow values in each year were separated into separate tables. Then using the excel function: =MAX(A:A) in each column, the max flow value was found.
The Max flow values were then organised into a table as shown below from highest to lowest using the SORT command on excel and each given a rank (m).
YEAR | FLOW | Flow (highest-lowest) | RANK |
1990 | 72.64 | 307.26 | 1 |
1991 | 21.13 | 119.89 | 2 |
1992 | 28.9 | 101.4 | 3 |
1993 | 14.41 | 99.89 | 4 |
1994 | 7.44 | 72.64 | 5 |
1995 | 61.59 | 61.59 | 6 |
1996 | 119.89 | 32.24 | 7 |
1997 | 32.24 | 29.51 | 8 |
1998 | 3.83 | 28.9 | 9 |
1999 | 101.4 | 27.05 | 10 |
2000 | 27.05 | 21.13 | 11 |
2001 | 307.26 | 19.98 | 12 |
2002 | 5.41 | 14.41 | 13 |
2003 | 19.98 | 7.44 | 14 |
2004 | 99.89 | 5.41 | 15 |
2005 | 29.51 | 3.83 | 16 |
...