Excel回归分析应用于混凝土配合比和强度预测

用Excel对双掺粉煤灰和矿粉的不同配比混凝土进行了回归分析,建立了混凝土强度、胶砂强度和水胶比以及不同龄期混凝土强度之间的回归方程,结果显示这些回归方程具有较好的线性相关关系,试验研究对双掺粉煤灰和矿粉混凝土的配制和强度预测具有一定的指导意义。

Application of the Excel regression analysis on concrete mixing ratio and strength prediction

It gets regression analysis on the different mixing ratio concrete with double mixed fly ash and mineral powder based on the Excel,establishes the regression equation between concrete strength,motar strength,water gel and different concrete strength with different age,results show that these regression equations have better linear corresponding relationship,the test research has certain guiding significance on the mixing and strength prediction of the double mixed fly ash and mineral powder.