# 3501 Water Research Engineering

Autor:   •  February 3, 2016  •  Course Note  •  822 Words (4 Pages)  •  1,076 Views

Page 1 of 4

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

...

Download as:   txt (8.8 Kb)   pdf (594.3 Kb)   docx (559.8 Kb)
Continue for 3 more pages »