摘要
目的:探讨应用Excel宏功能进行逐步回归分析,并与SPSS进行比较。方法安装Excel软件,加载宏,应用数据分析工具进行逐步回归分析,同时,对该数据应用SPSS进行逐步回归分析,对结果进行比较。结果两种方法结果一致。结论应用Excel宏功能进行逐步回归分析简便快捷可靠,方面广大医务工作者使用。
Abstract
Objective To survey application of Excellmicro function in regression analysis. Methods Install Microsoft office 2003 in computer, start excel, call ‘DATA analysis tools’, do linear regression analysis and multi-linear regression analysis. Results The results analyzed with Excellwere in accordance with textbook. Conclusions We can do regression analysis with Excel‘macro’function rapidly, Excellmay be used in medical analysis.