ÂÊ£¨
x2£©x¡¢Ò»Ëê¶ùͯÒßÃç½ÓÖÖÂÊ£¨3£©µÄÊý¾Ý
ƽ¾ùÊÙÃü È˾ùGDP ³ÉÈËʶ×ÖÂÊÒ»Ëê¶ùͯÒßÃç½ÓÖÖÂÊ Ðò¹ú¼ÒºÍ ºÅ µØÇø 1 2 3 4 5 6 7 8 9 ÈÕ±¾ ÖйúÏã¸Û º«¹ú ÐÂ¼ÓÆÂ Ì©¹ú ÂíÀ´Î÷ÑÇ Ë¹ÀïÀ¼¿¨ Öйú´ó½ ·ÆÂɱö y£¨Ä꣩ 79 77 70 74 69 70 71 70 65 71 63 62 63 57 58 50 60 52 50 53 48 x1£¨100ÃÀÔª£© 194 185 83 147 53 74 27 29 24 18 23 27 13 7 20 18 12 12 13 11 6 x2£¨%£© 99 90 97 92 94 80 89 80 90 95 95 84 89 81 36 55 50 37 38 27 41 99 79 83 90 86 90 88 94 92 96 85 92 90 74 81 36 90 69 37 73 85 x3£¨%£© 10 ³¯ÏÊ 11 ÃɹŠ12 Ó¡¶ÈÄáÎ÷ÑÇ 13 Ô½ÄÏ 14 Ãåµé 15 °Í»ù˹̹ 16 ÀÏÎÎ 17 Ó¡¶È 18 ÃϼÓÀ¹ú 19 ¼íÆÒÕ¯ 20 Äá²´¶û 21 ²»µ¤ 22 °¢¸»º¹ 43 7 32 35 ×ÊÁÏÀ´Ô´£ºÁªºÏ¹ú·¢Õ¹¹æ»®Êð¡¶È˵ķ¢Õ¹±¨¸æ¡· £¨1£©ÓöàÔª»Ø¹éµÄ·½·¨·ÖÎö¸÷¹úÈ˾ùÊÙÃüÓëÈ˾ùGDP¡¢³ÉÈËʶ×ÖÂÊ¡¢Ò»Ëê¶ùͯÒßÃç½ÓÖÖÂʵĹØÏµ£»
£¨2£©¶ÔËù½¨Á¢µÄ»Ø¹éÄ£ÐͽøÐмìÑé¡£
½â£º ÓÉExcel»Ø¹éÊä³öµÄ½á¹û¿ÉÒÔ¿´³ö£º £¨1£©»Ø¹é½á¹ûΪ
Yi?32.99309?0.071619X2i?0.168727X3i?0.179042X3i £¨2£©ÓÉExcelµÄ¼ÆËã½á¹ûÒÑÖª£º?1,?2,?3,?4 ¶ÔÓ¦µÄ t ͳ¼ÆÁ¿·Ö±ðΪ0.51206¡¢4.853871¡¢4.222811¡¢3.663731 ,Æä¾ø¶ÔÖµ¾ù´óÓÚÁÙ½çÖµt0.025(22?4)?2.101 ,ËùÒÔ¸÷¸ö×Ô±äÁ¿¶¼¶ÔYÓÐÃ÷ÏÔÓ°Ïì¡£
ÓÉF=58.20479, ´óÓÚÁÙ½çÖµF0.05(4?1,22?4)?3.16£¬ËµÃ÷Ä£ÐÍÔÚÕûÌåÉÏÊÇÏÔÖøµÄ¡£
^4. 5.
6. ÒÑ֪ijÆóÒµ½üÄêÀ´µÄ×ܳɱ¾ºÍ²úÁ¿µÄÊý¾Ý£º Äê·Ý Äê·Ý ²úÁ¿x y×ܳɱ¾ ×ܳɱ¾y £¨¼þ£© £¨ÍòÔª£© £¨ÍòÔª£© 1996 1997 1998 1999 2000 329 524 424 629 741 410 608 512 723 811 2002 2003 2004 2005 2006 863 1390 1157 1548 1787 ²úÁ¿x £¨¼þ£© 906 1223 1107 1319 1424 1541 2001 1020 1009 2007 2931 £¨1£© ÓÃÒÑÖªÊý¾Ý¹À¼ÆÒÔÏÂ×ܳɱ¾º¯ÊýµÄ²ÎÊý£º yt??1??2xt??3xt2??4xt3?ut £¨2£© £¨3£© £¨4£© £¨5£©
¼ìÑé²ÎÊýµÄÏÔÖøÐÔ£»
¼ìÑéÕû¸ö»Ø¹é·½³ÌµÄÏÔÖøÐÔ£»
¼ÆËã×ܳɱ¾¶Ô²úÁ¿µÄ·ÇÏßÐÔÏà¹ØÖ¸Êý£» ÆÀ¼Û´Ë»Ø¹é·ÖÎö´æÔÚʲô²»×ã¡£
½â£º £¨1£©ÓÃExcelÊäÈëYºÍXÊý¾Ý£¬Éú³ÉX2ºÍX3µÄÊý¾Ý£¬ÓÃY¶ÔX¡¢X2¡¢X3»Ø¹é£¬¹À¼Æ²ÎÊý½á¹ûΪ
23 Yi??1726.73?7.879646874Xi?0.00895X?3.71249E?06X
^ t=(-1.9213) (2.462897) (-2.55934) (3.118062) R2?0.973669 R2?0.963764
£¨2£©¼ìÑé²ÎÊýµÄÏÔÖøÐÔ£ºµ±È¡??0.05ʱ£¬²ét·Ö²¼±íµÃt0.025(12?4)?2.306£¬Óëtͳ¼ÆÁ¿¶Ô±È£¬³ýÁ˽ؾàÏîÍ⣬¸÷»Ø¹éϵÊý¶ÔÓ¦µÄtͳ¼ÆÁ¿µÄ¾ø¶ÔÖµ¾ù´óÓÚÁÙ½çÖµ£¬±íÃ÷ÔÚÕâÑùµÄÏÔÖøÐÔˮƽÏ£¬»Ø¹éϵÊýÏÔÖø²»Îª0¡£
£¨3£©¼ìÑéÕû¸ö»Ø¹é·½³ÌµÄÏÔÖøÐÔ£ºÄ£Ð͵ÄR2?0.973669,R2?0.963794£¬ËµÃ÷¿É¾öϵÊý½Ï¸ß£¬¶ÔÑù±¾Êý¾ÝÄâºÏ½ÏºÃ¡£ÓÉÓÚF=98.60668£¬¶øµ±È¡??0.05ʱ£¬²éF·Ö²¼±íµÃF0.05(4?1,12?4)?4.07£¬ÒòΪF=98.60668>4.07£¬Ó¦¾Ü¾øH0:?2??3??4?0£¬ËµÃ÷X¡¢X¡¢XÁªºÏÆðÀ´¶ÔYÈ·ÓÐÏÔÖøÓ°Ïì¡£
2£¨4£©¼ÆËã×ܳɱ¾¶Ô²úÁ¿µÄ·ÇÏßÐÔÏà¹ØÏµÊý£ºÒòΪR?0.973669Òò´Ë×ܳɱ¾¶Ô²úÁ¿µÄ
232·ÇÏßÐÔÏà¹ØÏµÊýΪR?0.973669»òR=0.9867466
£¨5£©ÆÀ¼Û£ºËäÈ»¾t¼ìÑé¸÷¸öϵÊý¾ùÊÇÏÔÖøµÄ£¬µ«ÓëÁÙ½çÖµ¶¼Ê®·Ö½Ó½ü£¬ËµÃ÷t¼ìÑéÖ»ÊÇÃãǿͨ¹ý£¬Æä°ÑÎÕ²¢²»´ó¡£Èç¹ûÈ¡??0.01£¬Ôò²ét·Ö²¼±íµÃt0.005(12?4)?3.3554£¬Õâʱ¸÷¸ö²ÎÊý¶ÔÓ¦µÄtͳ¼ÆÁ¿µÄ¾ø¶ÔÖµ¾ùСÓÚÁÙ½çÖµ£¬ÔòÔÚ??0.01µÄÏÔÖøÐÔˮƽ϶¼Ó¦½ÓÊÜH0:?j?0µÄÔ¼ÙÉè¡£
7.±íÖиø³öy¶Ô
x2ºÍx3»Ø¹éµÄ½á¹û£º
Àë²îÀ´Ô´ ƽ·½ºÍ£¨SS£© ×ÔÓɶȣ¨df£© ƽ·½ºÍµÄ¾ùÖµ£¨MSS£© À´×Իع飨ESS£© 65965 À´×ԲвRSS£© ×ÜÀë²î£¨TSS£© 66042 14
£¨1£© ¸Ã»Ø¹é·ÖÎöÖÐÑù±¾ÈÝÁ¿ÊǶàÉÙ£¿ £¨2£© ¼ÆËãRSS£»
£¨3£© ESSºÍRSSµÄ×ÔÓɶÈÊǶàÉÙ£¿
£¨4£© ¼ÆËã¿É¾öϵÊýºÍÐÞÕýµÄ¿É¾öϵÊý£»
£¨5£© ÔõÑù¼ìÑé2ºÍ3¶ÔyÊÇ·ñÓÐÏÔÖøÓ°Ï죿¸ù¾ÝÒÔÉÏÐÅÏ¢ÄÜ·ñÈ·¶¨
yµÄ¹±Ï×Ϊ¶àÉÙ£¿
½â£º£¨1£©¸Ã»Ø¹é·ÖÎöÖÐÑù±¾ÈÝÁ¿ÊÇn?dfTSS?1?15
£¨2£©¼ÆËãRSS?TSS?ESS?66042?65965?77 £¨3£© ESSµÄ×ÔÓɶÈΪk-1=2£¬RSSµÄ×ÔÓÉ¶È n-k=15-3=12 £¨4£©R2?xxx2ºÍx3¸÷×Ô¶Ô
ESS65965??0.9988£¬ TSS66042n?114R2?1??1?R2??1??1?0.9988??0.9986
n?k12£¨5£©ÓÃF¼ìÑ飺
ESS/?k?1?65965/2F???5140RSS/?n?k?77/12£¬
F0.05?2,12??3.89
x2,x3
ÕûÌå¶ÔyÓÐÏÔÖøÓ°Ï죬µ«²»ÄÜÈ·¶¨µ¥¸ö¶ÔyµÄ¹±Ïס£
µÚ°ËÕ£ºÊ±¼äÐòÁзÖÎöÓëÔ¤²â
˼¿¼ÓëÁ·Ï°
˼¿¼Ì⣺
Á·Ï°Ì⣺
1.ijÆû³µÖÆÔì³§2003Äê²úÁ¿Îª30ÍòÁ¾¡£
£¨1£©Èô¹æ¶¨2004¡ª2006ÄêÄêµÝÔöÂʲ»µÍÓÚ6%£¬ÆäºóÄêµÝÔöÂʲ»µÍÓÚ5%£¬2008Äê¸Ã³§Æû³µ
²úÁ¿½«´ïµ½¶àÉÙ£¿
£¨2£©Èô¹æ¶¨2013ÄêÆû³µ²úÁ¿ÔÚ2003ÄêµÄ»ù´¡ÉÏ·Ò»·¬£¬¶ø2004ÄêµÄÔö³¤ËÙ¶È¿ÉÍû´ïµ½
7.8%£¬ÎÊÒÔºó9ÄêÓ¦ÒÔÔõÑùµÄËÙ¶ÈÔö³¤²ÅÄÜ´ïµ½Ô¤¶¨Ä¿±ê£¿ £¨3£©Èô¹æ¶¨2013ÄêÆû³µ²úÁ¿ÔÚ2003ÄêµÄ»ù´¡ÉÏ·Ò»·¬£¬²¢ÒªÇóÿÄê±£³Ö7.4%µÄÔö³¤ËÙ¶È£¬
ÎÊÄÜÌáǰ¶àÉÙʱ¼ä´ïµ½Ô¤¶¨Ä¿±ê£¿
½â£º´ËÌâ´ð°¸µÄÄê·ÝÊý×ÖÓëÊé±¾Éϲ»Ò»Ñù£¬Òª×¢Òâ
ÉèiÄêµÄ»·±È·¢Õ¹Ë®Æ½Îªx i£¬ÔòÓÉÒÑÖªµÃ£ºx2003£½30£¬ £¨1£©ÓÖÖª£º
x2004x2005x2006xx32gg?£¨1?6%£©£¨1?5%£©£¬2007g2008?£¬Çóx2008
x2003x2004x2005x2006x2007x2008x2007x2008?g?(1?6%)3(1?5%)2 x2003x2003x2007 ÓÉÉϵÃ
¼´Îª
x2008?1.0631.052£¬´Ó¶ø2008Äê¸Ã³§Æû³µ²úÁ¿½«´ïµ½ 30µÃ x2008¡Ý30¡Á 1.063¡Á1.052= 30¡Á1.3131 = 39.393£¨ÍòÁ¾£© ´Ó¶ø°´¼Ù¶¨¼ÆË㣬2008Äê¸Ã³§Æû³µ²úÁ¿½«´ïµ½39.393ÍòÁ¾ÒÔÉÏ¡£
9xx2013x2004£½2£¬£½1+7.8£¥£¬Çó2013 £¨2£©¹æ¶¨
x2003x2003x2004ÓÉÉϵà 99xx2013x2013?2004 £½x2004x2003x2003£½?92?1.078?107.11%
¿ÉÖª£¬2004ÄêÒÔºó9ÄêÓ¦ÒÔ7.11£¥µÄËÙ¶ÈÔö³¤£¬²ÅÄÜ´ïµ½2013ÄêÆû³µ²úÁ¿ÔÚ2003
ÄêµÄ»ù´¡ÉÏ·Ò»·¬µÄÄ¿±ê¡£
£¨3£©É裺°´Ã¿Äê7.4%µÄÔö³¤ËÙ¶ÈnÄê¿É·Ò»·¬£¬ ÔòÓÐ 1.074?na2013?2 a2003 ËùÒÔ n?log1.0742?log20.30103??9.70939£¨Ä꣩
log1.0740.031004¿ÉÖª£¬°´Ã¿Äê±£³Ö7.4%µÄÔö³¤ËÙ¶È£¬Ô¼9.71ÄêÆû³µ²úÁ¿¿É´ïµ½ÔÚ2003Äê»ù´¡ÉÏ·Ò»·¬µÄÔ¤¶¨Ä¿±ê¡£
Թ涨·Ò»·¬µÄʱ¼ä´Ó2003Äêµ½2013ÄêΪ10Ä꣬¹Ê°´Ã¿Äê±£³Ö7.4%µÄÔö³¤ËÙ¶È£¬ÄÜÌáǰ0.29Äê¼´3¸öÔÂÁí14Ìì´ïµ½·Ò»·¬µÄÔ¤¶¨Ä¿±ê¡£
2.ijµØÇøÉç»áÉÌÆ·ÁãÊÛ¶î1988¡ª1992ÄêÆÚ¼ä£¨1987ÄêΪ»ùÆÚ£©Ã¿ÄêÆ½¾ùÔö³¤10%£¬1993¡ª1997ÄêÆÚ¼äÿÄêÆ½¾ùÔö³¤8.2%£¬1998¡ª2003ÄêÆÚ¼äÿÄêÆ½¾ùÔö³¤6.8%¡£ÎÊ2003ÄêÓë1987ÄêÏà±È¸ÃµØÇøÉç»áÉÌÆ·ÁãÊÛ¶î¹²Ôö³¤¶àÉÙ£¿ÄêÆ½¾ùÔö³¤ËÙ¶ÈÊǶàÉÙ£¿Èô1997ÄêÉç»áÉÌÆ·ÁãÊÛ¶îΪ30ÒÚÔª£¬°´´Ëƽ¾ùÔö³¤ËÙ¶È£¬2004ÄêµÄÉç»áÉÌÆ·ÁãÊÛ¶îӦΪ¶àÉÙ£¿
½â£º´ËÌâ´ð°¸µÄÄê·ÝÊý×ÖÓëÊé±¾Éϲ»Ò»Ñù£¬Òª×¢Òâ
ÉèiÄêµÄ»·±È·¢Õ¹Ë®Æ½Îªx i£¬ÔòÒÑÖªµÄÈý¶ÎÄê¾ùÔö³¤ÂʱíʾΪ£º