Worksheet for computing annual exceedance probability flood discharges and prediction intervals at stream sites in Connecticut

The U.S. Geological Survey (USGS), in cooperation with Connecticut Department of Transportation, completed a study to improve flood-frequency estimates in Connecticut. This companion data release is a Microsoft Excel workbook for: (1) computing flood discharges for the 50- to 0.2-percent annual exceedance probabilities from peak-flow regression equations, and (2) computing additional prediction intervals, not available through the USGS StreamStats web application. The current StreamStats application (version 4) only computes the 90-percent prediction interval for stream sites in Connecticut. The Excel workbook can be used to compute the 70-, 80-, 90-, 95-, and 99-percent prediction intervals. The prediction interval provides upper [...]