《回归分析法过程计算表.xls》由会员分享，可在线阅读，更多相关《回归分析法过程计算表.xls（6页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、回归分析法多元线性回归分析XXTYi16.816.57111111115.41-0.989.536.81-0.989.52-6.76.525.34-0.6513.219.527.796.579.537.7912.329.888.267.5515.261-6.712.3211.3316.529.8813.3215.348.2614.61-0.657.5512.16（1）回归方程显著性检验(XTX)-1(Y-Y平均)平方和S回(Y-Yi)平方和S残7.874996-0.19854-0.8106914.650981.211085 1.466728 11.9851-0.57891 0.335142 2
2、.4747-0.19854 0.009463 0.0194160.200661-0.89108 0.794027-0.48108 0.23144-0.81069 0.019416 0.085448-0.18211.532716 2.349219-0.11728 0.013755-2.54692 6.486815-0.26692 0.0712480.550144 0.3026580.840144 0.7058420.608365 0.370108-0.38164 0.145645-0.46431 0.215580.985694 0.971592F0.05(2,4)=6.94，因FF0.05(2,
3、4)=6.94，所以回归方程显著。（2）回归系数显著性检验（3）剔除X2后重新建立回归方程c11F1c22F2XXT0.0094636.877690.085443 0.62731416.81111-0.986.81-0.9819.521-6.7F0.05(1,4)=7.7116.52(XTX)-1因F1F0.05(1,4),F2F0.05(1,5)=6.61,故回归方程显著.即水位与大坝位移间线性关系显著。-2.30836 5.328533-0.028360.891395 0.7945861.1813950.605789 0.366981-0.38421-0.84402 0.7123780.605975回归分析求预测方程：F2242039.09233.12XY20.25519FF0.05(1,5)=6.61，故回归方程显著。YY平均n=7、m=214.8210913.6112.7189215.1427211.0630814.1601414.2183613.14569F9.68627211111（3）剔除X2后重新建立回归方程XT9.52-6.76.525.34-0.6512.92330.242039平方和S残0.686268 2.862738n=7,m=10.2640910.0010550.0008041.3956950.1476180.367206（4）回归方程显著性检验