摘要
介绍了一种用Excel软件对均匀设计结果进行线性回归分析、建立最优方程的数据处理模型,用其可批量计算偏回归系数、偏回归平方和、偏相关系数等回归参数,用以分析各相关因子对指标的重要性或用于逐步法构建线性回归模型。整套模型构建方法简捷、直观、易懂,实用性较强。
The data processing models for linear regression analysis of the results of uniform design were introduced in this paper.These models were established with Excel software to select the optimal equation of the results of uniform design.The regression parameters,such as partial regression coefficient,partial regression square sum and partial correlation coefficient,could also be calculate in batch with these models to analyze the importance of independent variables to the dependent variables or establish stepwise linear regression models.The method of model establishing was simple,clear,easy to understand and quite practical.
作者
范步高
FAN Bugao(Shanghai Treeful Pharmaceutical Co.,Ltd.,Shanghai 201506)
出处
《中国医药工业杂志》
CAS
CSCD
北大核心
2013年第5期515-522,共8页
Chinese Journal of Pharmaceuticals
关键词
均匀设计
线性回归
偏回归系数
偏相关系数
计算机技术
uniform design
linear regression
partial regression coefficient
partial correlation coefficient
computer technology
