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.
Complete Metadata
| 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 |
