FK (B/W)K (B/W)F K2 F2 （B/W）２
0.512155558 -8.385280202 24.48095514 0.632236119 5.648735194 934.0201958 1868.040392 24.48095514 8.385280202 24.48095514 -8.3852802 11.29747039 0.512155558 -0.51215556 -1.26447224 B/W F K 2.507817699 11.59980167 9.379515525
磨细矿渣掺量
K = 9.3795%.
414
38.81115167 39 42.33943818 42 451
2.65695 10.8061
B/W F
15.6927
K
1 1 1 1 1 1 1 1 1 1
1.916666667 2.055555556 2.077844311 2.288235294 2.377142857 2.472222222 2.83030303 2.857142857 2.771428571 2.971428571 1 2.055555556 24.32432432 13.51351351 4.225308642 591.6727538 182.6150475 50
0 24.3243243 19.8847262 17.7377892 0 22.4719101 17.5588865 0 0 19.2307692 1 2.07784431 19.8847262 28.2420749 4.31743698 395.402337 797.614796 41.3173653
3 3
试验原始数据 磨细矿粉 K(kg/m ) 0 50 98 140 0 95 168 100 0 110
3
水泥 C(kg/m ) 345 230 180 180 416 250 217 380 485 310
3
水 W(kg/m ) 180 180 167 170 175 180 165 168 175 175
3
通过电量 （库仑） 1430 1129 957 916 1025 931 912 867 993 815
0 0 #DIV/0! 已通过电量为考核指标的线性回归及方差分析 常数项 B/W K(kg/m ) F(kg/m ) 3.603237207 2.071579564 -905.473858 1777.349212
B=C+F+K 345 370 347 389 416 445 467 480 485 520 0
1 1 1 1 1 1 1 1 1 1
1.916666667 2.055555556 2.077844311 2.288235294 2.377142857 2.472222222 2.83030303 2.857142857 2.771428571 2.971428571
1 1 1 1 1 1 1 1 1 1 1 1.9166667 0 0 3.6736111 0 0 0
1.916666667 2.055555556 2.077844311 2.288235294 2.377142857 2.472222222 2.83030303 2.857142857 2.771428571 2.971428571 1 2.055555556 24.32432432 13.51351351 4.225308642 591.6727538 182.6150475 328.7070855
3 3
磨细矿粉
粉煤灰
胶水比
7.959477665 4.789091561 1090.531181 281.6713734 119.0687665 5 70886.85581 #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A 442462 2652.727654 9773.978217 0.204935207 0.187109984 0.689406958
11.59980167 9.379515525 6.289149609 134.5553988 87.97531149 以通过电量Q 以通过电量Q为考核指标的二次多项式模型回归分析及方差分析的源数据 粉煤灰掺量 F(%) 0 24.32432432 19.88472622 17.7377892 0 22.47191011 17.55888651 0 0 19.23076923 0 24.32432432 19.88472622 17.7377892 0 22.47191011 17.55888651 0 0 19.23076923 磨细矿粉掺量 K(%) 0 13.51351351 28.24207493 35.98971722 0 21.34831461 35.97430407 20.83333333 0 21.15384615 0 13.51351351 28.24207493 35.98971722 0 21.34831461 35.97430407 20.83333333 0 （B/W）２ 3.673611111 4.225308642 4.317436982 5.236020761 5.650808163 6.111882716 8.010615243 8.163265306 7.680816327 8.829387755 3.673611111 4.225308642 4.317436982 5.236020761 5.650808163 6.111882716 8.010615243 8.163265306 7.680816327 F2 0 591.6727538 395.402337 314.6291658 0 504.9867441 308.3144955 0 0 369.8224852 0 591.6727538 395.402337 314.6291658 0 504.9867441 308.3144955 0 0 K2 0 182.6150475 797.6147962 1295.259746 0 455.7505365 1294.150553 434.0277778 0 447.4852071 0 182.6150475 797.6147962 1295.259746 0 455.7505365 1294.150553 434.0277778 0
21.15384615 8.829387755 369.8224852 447.4852071 以通过电量Q 以通过电量Q为考核指标的二次多项式模型的回归分析及方差分析
(B/W)K
(B/W)F
K2
F2
（B/W）２
-8.385280202 24.48095514 0.632236119 5.648735194 934.0201958 1.02432E-13 5.35226E-13 10 2.86467E-24 5.36568E-16 1919.728622 6.70139E+27 1.000000 1.42308E-13 3.05938E-15 1.96553E-14 2.55554E-12 #N/A #N/A #N/A 1.000000 8477.591577 12233.95113 23660.12799 38266.65417 2.95936E+28 4.27063E+28 8.25928E+28 1.33581E+29 1.000000 1.000000 1.000000 1.000000 #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
(B
5.60 0 0 0 0
T
0.330267742 0.316645628 0.555809822 (对应表1.20-2） B ) 1 = 0 0 0 0 -1 83.8843 0 0 0.001618 -1 0 0.004469 0 0 0
0 0 0 0 0.0027113
即最优胶水比 B / W = 2.5078;
2.507817699 表1 20表1.20-3 序号 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 胶水比 B/W 1.916666667 2.055555556 2.077844311 2.288235294 2.377142857 2.472222222 2.83030303 2.857142857 2.771428571 2.971428571 1.916666667 2.055555556 2.077844311 2.288235294 2.377142857 2.472222222 2.83030303 2.857142857 2.771428571 2.971428571 表1 20表1.20-4 FK 0.512155558 6.44954E-15 1.00000000 2.13696E+29 550953 1.000000 1806.431692 6.3059E+27 1.000000
粉煤灰掺量
F = 11.5998%;
B= 413.787 W=165 C= 326.977384 327 180 451.404 356.702601 357
47.998464 48 52.361961 52
QC = 7371.328 4890.029 ( B / W ) 197.246 F + 3.2277142 K + 934.0202 ( B / W ) 2 + 5.6487352 + 0.6322361 K 2 + 24.480955 ( B / W ) F 8.38528 ( B / W ) K + 0.5121556 F K
0
0
24.3243243 13.5135135 19.8847262 28.2420749 17.7377892 35.9897172 0 22.4719101 17.5588865 0 0 19.2307692 1 2.07784431 19.8847262 28.2420749 4.31743698 395.402337 797.614796 561.585928 0 21.3483146 35.9743041 20.8333333 0 21.1538462 1 2.28823529 17.7377892 35.9897172 5.23602076 314.629166 1295.25975 638.378018