使用Excel进行有交互作用的正交设计方差分析

Variance Analysis with Excel for Interacted-Orthogonal Design

随着试验因素和水平数的增加,试验组合数也将增多,利用正交表来安排试验能够在一定的试验规模内安排尽可能多的因素。利用Excel对有交互作用的正交设计的试验结果进行方差分析能够极大地节省工作量,方便找出影响试验的主要因素和水平。并且Excel还能将处理方法保存为模板,以便以后修改应用。

Combinations of test are increasing with the increased factors and levels.Planning experiments with orthogonal table could ar-range factors and levels as much as possible in an experiment with certain scale.Variance analysis data of interacted-orthogonal design with excel could save workload significantly.Main factor and level affected experiment could be found in this way.Processing methods in excel could be saved as model for later application.