| 采用Excel软件拟合辐射生物剂量-效应曲线的方法初探 |
| |
| 引用本文： | 高朝贤,杨学琴,李丽梅,张文,冯文艇,易娟,惠长野.采用Excel软件拟合辐射生物剂量-效应曲线的方法初探[J].职业卫生与应急救援,2023,41(1):108-112. |
| |
| 作者姓名： | 高朝贤 杨学琴 李丽梅 张文 冯文艇 易娟 惠长野 |
| |
| 作者单位： | 深圳市职业病防治院, 广东 深圳 518020 |
| |
| 基金项目： | 广东省医学科学技术研究基金项目A2022230;深圳市科技研发基金JCYJ20190808175601651;深圳市卫生计生系统科研项目SZFZ2017089;深圳市医学重点学科2020—2024建设经费项目SZGSP015 |
| |
| 摘 要： | 目的探讨采用Excel软件拟合辐射生物剂量-效应曲线的方法。方法基于最小二乘法和最大似然法的原理,在Excel中建立数据输入的方法,设计数据处理的公式,用最小二乘法函数拟合4种常用的辐射生物剂量-效应曲线,用最大似然法拟合二次多项式曲线,并分别与SPSS软件和CABAS软件拟合曲线比较;用Excel拟合曲线的方法验证教材和权威学术期刊中剂量-效应曲线拟合的示例,比较最小二乘法和最大似然法拟合的二次多项式曲线在剂量估算模拟应用上的差异。结果用Excel设计的最小二乘法拟合出4种常用的辐射生物剂量-效应曲线,其参数与SPSS软件拟合的曲线一致,最大似然法拟合的二次多项式与CABAS软件拟合的曲线一致;用Excel拟合曲线的方法所得的曲线参数与文献中示例的曲线拟合参数一致。结论Excel软件可用于辐射生物剂量-效应曲线的拟合和建立,方便实验室生物剂量估算,特别适合大批量样品的估算。
|
| 关 键 词： | 辐射 剂量-效应曲线 染色体畸变 曲线拟合 |
| 收稿时间： | 2022-07-21 |
Method of fitting radiation dose-effect curves with Excel software |
| |
| 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. |
| |
| Keywords: | |
| 本文献已被 维普 等数据库收录！ |
| 点击此处可从《职业卫生与应急救援》浏览原始摘要信息 |
|
点击此处可从《职业卫生与应急救援》下载全文 |
|
