《统计学第八章相关于回归分析.xls》由会员分享,可在线阅读,更多相关《统计学第八章相关于回归分析.xls(10页珍藏版)》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、SUMMARY OUTPUT回归统计Multiple R 0.882607R Square 0.778996Adjusted R Square0.747424标准误差 0.160818观测值9方差分析dfSSMSF Significance F回归分析1 0.638119 0.638119 24.67361 0.001624残差7 0.181037 0.025862总计8 0.819156Coefficients 标准误差t StatP-value Lower 95%Upper 95%下限 95.0%上限 95.0%Intercept 6.0178321.05226 5.718961 0.00
2、0721 3.529633 8.506031 3.529633 8.506031X Variable 1-0.07041 0.014176-4.96725 0.001624-0.10393-0.03689-0.10393-0.03689列 1列 2列 11列 2-0.88261181.80.2176.60.5876.60.8575.70.6873.80.7472.20.9371.20.7270.81.2268.51.2584828078767472706800.20.40.60.811.21.4Series11.41.210.80.60.40.20687072747678808284Serie
3、s184828078767472706800.20.40.60.811.21.4Series184828078767472706800.20.40.60.811.21.4Series11.41.210.80.60.40.20687072747678808284Series184828078767472706800.20.40.60.811.21.4Series1SUMMARY OUTPUT回归统计Multiple R 0.952129R Square 0.906549Adjusted R Square0.890974标准误差 3.331262观测值22方差分析dfSSMSF Significa
4、nce F回归分析3 1937.749 645.9162 58.20479 1.83E-09残差18 199.751511.0973总计212137.5Coefficients 标准误差t StatP-value Lower 95%Upper 95%下限 95.0%上限 95.0%Intercept 32.99309 3.138595 10.51206 4.12E-09 26.39914 39.58703 26.39914 39.58703X Variable 10.071619 0.014755 4.853871 0.0001280.04062 0.1026180.04062 0.10261
5、8X Variable 20.168727 0.039956 4.222811 0.000512 0.084782 0.252671 0.084782 0.252671X Variable 30.179042 0.048869 3.663731 0.001776 0.076372 0.281711 0.076372 0.281711列 1列 2列 3列 4列 11列 20.7253151列 30.846655 0.5030071列 40.733436 0.307223 0.6275141791949999771859079708397837414792906953948670748090712
6、789887029809465249092711895966323958562278492631389905778174582036815018553660125090521237695013383753112773486418543732359080706050403020100050100150200250Series1Series2Series39080706050403020100050100150200250Series1Series2Series39080706050403020100050100150200250Series1Series2Series39080706050403
7、020100050100150200250Series1Series2Series39080706050403020100050100150200250Series1Series2Series39080706050403020100050100150200250Series1Series2Series3SUMMARY OUTPUT回归统计Multiple R 0.99558R Square0.99118Adjusted R Square0.990853标准误差5722.5观测值29方差分析dfSSMSF Significance F回归分析1 9.94E+10 9.94E+10 3034.05
8、2 2.81E-29残差27 8.84E+08 32747007总计281E+11Coefficients 标准误差t StatP-value Lower 95%Upper 95%下限 95.0%上限 95.0%Intercept-3906.06 1530.392-2.55233 0.016672-7046.16-765.956-7046.16-765.956X Variable 11.815669 0.032963 55.08223 2.81E-29 1.748034 1.883303 1.748034 1.8833033645.2172239.14062.5792633.74545.624
9、3007.94889.4613361.55330.4513714.85985.5524126.47243.7524846.39040.7375986.310274.386821.812050.627804.615036.829839.517000.9211164.218718.3212090.521826.214091.926937.2817203.335260.0221899.948108.4629242.259810.5336748.270142.4943919.578060.8348140.683024.2851588.288479.1555636.998000.4561516108068.266878.3119095.771691.213517477449.5159586.787032.9184739.197822.7211808 110413.2