AllFreePapers.com - All Free Papers and Essays for All Students
Search

3501 Water Research Engineering

Autor:   •  February 3, 2016  •  Course Note  •  822 Words (4 Pages)  •  757 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 »