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