Monte Carlo simulation of parameter confidence intervals for non-linear regression analysis of biological data using Microsoft Excel
Monte Carlo simulation of parameter confidence intervals for non-linear regression analysis of biological data using Microsoft Excel
复制标题
DOI：
10.1016/j.cmpb.2011.05.009
复制
发表时间：
2012-08-01
影响因子：
6.1
通讯作者：
Brown, Angus M.
中科院分区：
文献类型：
--
作者：
Lambert, Ronald J. W.;Mytilinaios, Ioannis;Brown, Angus M.
本研究描述了一种方法，以获得参数的置信区间的拟合非线性函数的实验数据，使用SOLVER和分析ToolPaK插件的Microsoft Excel电子表格。以前我们已经表明，Excel可以适合复杂的多个函数的生物数据，获得的值相当于那些返回更专业的统计或数学软件。然而，使用Excel方法的缺点是无法返回计算参数的置信区间或它们之间的相关性。使用Excel电子表格中的简单蒙特-卡罗程序（无需编程），SOLVER可以为多个“虚拟”数据集提供参数估计（每次最多200个），从中可以获得所需的置信区间和相关系数。该方法的一般效用的例子，通过将其应用到单核细胞增生李斯特菌的生长的分析，铜绿假单胞菌的生长抑制氯己定和进一步分析的电生理数据从啮齿动物视神经的复合动作电位。(C)2011爱思唯尔爱尔兰有限公司保留所有权利。
This study describes a method to obtain parameter confidence intervals from the fitting of non-linear functions to experimental data, using the SOLVER and Analysis ToolPaK Add-In of the Microsoft Excel spreadsheet. Previously we have shown that Excel can fit complex multiple functions to biological data, obtaining values equivalent to those returned by more specialized statistical or mathematical software. However, a disadvantage of using the Excel method was the inability to return confidence intervals for the computed parameters or the correlations between them. Using a simple Monte-Carlo procedure within the Excel spreadsheet (without recourse to programming), SOLVER can provide parameter estimates (up to 200 at a time) for multiple 'virtual' data sets, from which the required confidence intervals and correlation coefficients can be obtained. The general utility of the method is exemplified by applying it to the analysis of the growth of Listeria monocytogenes, the growth inhibition of Pseudomonas aeruginosa by chlorhexidine and the further analysis of the electrophysiological data from the compound action potential of the rodent optic nerve. (C) 2011 Elsevier Ireland Ltd. All rights reserved.