操作说明:1.填入因素水平表,在单元格G5选中指标类型(大为好,小为好,望目指标),若是望目指标要填入目标值2.按实验方案进行实验,将实验结果填入指标列3.根据"平方和分解结果"将方差贡献相对很小的因素标记"1",空列标记"0",即可得出全部分析结果因素水平表选择指标类型12345678910111213小为好因素名称ABCDE水平1(左端点)51.825.90.287385水平2(中点)52260.37590水平3(左端点)52.226.10.327795L27(313)实验方案列号12345678910111213因素x1因素x2因素x3因素x4因素x5因素x6因素x7因素x8因素x9因素x10因素x11因素x12因素x13y分析值实验结果优劣序填入指标值yyy显著性分析试验号统计列号ABCDE空列空列空列空列空列空列空列空列11111111111111000000000000011111均值y水平1九次和2141732202161902132062102172122172202232111122222222200000000000002262224.37037037y水平2九次和21622121422224120423922321223121922521331111333333333000000000000022622修正项y水平3九次和2282642242202272412132252292152222132224122211122233300000000000001931916035.7037y平方和分解12.74074074460.51851855.629629632.074074074154.296296382.7407407467.1851851914.7407407416.9629629623.185185191.4074074078.0740740746.740740741512222223331110000000000000281928St方差贡献率1.49%53.78%0.66%0.24%18.02%9.66%7.85%1.72%1.98%2.71%0.16%0.94%0.79%612223331112220000000000000241224856.2962963y极差149110651373315171951210713331113332220000000000000251525Se方(极)差贡献序81111223476513910813332221113330000000000000302130241.4814815填写列类型11100000000913333332221110000000000000332533fe可能好的参数组min任选25.9任选任选8510212312312312300000000000001111122模型内列的F值20.977607367.028527607112123231231231000000000000022622Mse入选列的显著性Pr0.00000.004412212331231231200000000000002262210.97643098132231123231312000000000000019319模型F值142231231312123000000000000030213014.003067481522313121232310000000000000241224模型显著性16231212331223100000000000002515250.00000817231223112331200000000000003021301823123122311230000000000000332533193132132132132000000000000022622203132213213213000000000000022622213132321321321000000000000019319223213132213321000000000000028192823321321332113200000000000002412242432133211322130000000000000251525253321132321213000000000000030213026332121313232100000000000003325332733213212131320000000000000251525因素水平表因素x1因素x2因素x3因素x4因素x5因素x6因素x7因素x8因素x9因素x10因素x11因素x12因素x13水平1(左端点)水平2(左端点)水平3(左端点)L27(313)二列间的交互作用12345678910111213322655988121111143