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 and lower limits of the estimated flood discharge with a certain probability, or level of confidence in the accuracy of the estimate. The standard error of prediction for the Connecticut peak-flow regression equations ranged from 26.3 to 45.0 percent (Ahearn and Hodgkins, 2020). The Excel workbook consists of four worksheets. The worksheets provide an overview of how the application works; input and output tables of the explanatory variables and flood discharges, and graphical display of the results; and the computational formulas used to estimate the flood discharges and prediction intervals.
Find Related Datasets
Search by Tags
Click any tag below to search for similar datasets
Complete Metadata
| @type | dcat:Dataset |
|---|---|
| accessLevel | public |
| bureauCode |
[ "010:12" ] |
| contactPoint |
{ "fn": "Elizabeth A Ahearn", "@type": "vcard:Contact", "hasEmail": "mailto:eaahearn@usgs.gov" } |
| description | 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 and lower limits of the estimated flood discharge with a certain probability, or level of confidence in the accuracy of the estimate. The standard error of prediction for the Connecticut peak-flow regression equations ranged from 26.3 to 45.0 percent (Ahearn and Hodgkins, 2020). The Excel workbook consists of four worksheets. The worksheets provide an overview of how the application works; input and output tables of the explanatory variables and flood discharges, and graphical display of the results; and the computational formulas used to estimate the flood discharges and prediction intervals. |
| distribution |
[ { "@type": "dcat:Distribution", "title": "Digital Data", "format": "XML", "accessURL": "https://doi.org/10.5066/P9EWHAYW", "mediaType": "application/http", "description": "Landing page for access to the data" }, { "@type": "dcat:Distribution", "title": "Original Metadata", "format": "XML", "mediaType": "text/xml", "description": "The metadata original format", "downloadURL": "https://data.usgs.gov/datacatalog/metadata/USGS.5e7e6ed3e4b01d5092771850.xml" } ] |
| identifier | http://datainventory.doi.gov/id/dataset/USGS_5e7e6ed3e4b01d5092771850 |
| keyword |
[ "USGS:5e7e6ed3e4b01d5092771850", "annual exceedance probability", "average standard error of prediction", "flood frequency", "prediction interval" ] |
| modified | 2020-10-02T00:00:00Z |
| publisher |
{ "name": "U.S. Geological Survey", "@type": "org:Organization" } |
| spatial | -73.7500, 40.9500, -71.7000, 42.1000 |
| theme |
[ "geospatial" ] |
| title | Worksheet for computing annual exceedance probability flood discharges and prediction intervals at stream sites in Connecticut |
