万能正交试验分析表.xls

试验设计区设定P值：0.050.05极显著P值：0.010.01列号1234567891011实验效应因素名称甲甲乙乙丙丙丁丁戊戊1122226.256.252122224.974.973133334.544.544144447.537.535212345.545.546221435.505.5072341211.4011.4082432110.9010.9093134210.7510.75103243111.3511.3511331249.259.2512342138.608.60134142311.4011.40144231410.9010.90154324110.7510.75164413211.3511.351718192021222324252627数据处理区1242.21140.98甲乙丙丁戊T123.2927.6926.1030.9033.00T233.3438.9736.1142.7744.72T339.9535.9437.0932.7830.04T444.4038.3841.6834.5333.22T12542.42766.74681.21954.811089.00T221111.561518.661303.931829.271999.88T321596.001291.681375.671074.53902.40T421971.361473.021737.221192.321103.57T21305.341683.371699.341683.641698.28k15.829.238.7010.3011.00k28.347.797.228.558.94k39.998.999.278.207.51K411.109.6010.428.638.31R16.6611.2810.9911.8711.72R值判定最小！误差列？计算结果区差差异异源源甲甲乙乙丙丙丁丁戊戊误误差差项项SSSS63.12663.126441.158441.158457.134457.134441.434441.434456.073456.073#n n3 33 33 33 33 30 0DFDF21.041841721.0418417 147.05277147.05277 152.37806152.37806 147.144681147.144681 152.024258152.024258#DIV/0!#DIV/0!F F值值#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!P P值值#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!评评价价：#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!使使用用说说明明：1 1、适适用用L L2727(4(41111)以以内内的的所所有有正正交交设设计计(含含拟拟水水平平设设计计，不不包包括括混混合合设设计计)，请请将将做做好好的的正正交交表表和和试试验验结结果果直直接接输输入入绿绿色色区区域域。2 2、接接收收P P值值由由试试验验者者自自行行选选定定，默默认认为为0.05/0.01.0.05/0.01.3 3、水水平平只只能能用用1 1、2 2、3 3、4 4表表示示，其其他他灰灰色色区区域域不不得得做做任任何何更更改改。4 4、蓝蓝色色区区域域为为数数据据处处理理区区和和图图表表，可可直直接接复复制制后后，粘粘贴贴到到WORDWORD文文档档。5 5、当当评评价价为为“不不显显著著，请请删删除除SS”SS”时时，请请删删除除本本列列对对应应的的SSSS值值。当当多多列列同同时时出出现现删删除除要要求求时时，应应先先从从F F值值小小的的列列删删。6 6、当当实实验验水水平平数数小小于于4 4时时，请请删删除除对对应应的的水水平平的的T T值值，此此时时，图图表表方方能能正正确确显显示示。7 7、任任何何非非绿绿色色区区域域误误修修改改或或删删除除SSSS后后，请请选选定定其其他他对对应应的的区区域域，用用拉拉“十十”法法复复制制还还原原。8 8、采采用用无无空空白白列列试试验验时时，无无法法进进行行方方差差分分析析，请请选选择择R R值值最最小小的的一一列列，删删除除SSSS值值。k1k2k3K40.00 5.00 10.00 15.00 20.00 25.00 30.00 35.00 40.00 45.00 50.00 甲乙丙丁戊数据处理区k1k2k3K40.00 5.00 10.00 15.00 20.00 25.00 30.00 35.00 40.00 45.00 50.00 甲乙丙丁戊X239.062524.700920.611656.700930.691630.2500129.9600118.8100115.5625128.822585.562573.9600129.9600118.8100115.5625128.82251347.85总总误误差差105.640105.6401515k1k2k3K40.00 5.00 10.00 15.00 20.00 25.00 30.00 35.00 40.00 45.00 50.00 甲乙丙丁戊k1k2k3K40.00 5.00 10.00 15.00 20.00 25.00 30.00 35.00 40.00 45.00 50.00 甲乙丙丁戊（1）L4（23）列号123试验号1111212232124221(2)L8(27)列号1234567试验号1111111121112222312211224122221152121212621221217221122182212112(3)L12(211)列号12345678试验号111111111211111222311222111412122122512212212612221221721221122821212221921122212102221111211221212111222112121（4）L9（34）列号1234试验号111112122231333421235223162312731328321393321（5）L16（45）列号12345试验号111111212222313333414444521234622143723412824321931342103243111331241234213134142314423141543241164413291011111222222112121211121112211212122221