EXCEL多元回归分析在痕迹数据处理上的应用

The EXCEL Multiple Regression Forecast in the Trace Data Analysis

在痕迹检验技术中,很多推算公式是由回归分析预测法得出的。多元回归分析预测法的计算,虽然可以用常用计算器进行统计,但是数据复杂繁琐,工作量较大。Excel是一种办公系统软件,运用它的强大数据分析功能,只输入一次原始数据,而后全部以鼠标操作即可自动生成回归方程。文章以一组足迹数据分析为例,首先介绍相关分析,然后建立回归模型,最后计算出相关的回归方程。

In the trace examination technology, many calculating formulas are obtained by the regression analysis premeasurement. Although multiple regression analysis pre - measurement computation may use the commonly used calculator to carry on the statistics, the data are complex and tedious, the work load is bigger. Excel is one kind of work system software, utilizes its formidable data analysis function, only inputs a time of primary data, then completes automatic production regression equation by mouse operation. This article takes a group of trails traces data analysis as an example, first introduces the correlation analysis, then establishes return model, last counts correlation regression equation.