常用正交试验计算表_显著性判断及表头安排等

1、试验号nL11L1L21L2L31L3K值统计222条件区L1L2L3333L1L2L344因素k123水平114121#因素水平表水平2水平31683tt水平4水平数222Df111表头设计表头设计列号kABAXB试验号nLlL2L311112111312241225212621272218910111213正交表15161718192021222324221结果1kij225262728293031N888Kl14.512.414.9K215.317.414.9K3000K4000Klj2210.25153.76222.01K2j2234.09302.76222.01K3j2000K4j2

2、000KX2154.1538.5257.67KX2260.1575.7856.63KX23000KX24000T29.8CT111.005QT114.3SST3.29532结果2rflSSj0.08003.12500.0000df111r.=竺Jdf.0.083.1250Mse*SSe0.0100将小于空列的均方的2倍的SSj加入Sse其自由度加入dfe,计算MSE*dfe4.0000Mse*0.0025F32125001F判据0.05F0.01FF判据结论异常显著异常显著不显著Qj111.085114.13111.005参考资料:http：/wenkubaiducom/view.使用方法:图

3、例说明:1、在因素水平表填入各水平2、在正交表中填入选择的正交表形式，常用正交表在常用正交表、交互作用表、表头设计中选取粘贴3、填入试验结果4、在K值计算区域输入希望统计的结果列名称5、手工更改MSE*的计算与F判据的两个自由度选项6、获得显著与否的结论7、正交表的使用及数据处理参考资料见上不建议更改的部分需要判断，更改的部分根据需要更改的部分L4L5L6L7L8L9LIOLil11111111L4L5L6L7L8L9LIOLil22222222L4L5L6L7L8L9LIOLil33333333L4L5L6L7L8L9LIOLil444444445678910ii11111111222200

4、0011110000cAXCBXC一一一一一L4L5L6L7L8L9L10L111111222211222211121221211221211213531cb00c22590102029dc2.html8888000015.314.814.915000014.51514.914.800000000000000000000234.09219.04222.012250000210.25225222.01219.040000000000000000000060.1556.256.6358.02000054.1558.157.6756.2800000000000000000000111.085111.

5、01111.005111.01#DIV/0!#DIV/0!#DIV/0!#DIV/0!0.08000.00500.00000.0050#DIV/0!#DIV/0!#DIV/0!#DIV/0!111100000.080.00500.005#DIV/0!#DIV/0!#DIV/0!#DIV/0!32202#DIV/0!I#DIV/0!I#DIV/0!I#DIV/0!1195.1173550291910.56143105异常显著不显著不显著不显著#DIV/0!#DIV/0!#DIV/0!#DIV/0!L12L13L14L151111L12L13L14L152222L12L13L14L153333L12L13L14L1544441213141500000000L12L13L14L15结果1结果2结果3结果2618.4118.4917.6489结果2212.2510.2417.641611.521.1624.014.34.618.4921.1600000000000000000000000000000000iO/Aia#iO/Aia#iO/Aia#iO