运用Excel进行逐步回归在体育研究中的应用

The use of Excel for the Application of Stepwise Regression in Sports Research

介绍运用Microsoft office的组件之一,办公软件Excel"数据分析"工具,对体育统计数据逐步回归分析的简便操作方法;参照基于相关系数矩阵进行公式计算的逐步回归结果,进行数据对比,处理结果完全一致;相比采用Linest、Trend等Excel函数计算逐步回归方程的方法,同样具有明显的效率优势,操作性能更加优越;应用Excel"数据分析"工具进行逐步回归分析,工作界面熟悉,操作简便快捷,数据结果可靠,可广泛应用于体育研究,以及其它领域的多元回归分析。

One use Microsoft office components,office software Excel ＂Data analysis＂ tool of sports statistics stepwise regression analysis method is simple,reference stepwise regression formula to calculate the results based on the correlation coefficient matrix,comparing the data processing exactly the same result：compared to using the method Linest,Trend and other Excel function calculates regression equation,also has significant efficiency advantages,superior operating performance;application Excel ＂data Analysis＂ tool stepwise regression analysis,the working interface familiar,easy to operate fast,reliable data the results can be widely used in sports research, as well as other areas of multivariate regression analysis.