CIVL 526/626

SURFACE WATER HYDROLOGY

Topic 1 - SP 1A - Storm Rainfall Analysis

The recent storm rainfall of December 14, 2014 as recorded at the Los Angeles County

Public Works Headquarters Building recording rain gauge is provided as an Excel file as part of

the assignment. This is the same data that was discussed in class. The spreadsheet shows

the maximum 5-minute and 10-minute rainfall periods.

a. Using the same procedure develop the maximum 15 minute, 20 minute and 30

minute rainfall amounts and show them similarly on the Excel spreadsheet.

b. Determine the rainfall intensities, in/hr, for the 15 minute, 20 minute and 30 minute

rainfall durations in part a)

c. Plot the 15 minute, 20 minute and 30 minute along with the 5 minute and 10 minute

intensities. Y-axis as Rainfall Intensity, in/hr, and x-axis as Rainfall Duration, minutes.

d. Insert a reasonable trendline. Note it will not be linear; so experiment with other

forms. Show the equation and the correlation coefficient R², on the graph (an option

in Excel)