方差分析完整

方差分析報(bào)告,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

請(qǐng)?jiān)谇嗌珔^(qū)域中輸入測(cè)試數(shù)據(jù)，進(jìn)行分析時(shí)請(qǐng)選擇紅色框內(nèi)的區(qū)域！,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

數(shù)據(jù)表,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,評(píng)價(jià)人,,,,,,,,,,,均值,,,極差,,,總均值,,,加和,,,總和,,,,,,

零件號(hào),A1,A2,A3,B1,B2,B3,C1,C2,C3,,,A,B,C,A,B,C,總均值,零件數(shù),K3,A,B,C,,,,,,,

1,0.29,0.41,0.64,0.08,0.25,0.07,0.04,-0.11,-0.15,,,0.446666667,0.133333333,-0.073333333,0.35,0.18,0.19,0.168888889,10,0.3146,1.34,0.40,-0.22,1.52,序號(hào),平均值,極差,A,B,C

2,-0.56,-0.68,-0.58,-0.47,-1.22,-0.68,-1.38,-1.13,-0.96,,,-0.606666667,-0.79,-1.156666667,0.12,0.75,0.42,-0.851111111,,,-1.82,-2.37,-3.47,-7.66,1,0.446666667,0.35,0.29,0.08,0.04

3,1.34,1.17,1.27,1.19,0.94,1.34,0.88,1.09,0.67,,,1.26,1.156666667,0.88,0.17,0.40,0.42,1.098888889,,,3.78,3.47,2.64,9.89,2,-0.606666667,0.12,0.41,0.25,-0.11

4,0.47,0.50,0.64,0.01,1.03,0.20,0.14,0.20,0.11,,,0.536666667,0.413333333,0.15,0.17,1.02,0.09,0.366666667,,,1.61,1.24,0.45,3.30,3,1.26,0.17,0.64,0.07,-0.15

5,-0.80,-0.92,-0.84,-0.56,-1.20,-1.28,-1.46,-1.07,-1.45,,,-0.853333333,-1.013333333,-1.326666667,0.12,0.72,0.39,-1.064444444,,,-2.56,-3.04,-3.98,-9.58,4,0.536666667,0.17,-0.56,-0.47,-1.38

6,0.02,-0.11,-0.21,-0.20,0.22,0.06,-0.29,-0.67,-0.49,,,-0.1,0.026666667,-0.483333333,0.23,0.42,0.38,-0.185555556,,,-0.30,0.08,-1.45,-1.67,5,-0.853333333,0.12,-0.68,-1.22,-1.13

7,0.59,0.75,0.66,0.47,0.55,0.83,0.02,0.01,0.21,,,0.666666667,0.616666667,0.08,0.16,0.36,0.20,0.454444444,,,2.00,1.85,0.24,4.09,6,-0.1,0.23,-0.58,-0.68,-0.96

8,-0.31,-0.20,-0.17,-0.63,0.08,-0.34,-0.46,-0.56,-0.49,,,-0.226666667,-0.296666667,-0.503333333,0.14,0.71,0.10,-0.342222222,,,-0.68,-0.89,-1.51,-3.08,7,0.666666667,0.16,1.34,1.19,0.88

9,2.26,1.99,2.01,1.80,2.12,2.19,1.77,1.45,1.87,,,2.086666667,2.036666667,1.696666667,0.27,0.39,0.42,1.94,,,6.26,6.11,5.09,17.46,8,-0.226666667,0.14,1.17,0.94,1.09

10,-1.36,-1.25,-1.31,-1.68,-1.62,-1.50,-1.49,-1.77,-2.16,,,-1.306666667,-1.6,-1.806666667,0.11,0.18,0.67,-1.571111111,,,-3.92,-4.80,-5.42,-14.14,9,2.086666667,0.27,1.27,1.34,0.67

,,,,,,,,,,,,均值,,,,,,,,,,,,,10,-1.306666667,0.11,0.47,0.01,0.14

零件數(shù)=,10,評(píng)價(jià)人數(shù)=,3,試驗(yàn)次數(shù)=,3,,,刪除交互作用水平=,0.25,,,0.190333333,0.068333333,-0.254333333,0.184,0.513,0.328,0.001444444,,,5.71,2.05,-7.63,,11,0.133333333,0.18,0.50,1.03,0.20

變異乘數(shù)=,6,過程公差=,8,歷史標(biāo)準(zhǔn)差=,,,,顯著性水平=,0.05,,,CLX,0.001444444,0.001444444,XDiff,0.444666667,EV,0.201856667,%EV,17.61,,,,,12,-0.79,0.75,0.64,0.20,0.11

,,,,,,,,,,,,UCLX,0.350969444,0.350969444,Rp,3.511111111,AV,0.229667029,%AV,20.04,,,,,13,1.156666667,0.40,-0.80,-0.56,-1.46

中間計(jì)算,,,,,,,,,,,,LCLX,-0.348080556,-0.348080556,,,GRR,0.305766346,%GRR,26.68,,,,,14,0.413333333,1.02,-0.92,-1.20,-1.07

平均值,0.00,,,,,,,,,,,CLR,0.341666667,0.341666667,,,PV,1.104595556,%PV,96.38,,,,,15,-1.013333333,0.72,-0.84,-1.28,-1.45

總和,0.13,,,,,,,,,,,X軸,1,10,,,TV,1.146134547,,,,,,,16,0.026666667,0.42,0.02,-0.20,-0.29

,,,,,,,,,,,,UCLR,0.87945,0.87945,,,,,,,,,,,17,0.616666667,0.36,-0.11,0.22,-0.67

方差分析表,,,,,,,,,,,,LCLR,,,,,,,,,,,,,18,-0.296666667,0.71,-0.21,0.06,-0.49

變差來源,,,自由度,平方和,平均平方和,F統(tǒng)計(jì)量,F0,p值,顯著性,,,X軸,1,30,,,,,,,,,,,19,2.036666667,0.39,0.59,0.47,0.02

評(píng)價(jià)人,,,2,3.167262222,1.583631111,79.4060492,3.150411311,1.38803E-17,*,,,,,,,,,,,,,,,,20,-1.6,0.18,0.75,0.55,0.01

零件,,,9,88.36193444,9.817992716,492.2914227,2.040098055,9.31284E-53,*,,,,,,,,,,,,,,,,21,-0.073333333,0.19,0.66,0.83,0.21

交互作用,,,18,0.358982222,0.019943457,0.43372103,1.778446085,0.974106404,-,,,,,,,,,,,,,,,,22,-1.156666667,0.42,-0.31,-0.63,-0.46

設(shè)備,,,60,2.758933333,0.045982222,,,,,,,,,,,,,,,,,,,,23,0.88,0.42,-0.20,0.08,-0.56

總計(jì),,,89,94.64711222,,,,,,,,,,,,,,,,,,,,,24,0.15,0.09,-0.17,-0.34,-0.49

,,,,,,,,,,,,,,,,,,,,,,,,,25,-1.326666667,0.39,2.26,1.80,1.77

方差分析表(合并交互影響到設(shè)備中),,,,,,,,,,,,,,,,,,,,,,,,,26,-0.483333333,0.38,1.99,2.12,1.45

變差來源,,,自由度,平方和,平均平方和,F統(tǒng)計(jì)量,F0,p值,顯著性,,,,,,,,,,,,,,,,27,0.08,0.20,2.01,2.19,1.87

評(píng)價(jià)人,,,2,3.167262222,1.583631111,39.61724571,3.11379226,1.33759E-12,*,,,,,,,,,,,,,,,,28,-0.503333333,0.10,-1.36,-1.68,-1.49

零件,,,9,88.36193444,9.817992716,245.6139104,2.002244714,2.02101E-53,*,,,,,,,,,,,,,,,,29,1.696666667,0.42,-1.25,-1.62,-1.77

設(shè)備,,,78,3.117915556,0.039973276,,,,,,,,,,,,,,,,,,,,30,-1.806666667,0.67,-1.31,-1.50,-2.16

總計(jì),,,89,94.64711222,,,,,,,,,,,,,,,,,,,,,,,,,,

方差分析變差和貢獻(xiàn)的百分比,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

交互作用不顯著,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

方差估計(jì),,6(σ),,標(biāo)準(zhǔn)偏差,方差,%總變差,%貢獻(xiàn),%過程公差,"%過程

標(biāo)準(zhǔn)偏差",,,,,,,,,,,,,,,,,,,,,

"τ^2=0.03997

(重復(fù)性)",,EV=,1.199599078,0.19993318,0.039973276,18.42,3.39,14.99,,,,,,,,,,,,,,,,,,,,,,

"ω^2=0.05146

(評(píng)價(jià)人)",,AV=,1.361025129,0.226837521,0.051455261,20.9,4.37,17.01,,,,,,,,,,,,,,,,,,,,,,

"γ^2=0

(交互作用)",,INT=,0,0,0,0,0,0,,,,,,,,,,,,,,,,,,,,,,

系統(tǒng)=0.09143,,GRR=,1.814229134,0.302371522,0.091428538,27.86,7.76,22.