混凝土试验的数据处理具有数据量大、计算过程繁琐,且容易出错的特点。本文针对这些特点,借助Excel技术,结合混凝土抗压强度与龄期的实例,进行回归分析,并判断其相关程度,完成计算分析、统计检验及预测,并在此基础上建立回归模型。此方法使回归预测分析的计算过程更简捷,统计方法更为实用。 The data processing of concrete test has the characteristics of large amount of data, complicated calculation process, and error-prone. In this paper, according to these characteristics, with Excel technology, combined with the examples of concrete compressive strength and age, regression analysis, and determine the degree of correlation, the completion of calculation and analysis, statistical testing and prediction, and on this basis to establish a regression model. This method makes the calculation process of regression prediction analysis more simple and the statistical method is more practical.