最近做的DOE数据老是失拟显著,但r2和调整r2都接近1,请问到底是什么原因造成?这种情况是否能够进行可靠的预测?
结果如下,原始数据见附件,求大神帮忙答疑解惑啊?
最小二乘法拟合
响应“acid peak”
“预测值-实际值”图
拟合汇总
R 方 0.976652
调整 R 方 0.940332
均方根误差 0.750289
响应均值 22.80292
观测数(或权重和) 24
方差分析
源 自由度 平方和 均方 F 比率
模型 14 211.92550 15.1375 26.8905
误差 9 5.06640 0.5629 概率>F
校正合计 23 216.99190 <.0001
失拟
源 自由度 平方和 均方 F 比率
失拟 7 5.0443295 0.720618 65.3129
纯误差 2 0.0220667 0.011033 概率>F
总误差 9 5.0663961 0.0152
最大 R 方
0.9999
参数估计值
项 估计值 标准误差 t 比率 概率>|t|
截距 22.716933 0.281461 80.71 <.0001
pH(5.7,6.2) 0.5839241 0.227893 2.56 0.0306
concentration(242,302) 0.5411463 0.227893 2.37 0.0416
load acid(23,28) 2.0963643 0.200437 10.46 <.0001
capacity(20,34) 3.102813 0.227893 13.62 <.0001
pH*concentration 0.3355256 0.325954 1.03 0.3302
pH*load acid -0.168975 0.264468 -0.64 0.5388
concentration*load acid -0.152725 0.264468 -0.58 0.5778
pH*capacity -0.563224 0.325954 -1.73 0.1181
concentration*capacity -0.599474 0.325954 -1.84 0.0990
load acid*capacity 0.253525 0.264468 0.96 0.3628
pH*pH -0.123733 0.474507 -0.26 0.8001
concentration*concentration -0.158733 0.474507 -0.33 0.7456
load acid*load acid 0.4812668 0.474507 1.01 0.3370
capacity*capacity -0.643733 0.474507 -1.36 0.2079
排序参数估计值
项 估计值 标准误差 t 比率 t 比率 概率>|t|
capacity(20,34) 3.102813 0.227893 13.62 ++++++++++ <.0001
load acid(23,28) 2.0963643 0.200437 10.46 ++++++++ <.0001
pH(5.7,6.2) 0.5839241 0.227893 2.56 ++ 0.0306
concentration(242,302) 0.5411463 0.227893 2.37 ++ 0.0416
concentration*capacity -0.599474 0.325954 -1.84 - 0.0990
pH*capacity -0.563224 0.325954 -1.73 - 0.1181
capacity*capacity -0.643733 0.474507 -1.36 - 0.2079
pH*concentration 0.3355256 0.325954 1.03 + 0.3302
load acid*load acid 0.4812668 0.474507 1.01 + 0.3370
load acid*capacity 0.253525 0.264468 0.96 + 0.3628
pH*load acid -0.168975 0.264468 -0.64 0.5388
concentration*load acid -0.152725 0.264468 -0.58 0.5778
concentration*concentration -0.158733 0.474507 -0.33 0.7456
pH*pH -0.123733 0.474507 -0.26 0.8001
响应“main peak”
“预测值-实际值”图
参数估计值
项 估计值 标准误差 t 比率 概率>|t|
截距 67.806615 0.212977 318.38 <.0001
pH(5.7,6.2) -1.25935 0.172443 -7.30 <.0001
concentration(242,302) -2.038239 0.172443 -11.82 <.0001
load acid(23,28) -1.654404 0.151667 -10.91 <.0001
capacity(20,34) -3.186572 0.172443 -18.48 <.0001
pH*concentration 0.6602612 0.246643 2.68 0.0253
pH*load acid 0.0520866 0.200118 0.26 0.8005
concentration*load acid 0.2258366 0.200118 1.13 0.2883
pH*capacity 0.1202612 0.246643 0.49 0.6375
concentration*capacity 0.3465112 0.246643 1.40 0.1936
load acid*capacity -0.241663 0.200118 -1.21 0.2580
pH*pH 0.0700774 0.359051 0.20 0.8496
concentration*concentration 0.7600774 0.359051 2.12 0.0634
load acid*load acid -0.294923 0.359051 -0.82 0.4326
capacity*capacity 0.8250774 0.359051 2.30 0.0472
排序参数估计值
项 估计值 标准误差 t 比率 t 比率 概率>|t|
capacity(20,34) -3.186572 0.172443 -18.48 ---------- <.0001
concentration(242,302) -2.038239 0.172443 -11.82 ------ <.0001
load acid(23,28) -1.654404 0.151667 -10.91 ------ <.0001
pH(5.7,6.2) -1.25935 0.172443 -7.30 ---- <.0001
pH*concentration 0.6602612 0.246643 2.68 + 0.0253
capacity*capacity 0.8250774 0.359051 2.30 + 0.0472
concentration*concentration 0.7600774 0.359051 2.12 + 0.0634
concentration*capacity 0.3465112 0.246643 1.40 + 0.1936
load acid*capacity -0.241663 0.200118 -1.21 - 0.2580
concentration*load acid 0.2258366 0.200118 1.13 + 0.2883
load acid*load acid -0.294923 0.359051 -0.82 0.4326
pH*capacity 0.1202612 0.246643 0.49 0.6375
pH*load acid 0.0520866 0.200118 0.26 0.8005
pH*pH 0.0700774 0.359051 0.20 0.8496
附件列表