Excel在贯入法检测砌筑砂浆抗压强度测强曲线回归分析中的应用  

Excel Application in the Mortar Strength Curvilinear of Compressive Strength Testing by Penetration Method

作　　者：丁玎 娄勇 

机构地区：[1]云南省建设工程质量检测中心有限公司,云南昆明650032

出　　处：《工程质量》2012年第3期8-9,共2页Construction Quality

摘　　要：通过对贯入法检测砌筑砂浆抗压强度回归方程的优化,将非线性方程转化为线性方程,并采用Excel对试验数据进行线性回归分析,确定回归系数,从而求解得到回归方程。由此拓展了Excel在回归分析中的应用,可为工程类试验数据的回归处理提供有益的借鉴和参考。Based on optimizing the regression equation of mortar compressive strength by the penetration testing method, the nonlinear equations turned into the linear equations, and using Excel to do linear regression analysis for the tested data to determine the regression coefficients and the regression equation was solved. Thus expanding the Excel application in the regression analysis, provide useful reference for the regression processing of engineering experimental data.

关 键 词：贯入法 抗压强度 回归分析 

分 类 号：TU578.1[建筑科学—建筑技术科学]