统计技术应用课件第八章例题计算记录.xls

例例8-1国内生产总值（亿元）财政收入（亿元）年份200621631438760-90697-21842200726581051322-41201-9280200831404561330703472820093409036851833892791620103979838308090972224781535055303010平均数30701160602936325518.8r937040060.50.999237448数据分析中相关系数法列 1列 2列 11列 20.9992374481CORREL函数法0.999237xyxx yy 1981003874 8225945809477072964382345280 169752240186118400512075249477156529984268289072 1148667664626630562044868616 82759047845052604844681627594 1.9398E+101131644888)(xx)(yy 2)(xx 2)(yy 例例8-2广告费（万元）销售额（万元）年份20060.230.60.0420070.441.60.1620080.5630.2520090.674.20.3620100.897.20.6420110.91090.81合计3.43925.62.26r0.989949494平均数0.56676.50004.26670.3767b2110.52a0.55SUMMARY OUTPUT回归统计Multiple R0.989949494R Square0.98Adjusted R Square 0.975标准误差0.433012702观测值6方差分析dfSSMSF Significance F回归分析136.7536.75196 0.000151残差40.750.1875总计537.5Coefficients标准误差t StatP-value Lower 95%Upper 95%Intercept0.550.460298816 1.194876 0.298138-0.72799 1.827994X Variable 110.50.7514 0.000151 8.417666 12.58233xyxy2x下限 95.0%上限 95.0%-0.72799 1.8279948.417666 12.58233例例8-3广告费（万元）销售额（万元）年份20060.23920070.441620080.563620090.674920100.898120110.910100合计3.439291b10.5a0.550.750.750.18750.433013xy2y例8-4销售额（万元）物流成本（万元）利润额（万元）月份1354.21.656.06.722364.11.761.26.973414.91.873.88.824374.41.762.97.485354.11.656.06.566313.41.443.44.767354.21.656.06.728414.72.082.09.409566.62.7151.217.8210607.02.8168.019.6011516.22.2112.213.6412374.51.762.97.65合计49558.322.8985.6116.141249558.3系数行列式495213692519.258.32519.2297.1722.849558.3系数行列式985.6213692519.2116.142519.2297.171222.858.3系数行列式495985.62519.258.3116.14297.171249522.8系数行列式49521369985.658.32519.2116.14-0.0912682870.086032874-0.32060125921212117.2972.25193.5814.1162.2519213694956.9853.58495128.22bbabbabba1x2xyyx1yx2D1D2D3Da1b2bSUMMARY OUTPUT回归统计Multiple R 0.990512695R Square0.981115398Adjusted R Square0.97691882标准误差0.067942887观测值12方差分析dfSSMSFSignificance F回归分析22.1584538761.079226938 233.789379 1.75E-08残差90.0415461240.004616236总计112.2Coefficients标准误差t StatP-valueLower 95%Intercept-0.0912682870.094547237-0.965319455 0.35960532-0.30515X Variable 1 0.0860328740.0196821324.371115553 0.00179417 0.041509X Variable 2-0.3206012590.16256555-1.972135297 0.08006662-0.688351046454.2464217722542.254.22542.5297.0221.546454.21010217722542.2117.92542.5297.021021.554.246410102542.254.2117.9297.021046421.546421772101054.22542.5117.9147.0122517.64147.6129616.81200.9168124.01162.8136919.36143.5122516.81105.496111.56147.0122517.64192.7168122.09369.6313643.56420.0360049.00316.2260138.44166.5136920.252519.221369297.171991.82-181.79171.362-638.5821xx21x22xUpper 95%下限 95.0%上限 95.0%0.122612-0.3051 0.1226120.130557 0.04151 0.1305570.047148-0.6884 0.04714821.51010117.9Significance F-57.7329.46-104xy671878381033411419116211196312513128191452314555153121654317142194162151222315229142464027126273252953029916322133342933729341213442634835368173723937312433194444149233521205572967076718126787508571989923913849803799011100646104519111028111190112933117529118914912503214791161499741593136188534189857190348190420356838国内生产总值（亿元）财政收入（亿元）xyx-x|21631438760-9069726581051322-41201314045613307034340903685183389239798383080909721535055303010-307011606021535055303010 xyxy21631438760838433064026581051322136419008203140456133019260379850340903685182335799175439798383080330644276401535055303010977090307040.0024834759839.691690.9984006440003500300025002000150010005000020406080100120140160城市人口（万人）总悬浮颗粒物（微克/立方米）y-y|(x-x|)(y-y|)x-x|2y-y|2-2184219810038748225945809477072964-928038234528016975224018611840072851207524947715652998479162682890721148667664626630562247820448686168275904784505260484-468162759419397517814 11316448880.99923745936325518.862285.6609715044.234030.9992374484500004000003500003000002500002000001500001000005000000100002000030000400005000060000700008000090000国内生产总值（亿元）财政收入（亿元）x2y2y46791746596150233760060376.90111-21616.90146729041470654956100263394768460499.82297-9177.823 84232434.498624262025376136890060619.61316 710.386837 504649.458116214855409469471632460686.31421 7831.68579 61335302.3158390468289690228640060828.07071 22251.92934951483572356393853025194946569081108511157369503719373340135.619322.0116919222.47954500004000003500003000002500002000001500001000005000000100002000030000400005000060000700008000090000国内生产总值（亿元）财政收入（亿元）40003500300025002000150010005000020406080100120140160城市人口（万人）总悬浮颗粒物（微克/立方米）4500004000003500003000002500002000001500001000005000000100002000030000400005000060000700008000090000国内生产总值（亿元）财政收入（亿元）4500004000003500003000002500002000001500001000005000000100002000030000400005000060000700008000090000国内生产总值（亿元）财政收入（亿元）0.20.40.50.60.834679xyxyx2y20.230.60.0490.441.60.16160.5630.25360.674.20.36490.897.20.64810.91090.81100合计3.43925.62.26291平均0.56676.50004.26670.37670.55216.66%10.522120.9100.750.750.18750.43301310.90.80.70.60.50.40.30.20.10024681012系列1SUMMARY OUTPUT回归统计Multiple R0.990512695R Square0.981115398Adjusted R Square0.97691882标准误差0.067942887观测值12方差分析dfSSMSF Significance F回归分析2 2.158454 1.079227 233.7894 1.75E-08残差9 0.041546 0.004616总计112.2Coefficients标准误差t StatP-value Lower 95%Upper 95%Intercept-0.091268287 0.094547-0.96532 0.359605-0.30515 0.122612X Variable 10.086032874 0.019682 4.371116 0.001794 0.041509 0.130557X Variable 2-0.320601259 0.162566-1.97214 0.080067-0.68835 0.047148下限 95.0%上限 95.0%-0.30515 0.1226120.041509 0.130557-0.68835 0.047148SUMMARY OUTPUT回归统计Multiple R0.999943R Square0.999886Adjusted R Square 0.999864标准误差0.067838观测值13方差分析dfSSMSF Significance F回归分析2 405.3632 202.681644042.5 1.88E-20残差100.04602 0.004602总计12 405.4092Coefficients 标准误差t StatP-value Lower 95%Upper 95%下限 95.0%Intercept-0.000810.02222-0.03646 0.971633-0.050320.0487-0.05032X Variable 10.080378 0.018796 4.276319 0.001621 0.038498 0.122259 0.038498X Variable 2-0.29129 0.159567-1.82547 0.097897-0.64682 0.064252-0.64682上限 95.0%0.04870.1222590.064252销售额（万元）物流成本（万元）利润额（万元）月份1354.21.62364.11.73414.91.84374.41.75354.11.66313.41.47354.21.68414.729566.62.7106072.811516.22.212374.51.71x2xy