《數(shù)據(jù)處理考試C8-6》由會(huì)員分享,可在線閱讀,更多相關(guān)《數(shù)據(jù)處理考試C8-6(6頁珍藏版)》請(qǐng)?jiān)谘b配圖網(wǎng)上搜索。
1、因素水平編碼表:因素xjpH值x1/反應(yīng)時(shí)間x2/h反應(yīng)溫度x3上水平(1)6.56100下水平(-1)3.5260零水平(0)5480變化間距j1.5220選用正交表L8(27):試驗(yàn)號(hào)z1z2z3x1x211116.56211-16.5631-116.5241-1-16.525-1113.566-11-13.567-1-113.528-1-1-13.5290005410000541100054SUMMARY OUTPUT回歸統(tǒng)計(jì)Multiple R0.960362027R Square0.922295223Adjusted R Square 0.844590446標(biāo)準(zhǔn)誤差0.0479677
2、92一、(C8-6)某產(chǎn)品的副反應(yīng)(目標(biāo)值越小越好)的得率取決于反應(yīng)pHx1(3.56.5)、反應(yīng)時(shí)間x2(26h)、反應(yīng)溫度x3(60100),還要考慮因素x1與x2、x1與x3之間的交互作用。試驗(yàn)指標(biāo)Y為產(chǎn)量(g),越低越好。選用正交表L8(27)進(jìn)行一次回歸正交試驗(yàn),并安排3次零水平試驗(yàn)。試驗(yàn)結(jié)果依次為1.71,1.56,1.79,1.55,1.42,1.43,1.52,1.38,1.59,1.59,1.58。求:(1)因素水平編碼表;(2)正交表的選擇及試驗(yàn)方案的確定;(3)回歸方程的建立及因素x主次的判斷;(4)實(shí)驗(yàn)的最優(yōu)方案、最優(yōu)目標(biāo)值;(需有明確的規(guī)劃求解的設(shè)置)(5)驗(yàn)證實(shí)驗(yàn)的
3、說明。(100分)觀測值11方差分析dfSSMSFSignificance F回歸分析50.136550.02731 11.869220.008393993殘差50.011504545 0.00230091總計(jì)100.148054545Coefficients標(biāo)準(zhǔn)誤差t StatP-valueLower 95%Intercept1.384696970.270317026 5.12249261 0.0036990.689824932x1-0.0116666670.051811137-0.2251768 0.830756-0.144851435x2-0.0033333330.029509832-0
4、.11295670.91446-0.079190771x1x2-0.0008333330.005653059-0.1474128 0.888566-0.015364983x3-0.0021666670.002950983-0.7342186 0.495782-0.00975241x1x30.0010833330.000565306 1.91636674 0.113456-0.000369832可變單元格目標(biāo)單元格x1=3.51.403863636x2=6x3=60根據(jù)各因素所對(duì)應(yīng)的P-value絕對(duì)值的大小比較可知,各因素的主次順序?yàn)椋簒1x3x3x1x1x2x2。12131.38470.01
5、170.00330.00080.00220.0011.yxxxx所得的回歸方程為:規(guī)劃求解所得的優(yōu)方案為:pH值為3.5,反應(yīng)時(shí)間2h,反應(yīng)溫度60;與6號(hào)實(shí)驗(yàn)一致,重復(fù)6、8號(hào)實(shí)驗(yàn)方案,確定其是否為優(yōu)方案。x1x2x3x1x3得率/%391006501.7139603901.56131006501.7913603901.55211003501.421.46921602101.431.40471003501.527602101.381.42920804001.5920804001.5920804001.58根據(jù)SignificanceFx3x1x1x2x2。12131.38470.01170.00330.00080.00220.0011.yxxxx所得的回歸方程為:規(guī)劃求解所得的優(yōu)方案為:pH值為3.5,反應(yīng)時(shí)間2h,反應(yīng)溫度60;與6號(hào)實(shí)驗(yàn)一致,重復(fù)6、8號(hào)實(shí)驗(yàn)方案,確定其是否為優(yōu)方案。根據(jù)SignificanceF0.01可知,建立的回歸方程非常顯著。根據(jù)P-value的值均大于0.05可知,x1(pH值)、x2(反應(yīng)時(shí)間)、x3(反應(yīng)溫度)、x1x3(pH值與反應(yīng)溫度的交互作用)及x1x2(pH值與反應(yīng)時(shí)間的交互作用)對(duì)y(得率)的影響均不顯著。