高朝贤, 杨学琴, 李丽梅, 张文, 冯文艇, 易娟, 惠长野. 采用Excel软件拟合辐射生物剂量-效应曲线的方法初探[J]. 职业卫生与应急救援, 2023, 41(1): 108-112. DOI: 10.16369/j.oher.issn.1007-1326.2023.01.023
引用本文: 高朝贤, 杨学琴, 李丽梅, 张文, 冯文艇, 易娟, 惠长野. 采用Excel软件拟合辐射生物剂量-效应曲线的方法初探[J]. 职业卫生与应急救援, 2023, 41(1): 108-112. DOI: 10.16369/j.oher.issn.1007-1326.2023.01.023
GAO Chaoxian, YANG Xueqing, LI Limei, ZHANG wen, FENG Wenting, YI Juan, HUI Changye. Method of fitting radiation dose-effect curves with Excel software[J]. Occupational Health and Emergency Rescue, 2023, 41(1): 108-112. DOI: 10.16369/j.oher.issn.1007-1326.2023.01.023
Citation: GAO Chaoxian, YANG Xueqing, LI Limei, ZHANG wen, FENG Wenting, YI Juan, HUI Changye. Method of fitting radiation dose-effect curves with Excel software[J]. Occupational Health and Emergency Rescue, 2023, 41(1): 108-112. DOI: 10.16369/j.oher.issn.1007-1326.2023.01.023

采用Excel软件拟合辐射生物剂量-效应曲线的方法初探

Method of fitting radiation dose-effect curves with Excel software

  • 摘要:
      目的  探讨采用Excel软件拟合辐射生物剂量-效应曲线的方法。
      方法  基于最小二乘法和最大似然法的原理,在Excel中建立数据输入的方法,设计数据处理的公式,用最小二乘法函数拟合4种常用的辐射生物剂量-效应曲线,用最大似然法拟合二次多项式曲线,并分别与SPSS软件和CABAS软件拟合曲线比较;用Excel拟合曲线的方法验证教材和权威学术期刊中剂量-效应曲线拟合的示例,比较最小二乘法和最大似然法拟合的二次多项式曲线在剂量估算模拟应用上的差异。
      结果  用Excel设计的最小二乘法拟合出4种常用的辐射生物剂量-效应曲线,其参数与SPSS软件拟合的曲线一致,最大似然法拟合的二次多项式与CABAS软件拟合的曲线一致;用Excel拟合曲线的方法所得的曲线参数与文献中示例的曲线拟合参数一致。
      结论  Excel软件可用于辐射生物剂量-效应曲线的拟合和建立,方便实验室生物剂量估算,特别适合大批量样品的估算。

     

    Abstract:
      Objective  To explore the method of fitting radiation dose-effect curves with Excel software.
      Methods  Based on the principles of the least-squares method and maximum-likelihood method, a data-input method was established in Excel, and a data processing formula was designed. Four commonly used radiation dose-effect curves were fitted using the least-squares method, and a quadratic polynomial curve was fitted using the maximum-likelihood method. The obtained results were compared with the curves fitted using the SPSS software and CABAS methods, or with the verified examples of dose-response curve fitting in authoritative references, to evaluate the difference between the curves fitted by the least- squares method and the maximum-likelihood method in the application of dose estimation.
      Results  Four commonly used radiation dose-effect curves were successfully established with Excel software by the least-squares method, and their parameters were consistent with the curves fitted by using SPSS software; the quadratic polynomial curve established with Excel software by the maximum-likelihood method was consistent with the curve fitted by CABAS software; the parameters of curve fitting were the same as those of the examples in the reference.
      Conclusions  Excel software can be used to fit and establish a radiation biological dose effect curve, which is convenient for biological dose estimation in the laboratory, especially for the estimation of large batches of samples.

     

/

返回文章
返回