摘要
目的探讨采用Excel软件拟合辐射生物剂量-效应曲线的方法。方法基于最小二乘法和最大似然法的原理,在Excel中建立数据输入的方法,设计数据处理的公式,用最小二乘法函数拟合4种常用的辐射生物剂量-效应曲线,用最大似然法拟合二次多项式曲线,并分别与SPSS软件和CABAS软件拟合曲线比较;用Excel拟合曲线的方法验证教材和权威学术期刊中剂量-效应曲线拟合的示例,比较最小二乘法和最大似然法拟合的二次多项式曲线在剂量估算模拟应用上的差异。结果用Excel设计的最小二乘法拟合出4种常用的辐射生物剂量-效应曲线,其参数与SPSS软件拟合的曲线一致,最大似然法拟合的二次多项式与CABAS软件拟合的曲线一致;用Excel拟合曲线的方法所得的曲线参数与文献中示例的曲线拟合参数一致。结论Excel软件可用于辐射生物剂量-效应曲线的拟合和建立,方便实验室生物剂量估算,特别适合大批量样品的估算。
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.
作者
高朝贤
杨学琴
李丽梅
张文
冯文艇
易娟
惠长野
GAO Chaoxian;YANG Xueqing;LI Limei;ZHANG wen;FENG Wenting;YI Juan;HUI Changye(Shenzhen Prevention and Treatment Center for Occupational Diseases,Shenzhen,Guangdong 518020,China)
出处
《职业卫生与应急救援》
2023年第1期108-112,126,共6页
Occupational Health and Emergency Rescue
基金
广东省医学科学技术研究基金项目(A2022230)
深圳市科技研发基金(JCYJ20190808175601651)
深圳市卫生计生系统科研项目(SZFZ2017089)
深圳市医学重点学科2020—2024建设经费项目(SZGSP015)。
关键词
辐射
剂量-效应曲线
染色体畸变
曲线拟合
radiation
dose-effect curve
chromosome aberration
curves fitting
作者简介
高朝贤(1978-),男,大学本科,副主任技师;通信作者:惠长野,主任技师,E-mail:hcy_sypu@163.com。
