Excel在冻土力学指标分析中的应用

Application of Excel Software to Evaluating Mechanics Indicatrix of Frozen Soil

影响冻土力学性能的因素包括含水量、温度以及加载速率等,且因素间可能存在较强的交互作用。为了区分各因素对冻土力学性能影响的主次以及评估因素间的交互作用,利用Excel软件强大的数理统计功能和良好的可视化界面,制作了能自动分析各因素主次性和交互作用的数据分析模板,从而实现了设计与数据分析的动态可视化。该模板可以用来处理考虑交互作用的3因素3水平试验数据。通过该模板,不但能够节省计算工作量,而且能方便找出影响试验指标的主要因素,并能方便地得出交互作用效应。

Factors that affect the mechanical properties of frozen soil include water content,temperature and loading rate,etc.Further more,the strong interactions incurred by the factors listed above on mechanical properties of frozen soil may exist.In order to study the significance of the factors and the interactions among factors on evaluation,a data analysis template was established that can automatically analyze the two aspects by using the software of Excel for its powerful mathematical statistic function and the good visual interface of the software,the template can conveniently achieve the dynamic visualization of designing and analyzing.The template can be used to analyse the interaction of any orthogonal test data with three factors and 3 levels.By means of this template,the working amount of calculation can not only be saved,but also the main factor affecting test index can be conveniently found to reach interaction effects.