王剑强度数学模型.xls

永永年年水水泥泥粉粉磨磨有有限限公公司司一一天天强强度度与与廿廿八八天天强强度度回回归归曲曲线线序号编号XI-R1YI-R28XI*YIXI2YI2(XI)2XI*YI(YI)2(Y平均-Yi)21200805121.047.3993.30441.002237.290.0002200805220.946.9980.21436.812199.610.1583200805320.947.2986.48436.812227.840.0104200805420.847.0977.60432.642209.000.0895200805520.847.5988.00432.642256.250.0416200805621.147.41000.14445.212246.760.0117200805720.847.6990.08432.642265.760.0928200805821.547.81027.70462.252284.840.2539200805921.447.81022.92457.962284.840.25310200806021.247.61009.12449.442265.760.09211200806121.048.01008.00441.002304.000.49412200806221.349.01043.70453.692401.002.89913200806320.947.91001.11436.812294.410.36314200806421.747.61032.92470.892265.760.09215200806521.347.11003.23453.692218.410.03916200806621.647.81032.48466.562284.840.25317200806721.348.01022.40453.692304.000.49418200806821.147.71006.47445.212275.290.16219200806921.848.11048.58475.242313.610.64420200807021.647.21019.52466.562227.840.01021200807120.847.0977.60432.642209.000.08922200807221.347.61013.88453.692265.760.01023200807320.846.5967.20432.642162.250.63624200807420.847.2981.76432.642227.840.01025200807521.047.91005.90441.002294.410.36326200807620.746.6964.62428.492171.560.48727200807720.846.1958.88432.642125.211.43428200807821.047.1989.10441.002218.410.03929200807921.447.31012.22457.962237.290.00030200808020.946.4969.76436.812152.960.80631200808121.347.11003.23453.692218.410.03932200808220.746.1954.27428.492125.211.43433200808320.746.0952.20428.492116.001.68434200808420.946.6973.94436.812171.560.48735200808520.946.0961.40436.812116.001.68436200808620.946.2965.58436.812134.441.20537200808721.347.11003.23453.692218.410.03938200808820.847.8994.24432.642284.840.25339200808920.947.8999.02436.812284.840.25340200809021.049.01029.00441.002401.002.899 842.91891.939870.9917765.4989502.517104801594683357928620.288X平均21.147.3996.8444.12237.617762.039867.189482.10.507L(XX)=Xi2-1/40(Xi)2=3.48L(YY)=Yi2-1/40(Yi)2=20.37L(XY)=XiYi-1/40(Xi)(Yi)=3.93L(XX)(YY)=70.881638L(XX)(YY)=8.41912333相关系数r=L(XY)=0.46646781L(XX)L(YY)1-r2=0.782408(1-r2)L(YY)/38=0.4194066精度S=(1-r2)L(YY)/38=0.64761609b=L(XY)/L(XX)1.13a=Y平均-bX平均23.52查相关系数检验表可知rr起,S值较低,可见回归线精度较好故可用直线表示三天强度与廿八强度之间的关系根据表中数据,利用回归系数的公式计算,P.O42.5级一天至廿八天强度回归方程为:R28=1.13R1+23.52另一种剩余标准偏差的计算0.53S=1(Y平均-Yi)2 =0.7306765 n-2 永永年年水水泥泥粉粉磨磨有有限限公公司司三三天天强强度度与与廿廿八八天天强强度度回回归归曲曲线线序号编号XI-R3YI-R28XI*YIXI2YI2(XI)21E092815.127.5415.25228.01756.252E102317.230.4522.88295.84924.163E100417.230.5524.60295.84930.254E100517.030.0510.00289.00900.005E100917.029.7504.90289.00882.096E101616.929.4496.86285.61864.367E102016.629.9496.34275.56894.018E102116.428.9473.96268.96835.219E102516.829.2490.56282.24852.6410E102215.928.5453.15252.81812.2511E102715.929.2464.28252.81852.6412E110116.429.4482.16268.96864.3613E110816.629.6491.36275.56876.1614E111116.729.2487.64278.89852.6415E111316.728.5475.95278.89812.2516E111617.129.4502.74292.41864.3617E112415.629.6461.76243.36876.1618E112517.231.0533.20295.84961.0019E111817.230.5524.60295.84930.2520E111917.130.5521.55292.41930.2521E112115.427.1417.34237.16734.4122E112216.229.4476.28262.44864.3623E112816.929.3495.17285.61858.4924E113016.928.9488.41285.61835.2125E120217.029.2496.40289.00852.6426E120417.029.8506.60289.00888.0427E120616.929.9505.31285.61894.0128E120717.430.3527.22302.76918.0929E120915.929.0461.10252.81841.0030E121016.529.1480.15272.25846.8131E121116.629.8494.68275.56888.0432E121316.228.6463.32262.44817.9633E121417.129.6506.16292.41876.1634E121517.229.2502.24295.84852.6435E121617.429.6515.04302.76876.1636E121716.327.2443.36265.69739.8437E121817.431.6549.84302.76998.5638E091616.828.9485.52282.24835.2139E100116.729.7495.99278.89882.094016.629.2484.72275.56852.64 667.01176.319628.5911134.2434623.65444889X平均16.729.4490.7278.4865.611122.2L(XX)=Xi2-1/40(Xi)2=12.02L(YY)=(Yi-Y平均)2=32.80L(XY)=XiYi-1/40(Xi)(Yi)=13.79L(XX)(YY)=394.107L(XX)(YY)=19.85213相关系数r=L(XY)=0.6945099L(XX)L(YY)1-r2=0.517656(1-r2)L(YY)/38=0.187821精度S=(1-r2)L(YY)/38=0.433383b=L(XY)/L(XX)1.15a=Y平均-bX平均10.27查相关系数检验表可知rr起,S值较低,可见回归线精度较好故可用直线表示三天强度与廿八强度之间的关系根据表中数据,利用回归系数的公式计算,P.O42.5级三天廿八天回归方程为:R28=1.15R3+10.27另一种剩余标准偏差的计算S=1(Y平均-Yi)2 =0.9290806 n-2XI*YI(YI)2(Y平均-Yi)23.6390.9851.1940.3510.0860.0000.2430.2580.0430.8240.0430.0000.0370.0430.8240.0000.0372.5361.1941.1945.3251.1940.0120.2580.0430.1540.2430.7970.1660.0950.1540.6520.0370.0430.0374.8734.8070.2580.0860.043784592138368232.80119614.834592.00.8200.86 查相关系数检验表可知rr起,S值较低,可见回归线精度较好故可用直线表示三天强度与廿八强度之间的关系根据表中数据,利用回归系数的公式计算,P.O42.5级三天廿八天回归方程为:R28=1.15R3+10.27廿八天强度计算值与实测值结果的对比情况表(2008第一季度)水泥编号R3实测值R28计算值R28实测值R28计-R28实相对误差/%相对误差都在5%内，说明可靠性较好。永永年年水水泥泥粉粉磨磨有有限限公公司司一一天天强强度度与与三三天天强强度度回回归归曲曲线线序号编号XI-R1YI-R3XI*YIXI2YI2(XI)21200805119.321.0405.30372.49441.002200805219.020.9397.10361.00436.813200805318.820.9392.92353.44436.814200805418.320.8380.64334.89432.645200805518.920.8393.12357.21432.646200805619.221.1405.12368.64445.217200805718.720.8388.96349.69432.648200805819.721.5423.55388.09462.259200805919.321.4413.02372.49457.9610200806018.921.2400.68357.21449.4411200806118.821.0394.80353.44441.0012200806219.121.3406.83364.81453.6913200806318.920.9395.01357.21436.8114200806419.421.7420.98376.36470.8915200806519.821.3421.74392.04453.6916200806619.421.6419.04376.36466.5617200806719.821.3421.74392.04453.6918200806819.121.1403.01364.81445.2119200806919.321.8420.74372.49475.2420200807019.221.6414.72368.64466.5621200807118.820.8391.04353.44432.6422200807219.221.3408.96368.64453.6923200807319.020.8395.20361.00432.6424200807419.020.8395.20361.00432.6425200807518.721.0392.70349.69441.0026200807619.420.7401.58376.36428.4927200807718.620.8386.88345.96432.6428200807819.521.0409.50380.25441.0029200807919.721.4421.58388.09457.9630200808019.020.9397.10361.00436.8131200808119.421.3413.22376.36453.6932200808218.320.7378.81334.89428.4933200808319.420.7401.58376.36428.4934200808419.120.9399.19364.81436.8135200808519.420.9405.46376.36436.8136200808619.120.9399.19364.81436.8137200808719.421.3413.22376.36453.6938200808818.820.8391.04353.44432.6439200808919.320.9403.37372.49436.8140200809019.521.0409.50380.25441.00 765.5842.916133.3414654.9117765.49585990X平均19.121.1403.3366.4444.114649.8L(XX)=Xi2-1/40(Xi)2=5.15L(YY)=Yi2-1/40(Yi)2=3.48L(XY)=XiYi-1/40(Xi)(Yi)=2.34L(XX)(YY)=17.93376L(XX)(YY)=4.234827相关系数r=L(XY)=0.5528561L(XX)L(YY)1-r2=0.69435(1-r2)L(YY)/38=0.063583精度S=(1-r2)L(YY)/38=0.252157b=L(XY)/L(XX)0.45a=Y平均-bX平均12.38查相关系数检验表可知rr起,S值较低,可见回归线精度较好故可用直线表示三天强度与廿八强度之间的关系根据表中数据,利用回归系数的公式计算,P.O42.5级一天至三天强度回归方程为:R3=0.45R1+12.38 永永年年水水泥泥粉粉磨磨有有限限公公司司一一天天强强度度与与廿廿八八天天强强度度回回归归曲曲线线序号编号XI-R1YI-R28XI*YIXI2YI2(XI)21200805121.047.3993.30441.002237.292200805220.946.9980.21436.812199.613200805320.947.2986.48436.812227.844200805420.847.0977.60432.642209.005200805520.847.5988.00432.642256.256200805621.147.41000.14445.212246.767200805720.847.6990.08432.642265.768200805821.547.81027.70462.252284.849200805921.447.81022.92457.962284.8410200806021.247.61009.12449.442265.7611200806121.048.01008.00441.002304.0012200806221.349.01043.70453.692401.0013200806320.947.91001.11436.812294.4114200806421.747.61032.92470.892265.7615200806521.347.11003.23453.692218.4116200806621.647.81032.48466.562284.8417200806721.348.01022.40453.692304.0018200806821.147.71006.47445.212275.2919200806921.848.11048.58475.242313.6120200807021.647.21019.52466.562227.8421200807120.847.0977.60432.642209.0022200807221.347.61013.88453.692265.7623200807320.846.5967.20432.642162.2524200807420.847.2981.76432.642227.8425200807521.047.91005.90441.002294.4126200807620.746.6964.62428.492171.5627200807720.846.1958.88432.642125.2128200807821.047.1989.10441.002218.4129200807921.447.31012.22457.962237.2930200808020.946.4969.76436.812152.9631200808121.347.11003.23453.692218.4132200808220.746.1954.27428.492125.2133200808320.746.0952.20428.492116.0034200808420.946.6973.94436.812171.5635200808520.946.0961.40436.812116.0036200808620.946.2965.58436.812134.4437200808721.347.11003.23453.692218.4138200808820.847.8994.24432.642284.8439200808920.947.8999.02436.812284.8440200809021.049.01029.00441.002401.00 842.91891.939870.9917765.4989502.51710480X平均21.147.3996.8444.12237.617762.0L(XX)=Xi2-1/40(Xi)2=3.48L(YY)=Yi2-1/40(Yi)2=20.37L(XY)=XiYi-1/40(Xi)(Yi)=3.93L(XX)(YY)=70.88164L(XX)(YY)=8.419123相关系数r=L(XY)=0.4664678L(XX)L(YY)1-r2=0.782408(1-r2)L(YY)/38=0.419407精度S=(1-r2)L(YY)/38=0.647616b=L(XY)/L(XX)1.13a=Y平均-bX平均23.52查相关系数检验表可知rr起,S值较低,可见回归线精度较好故可用直线表示三天强度与廿八强度之间的关系根据表中数据,利用回归系数的公式计算,P.O42.5级一天至廿八天强度回归方程为:R28=1.13R1+23.522008年9月24日 P.O42.5级(一天至廿八天)XI*YI(YI)2(Y平均-Yi)20.0050.0300.0300.0740.0740.0010.0740.1830.1070.0160.0050.0520.0300.3940.0520.2780.0520.0010.5290.2780.0740.2780.0740.0740.0050.1390.0740.0050.1070.0300.0520.1390.1390.0300.0300.0300.0520.0740.0300.005 永永年年水水泥泥粉粉磨磨有有限限公公司司一一天天强强度度与与三三天天强强度度回回归归曲曲线线6452407104803.70616131.017762.00.0932008年9月24日 P.O42.5级(一天至三天)XI*YI(YI)2(Y平均-Yi)20.0000.1580.0100.0890.0410.0110.0920.2530.2530.0920.4942.8990.3630.0920.0390.2530.4940.1620.6440.010查相关系数检验表可知rr起,S值较低,可见回归线精度较好故可用直线表示三天强度与廿八强度之间的关系根据表中数据,利用回归系数的公式计算,P.O42.5级一天至三天强度回归方程为:R3=0.45R1+12.38 永永年年水水泥泥粉粉磨磨有有限限公公司司一一天天强强度度与与廿廿八八天天强强度度回回归归曲曲线线0.0890.0100.6360.0100.3630.4871.4340.0390.0000.8060.0391.4341.6840.4871.6841.2050.0390.2530.2532.8991594683357928620.28839867.189482.10.507查相关系数检验表可知rr起,S值较低,可见回归线精度较好故可用直线表示三天强度与廿八强度之间的关系根据表中数据,利用回归系数的公式计算,P.O42.5级一天至廿八天强度回归方程为:R28=1.13R1+23.522008年9月24日 P.O42.5级(一天至廿八天)永永年年水水泥泥粉粉磨磨有有限限公公司司三三天天强强度度与与廿廿八八天天强强度度回回归归曲曲线线序号编号XI-R3YI-R28XI*YIXI2YI21E0928226.0508.0114808.0051076.00258064.002E1023224.0510.0114240.0050176.00260100.003E1004205.0483.099015.0042025.00233289.004E1005209.0471.098439.0043681.00221841.005E1009195.0459.089505.0038025.00210681.006E1016206.0461.094966.0042436.00212521.007E1020252.0526.0132552.0063504.00276676.008E1021233.0494.0115102.0054289.00244036.009E1025245.0517.0126665.0060025.00267289.0010E1022238.0509.0121142.0056644.00259081.0011E1027241.0507.0122187.0058081.00257049.0012E1101231.0489.0112959.0053361.00239121.0013E1108247.0519.0128193.0061009.00269361.0014E1111272.0544.0147968.0073984.00295936.0015E1113289.0561.0162129.0083521.00314721.0016E1116301.0558.0167958.0090601.00311364.0017E1124247.0503.0124241.0061009.00253009.0018E1125246.0525.0129150.0060516.00275625.0019E1118248.0522.0129456.0061504.00272484.0020E1119238.0536.0127568.0056644.00287296.0021E1121248.0556.0137888.0061504.00309136.0022E1122269.0560.0150640.0072361.00313600.0023E1128289.0553.0159817.0083521.00305809.0024E1130238.0506.0120428.0056644.00256036.0025E1202248.0512.0126976.0061504.00262144.0026E1204230.0481.0110630.0052900.00231361.0027E1206228.0488.0111264.0051984.00238144.0028E1207218.0493.0107474.0047524.00243049.0029E1209220.0522.0114840.0048400.00272484.0030E1210211.0479.0101069.0044521.00229441.0031E1211209.0471.098439.0043681.00221841.0032E1213195.0459.089505.0038025.00210681.0033E1214206.0461.094966.0042436.00212521.0034E1215252.0526.0132552.0063504.00276676.0035E1216233.0494.0115102.0054289.00244036.0036E1217245.0517.0126665.0060025.00267289.0037E1218238.0509.0121142.0056644.00259081.0038E0916241.0507.0122187.0058081.00257049.0039E1001247.0519.0128193.0061009.00269361.0040241.0507.0122187.0058081.00257049.00 9499.020322.04850207.02278749.010356332.0X平均237.5508.1121255.256968.7258908.3L(XX)=Xi2-1/40(Xi)2=22973.98L(YY)=(Yi-Y平均)2=29822.30L(XY)=XiYi-1/40(Xi)(Yi)=24240.05L(XX)(YY)=6.85E+08L(XX)(YY)=相关系数r=L(XY)=0.92607225L(XX)L(YY)1-r2=0.14239(1-r2)L(YY)/38=精度S=(1-r2)L(YY)/38=9.53048454R3与R28的相关程度较好。回归方程式为：R28=R30.00098R3+0.2339(XI)2XI*YI(YI)2(Y平均-Yi)2Xi/Yi(即f)Xi2/Yi(即f*Xi)0.0030.4449100.543.8020.439298.38627.5030.424487.011372.7030.443792.742405.9030.424882.842213.7030.446992.05322.2030.4791120.73197.4030.4717109.9080.1020.4739116.100.9020.4676111.281.1030.4753114.56362.9030.4724109.12119.9030.4759117.551292.4030.5000136.002803.7030.5152148.882495.0030.5394162.3725.5030.4911121.29287.3030.4686115.27194.6030.4751117.82781.2020.4440105.682299.2030.4460110.62781.2020.4804129.222020.5030.5226151.034.2030.4704111.9415.6020.4844120.13731.7030.4782109.98402.0030.4672106.52226.5030.442296.40194.6030.421592.72843.9030.440592.951372.7030.443792.7412405.9030.424882.8432213.7030.446992.052322.2030.4791120.730197.4030.4717109.89780.1020.4739116.1030.9020.4676111.2851.1030.4753114.558119.9030.4759117.5511.1030.4753114.55890231001.0193038678.0412983684.029822.318.74453.92255775.04825967.010324592.1745.60.5111.3784.80Xi2/Y =Xi2*a+Xi*bXi/Y =Xi*a+40*b26175.11747联解方程得：900.1759490.83013559918959 a=0.00097969.35583 b=0.2338957-900.176-918959 a=0.000989.35583 b=0.233896