Excel软件规划求解功能拟合与优选血清乙型肝炎病毒大蛋白质量浓度标准曲线被引量：1

The fitting and optimization of standard curve for determining concentration of serum hepatitis B virus large surface protein with program solution of Excel

原文传递

导出

摘要目的探讨拟合和优选血清乙型肝炎病毒大蛋白(HBV-LP)质量浓度标准曲线的一种简便的实用方法。方法HBV-LP标准品吸光度检测采用酶联免疫吸附试验,利用Excel软件规划求解功能对HBV-LP标准品质量浓度与吸光度进行四参数方程模型、线性模型、对数线性模型、二次多项式模型、三次多项式模型、S模型的曲线拟合,根据各回归模型决定系数的大小来确定测定血清HBV-LP质量浓度的最适标准曲线。结果HBV-LP标准品质量浓度与吸光度的散点图呈非线性趋势;四参数方程模型、线性模型、对数线性模型、二次多项式模型、三次多项式模型、S模型的回归方程均有意义(P<0.001),决定系数分别为0.9995、0.9249、0.8765、0.9975、0.9989、0.9799,其中四参数方程模型、二次多项式模型、三次多项式模型、S模型的拟合精度较好,以四参数方程模型最佳。结论Excel软件规划求解是一种具有较高临床实用价值的血清HBV-LP质量浓度标准曲线的拟合与优选方法;四参数方程模型的拟合标准曲线是测定血清HBV-LP质量浓度的最适标准曲线。 Objective To discuss a convenient and pragmatic method of fitting and optimizing standard curve for determining concentration of serum hepatitis B virus large surface protein(HBV-LP).MethodsEnzyme-linked immunosorbent assay(ELISA)was used to measure the absorbance of standard preparation of HBV-LP.Concentration and absorbance of standard preparation of HBV-LP was carried out curve fitting with 4-parameter formula model and linear model and log-linear model and quadratic polynomial model and cubic polynomial model and S model by program solution of Excel,respectively.The most standard curve for determining concentration of serum HBV-LP was determined with coefficient of determination of regression model.ResultsThe scatterplot of standard preparation of HBV-LP submited nonlinear tendency.There were all significance to regression equation of 4-parameter formula model and linear model and log-linear model and quadratic polynomial model and cubic polynomial model and S model(P<0.001),Coefficient of determination of those was 0.9995,0.9249,0.8765,0.9975,0.9989,0.9799,respectively.Precision of fitting was better to 4-parameter formula model and quadratic polynomial model and cubic polynomial model and S model,and especially 4-parameter formula model.ConclusionProgram solution of Excel is a higher clinical practical value method for fitting and optimizing concentration standard curve of serum HBV-LP.The fitting standard curve with 4-parameter formula model is the most standard curve for determining concentration of serum HBV-LP.

作者乐爱平李太原胡国信罗忠勤黄清水

机构地区南昌大学第一附属医院

出处《中国实用内科杂志》 CAS CSCD 北大核心 2008年第S1期58-61,共4页 Chinese Journal of Practical Internal Medicine

关键词肝炎病毒乙型大蛋白酶联免疫吸附试验标准曲线回归模型规划求解决定系数 hepatitis virus,B large surface protein enzym-linked immunosorbent assay standard curve regression model program solution coefficient of determination