<img height="1" width="1" style="display:none;" alt="" src="https://px.ads.linkedin.com/collect/?pid=384506&amp;fmt=gif">
Skip to content
    November 25, 2014

    CDD Vault Update: Averaging numbers with modifiers

    In this update we have changed the way numbers with modifiers (that is: >, <, ≥ and ≤) are aggregated. Numbers with modifiers are also referred to as bounded values, and this will mainly affect averages of IC50 measurements. The rule can be stated as: a bounded value will not be included when computing the average if there is another measurement that is consistent with it and is more specific. Exact values are always included.
    • Less specific bounded values are not included: Average(<1, <10) = <1 Average(20, 30, <100)  = 25 Average(80, <100, 150)  = 115 (<100 is consistent with 80 and less specific)
    • Bounded values are retained if they are not consistent with an exact value: Average(<2, 8) = <5
    This rule is based on how drug discovery data is normally generated. For example, if you perform a concentration-response assay between 100 to 10,000 nM, and the IC50 comes out as <100 nM, you will test at lower concentrations, say between 1 and 200 nM. If the IC50 in the second test was 80 nM, it makes sense to leave out the <100 nM from the first assay, because it has been superseded by the more specific 80 nM measurement. On the other hand, if you ran the 100 to 10,000 nM assay twice and the only IC50s you had were <100 and 120 nM, we shouldn't ignore the <100 nM, because doing so would result in a number that was artificially high. All existing data has been automatically recalculated following the new rule, which applies not only to averages, but to all aggregations, such as median and geometric mean.

    Other posts you might be interested in

    View All Posts
    CDD Blog
    8 min   March 1, 2024
    Drug Discovery Industry Roundup with Barry Bunin — March 1, 2024
    Read More
    CDD Vault Updates
    4 min   February 26, 2024
    CDD Vault Update (February 2024): New Models for LogD and LogP, Similarity Scores in Deep Learning, and Updated GET Users Call
    Read More
    CDD Blog
    2 min   February 14, 2024
    CDD Receives Malaria Antibody Data Management Grant
    Read More