Dataset for: Step-by-Step Calculation and Spreadsheet Tools for Predicting Stressor Levels that Extirpate Genera and Species
Susan Cormier
Lei Zheng
Erik W Leppo
Andrew Hamilton
10.6084/m9.figshare.5500201
https://wiley.figshare.com/articles/dataset/Dataset_for_Step-by-Step_Calculation_and_Spreadsheet_Tools_for_Predicting_Stressor_Levels_that_Extirpate_Genera_and_Species/5500201
In 2011, the U.S. Environmental Protection Agency (USEPA) released a field-based method for estimating the extirpation of freshwater aquatic benthic invertebrates by ionic mixtures dominated by HCO<sub>3</sub><sup>−</sup>, SO<sub>4</sub><sup>2−</sup>, and Ca<sup>2+</sup> measured as specific conductivity (SC). The estimate of extirpation was SC at the 95th centile (XC<sub>95</sub>) of a weighted cumulative frequency distribution (CFD) of a genus or species over a range of SC. A CFD of XC<sub>95</sub> values was used to predict the SC at which 5% of genera were likely to be extirpated. Because there are many uses for XC<sub>95</sub> values and many data sets that could be analyzed using this method, we laid out a step-by-step method for calculating XC<sub>95</sub> values and the stressor level that predicts a 5% extirpation of genera (HC<sub>05</sub>). Although the calculations can be done with a hand-held calculator, we provide access to 2 downloadable Microsoft Excel® spread sheet calculation tools that are easy to use to calculate XC<sub>95</sub> values, to plot a taxon’s XC<sub>95</sub> cumulative frequency distribution with increasing SC, and to plot probabilities of observing a taxon at a particular SC. They also plot cumulative frequency distributions of XC<sub>95</sub> values and calculate HC<sub>05</sub> values. In addition to the tools, we share an example and the output of XC<sub>95</sub> values for 176 distinct aquatic benthic invertebrates in Central Appalachia.
2017-11-10 06:25:17
Extirpation
Conductivity
Analysis Tool
Sensitivity Distribution
Stream
Environmental Management
Environmental Science
Environmental Impact Assessment
Ecological Impacts of Climate Change
Environmental Monitoring