ͳ¼ÆÑ§µÚÈý°æ£¨Ô¬ÎÀ¡¢ÅӺƣ©¿ÎºóϰÌâ´ð°¸ ÏÂÔØ±¾ÎÄ

²ÎÊýµÄ¾­¼ÃÒâÒåÊÇÿ¹ÉÕÊÃæ¼ÛÖµÔö¼Ó1Ԫʱ£¬µ±ÄêºìÀû½«Æ½¾ùÔö¼Ó0.072876Ôª¡£ ÐòºÅ6µÄ¹«Ë¾Ã¿¹ÉÕÊÃæ¼ÛֵΪ19.25Ôª£¬Ôö¼Ó1ÔªºóΪ20.25Ôª£¬µ±ÄêºìÀû¿ÉÄÜΪ£º

^Yi?0.479775?0.072876?20.25?1.955514(Ôª)

8.4 £¨1£©Êý¾ÝÉ¢µãͼÈçÏ£º

ͶËßÂÊ£¨´Î/10ÍòÃû³Ë¿Í£©1.41.210.80.60.40.20657075º½°àÕýµãÂÊ(%)8085

£¨2£©¸ù¾ÝÉ¢µãͼ¿ÉÒÔ¿´³ö£¬Ëæ×ź½°àÕýµãÂʵÄÌá¸ß£¬Í¶ËßÂʳÊÏÖ³öϽµµÄÇ÷ÊÆ£¬Á½ÕßÖ®¼ä´æÔÚ×ÅÒ»¶¨µÄ¸ºÏà¹Ø¹ØÏµ¡£

£¨3£©ÉèͶËßÂÊΪY£¬º½°àÕýµãÂÊΪX

½¨Á¢»Ø¹é·½³Ì Yi??1??2Xi?ui ¹À¼Æ²ÎÊýΪ Yi?6.0178?0.07Xi

£¨4£©²ÎÊýµÄ¾­¼ÃÒâÒåÊǺ½°àÕýµãÂÊÿÌá¸ßÒ»¸ö°Ù·Öµã£¬ÏàÓ¦µÄͶËßÂÊ£¨´Î/10ÍòÃû³Ë¿Í£©Ï½µ0.07¡£ £¨5£©º½°à°´Ê±µ½´ïµÄÕýµãÂÊΪ80%£¬¹À¼ÆÃ¿10ÍòÃû³Ë¿ÍͶËߵĴÎÊý¿ÉÄÜΪ£º

^??6.0178?0.07?80?0.4187£¨´Î/10Íò£© Yi8.5 ÓÉ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£¬ËµÃ÷Ä£ÐÍÔÚÕûÌåÉÏÊÇÏÔÖøµÄ¡£

8.6 £¨1£©¸Ã»Ø¹é·ÖÎöÖÐÑù±¾ÈÝÁ¿ÊÇ14+1=15 £¨2£©¼ÆËãRSS=66042-65965=77

ESSµÄ×ÔÓɶÈΪk-1=2£¬RSSµÄ×ÔÓÉ¶È n-k=15-3=12 £¨3£©¼ÆË㣺¿É¾öϵÊý R?65965/66042?0.9988 ÐÞÕýµÄ¿É¾öϵÊý R?1?2^215?1?(1?0.9988?)15?30. 9986£¨4£©¼ìÑéX2ºÍX3¶ÔYÊÇ·ñÓÐÏÔÖøÓ°Ïì

F?ESS/(k?1)65965/232982???5140.11

RSS/(n?k)77/126.4166 (5) Fͳ¼ÆÁ¿Ô¶±ÈFÁÙ½çÖµ´ó£¬ËµÃ÷X2ºÍX3ÁªºÏÆðÀ´¶ÔYÓÐÏÔÖøÓ°Ï죬µ«²¢²»ÄÜÈ·¶¨X2ºÍX3¸÷×Ô¶ÔYµÄ¹±Ï×Ϊ¶àÉÙ¡£

9

8.7

À´ Ô´ À´×Իعé À´×Բвî ×ÜÀë²îƽ·½ºÍ ^ƽ·½ºÍ 2179.56 99.11 2278.67 ×ÔÓÉ¶È 1 22 23 ·½²î 2179.56 4.505 8.8 £¨1£©ÓÃExcelÊäÈëYºÍXÊý¾Ý£¬Éú³ÉXºÍ

2X3µÄÊý¾Ý£¬ÓÃY¶ÔX¡¢X2¡¢X3»Ø¹é£¬¹À¼Æ²ÎÊý

½á¹ûΪ

Yi??1726.73?7.879646874Xi?0.00895X2?3.71249E?06X3

t=(-1.9213) (2.462897) (-2.55934) (3.118062)

22 R?0.973669 R?0.963764

£¨2£©¼ìÑé²ÎÊýµÄÏÔÖøÐÔ£ºµ±È¡??0.05ʱ£¬²ét·Ö²¼±íµÃt0.025(12?4)?2.306£¬Óëtͳ¼ÆÁ¿¶Ô±È£¬³ýÁ˽ؾàÏîÍ⣬

¸÷»Ø¹éϵÊý¶ÔÓ¦µÄtͳ¼ÆÁ¿µÄ¾ø¶ÔÖµ¾ù´óÓÚÁÙ½çÖµ£¬±íÃ÷ÔÚÕâÑùµÄÏÔÖøÐÔˮƽÏ£¬»Ø¹éϵÊýÏÔÖø²»Îª0¡£ £¨3£©¼ìÑéÕû¸ö»Ø¹é·½³ÌµÄÏÔÖøÐÔ£ºÄ£Ð͵ÄR?0.973669,R?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È·ÓÐÏÔÖøÓ°Ïì¡£

£¨4£©¼ÆËã×ܳɱ¾¶Ô²úÁ¿µÄ·ÇÏßÐÔÏà¹ØÏµÊý£ºÒòΪR?0.973669Òò´Ë×ܳɱ¾¶Ô²úÁ¿µÄ·ÇÏßÐÔÏà¹ØÏµÊýΪ

22322R2?0.973669»òR=0.9867466

£¨5£©ÆÀ¼Û£ºËäÈ»¾­t¼ìÑé¸÷¸öϵÊý¾ùÊÇÏÔÖøµÄ£¬µ«ÓëÁÙ½çÖµ¶¼Ê®·Ö½Ó½ü£¬ËµÃ÷t¼ìÑéÖ»ÊÇÃãǿͨ¹ý£¬Æä°ÑÎÕ²¢²»´ó¡£Èç¹ûÈ¡??0.01£¬Ôò²ét·Ö²¼±íµÃt0.005(12?4)?3.3554£¬Õâʱ¸÷¸ö²ÎÊý¶ÔÓ¦µÄtͳ¼ÆÁ¿µÄ¾ø¶ÔÖµ¾ùСÓÚÁÙ½çÖµ£¬ÔòÔÚ??0.01µÄÏÔÖøÐÔˮƽ϶¼Ó¦½ÓÊÜH0:?j?0µÄÔ­¼ÙÉè¡£ 8.9 ÀûÓÃExcelÊäÈëX¡¢yºÍYÊý¾Ý£¬ÓÃY¶ÔX»Ø¹é£¬¹À¼Æ²ÎÊý½á¹ûΪ

??5.73?0.314x Yii tÖµ=£¨9.46£©£¨-6.515£© R?0.794 R?0.775

22??307.9693?eÕûÀíºóµÃµ½£ºy

?0.314x

µÚ9Õ ʱ¼äÐòÁзÖÎö

9.1 £¨1£©30¡Á 1.06¡Á1.05= 30¡Á1.3131 = 39.393£¨ÍòÁ¾£©

£¨2£©9(30?2)/(30?1.078)?1?92/1.078?1?7.11% £¨3£©Éè°´7.4%µÄÔö³¤ËÙ¶ÈnÄê¿É·­Ò»·¬

ÔòÓÐ 1.074?60/30?2

ËùÒÔ n = log2 / log1.074 = 9.71£¨Ä꣩

¹ÊÄÜÌáǰ0.29Äê´ïµ½·­Ò»·¬µÄÔ¤¶¨Ä¿±ê¡£

9.2 £¨1£©£¨1£©ÒÔ1987ÄêΪ»ùÆÚ£¬2003ÄêÓë1987ÄêÏà±È¸ÃµØÇøÉç»áÉÌÆ·ÁãÊÛ¶î¹²Ôö³¤£º (1?10%)?(1?8.2%)?(1?6.8%)?1?3.3186?1?2.3186?231.86% £¨2£©ÄêÆ½¾ùÔö³¤ËÙ¶ÈΪ

1532n555(1?10%)5?(1?8.2%)5?(1?6.8%)5?1=0.0833=8.33%

(3) 2004ÄêµÄÉç»áÉÌÆ·ÁãÊÛ¶îӦΪ

30?(1?0.0833)7?52.509£¨ÒÚÔª£©

10

9.3 £¨1£©·¢Õ¹×ÜËÙ¶È(1?12%)3?(1?10%)4?(1?8%)3?259.12%

ƽ¾ùÔö³¤ËÙ¶È=10259.12%?1?9.9892%

£¨2£©500?(1?6%)2?561.8£¨ÒÚÔª£©

14570£¨3£©Æ½¾ùÊýy??yj?£¬ ?142.5£¨ÒÚÔª£©

4j?14 2002ÄêÒ»¼¾¶ÈµÄ¼Æ»®ÈÎÎñ£º105%?142.5?149.625£¨ÒÚÔª£©¡£

9.4 (1)ÓÃÿ¹ÉÊÕÒæÓëÄê·ÝÐòºÅ»Ø¹éµÃYt?0.365?0.193t¡£Ô¤²âÏÂÒ»Äê(µÚ11Äê)µÄÿ¹ÉÊÕÒæÎª

^??0.365?0.193?11?2.488Ôª Y11(2)ʱ¼äÊýÁÐÊý¾Ý±íÃ÷¸Ã¹«Ë¾¹ÉƱÊÕÒæÖðÄêÔö¼Ó£¬Ç÷ÊÆ·½³ÌÒ²±íÃ÷ƽ¾ùÿÄêÔö³¤0.193Ôª¡£ÊÇÒ»¸ö½ÏΪÊʺϵÄͶ×Ê

·½Ïò¡£

9.5 £¨1£©Òƶ¯Æ½¾ù·¨Ïû³ý¼¾½Ú±ä¶¯¼ÆËã±í Äê±ð 2000Äê 2001Äê 2002Äê 2003Äê ¼¾±ð Ò»¼¾¶È ¶þ¼¾¶È Èý¼¾¶È Ëļ¾¶È Ò»¼¾¶È ¶þ¼¾¶È Èý¼¾¶È Ëļ¾¶È Ò»¼¾¶È ¶þ¼¾¶È Èý¼¾¶È Ëļ¾¶È Ò»¼¾¶È ¶þ¼¾¶È Èý¼¾¶È Ëļ¾¶È Ïʵ°ÏúÊÛÁ¿ 13.1 13.9 7.9 8.6 10.8 11.5 9.7 11 14.6 17.5 16 18.2 18.4 20 16.9 18 ËÄÏîÒÆ¶¯Æ½¾ùÖµ 10.875 10.3 9.7 10.15 10.75 11.7 13.2 14.775 16.575 17.525 18.15 18.375 18.325 ?£©ÒÆÕýƽ¾ùÖµ£¨T ¡ª ¡ª 10.5875 10 9.925 10.45 11.225 12.45 13.9875 15.675 17.05 17.8375 18.2625 18.35 ??8.9625?0.63995?t £¨2£©Tt£¨3£©Ç÷ÊÆÌÞ³ö·¨¼¾½Ú±ÈÀý¼ÆËã±í£¨Ò»£© Äê±ð 2000Äê 2001Äê 2002Äê 2003Äê

¼¾±ð Ò»¼¾¶È ¶þ¼¾¶È Èý¼¾¶È Ëļ¾¶È Ò»¼¾¶È ¶þ¼¾¶È Èý¼¾¶È Ëļ¾¶È Ò»¼¾¶È ¶þ¼¾¶È Èý¼¾¶È Ëļ¾¶È Ò»¼¾¶È ʱ¼äÐòÁкÅt 1 2 3 4 5 6 7 8 9 10 11 12 13 Ïʵ°ÏúÊÛÁ¿ 13.1 13.9 7.9 8.6 10.8 11.5 9.7 11 14.6 17.5 16 18.2 18.4 Ô¤²â Ïʵ°ÏúÊÛÁ¿ 9.332352941 9.972205882 10.61205882 11.25191176 11.89176471 12.53161765 13.17147059 13.81132353 14.45117647 15.09102941 15.73088235 16.37073529 17.01058824 Ç÷ÊÆÌÞ³ýÖµ 1.403718878 1.39387415 0.74443613 0.764314561 0.908191531 0.917678812 0.736440167 0.796447927 1.010298368 1.159629308 1.0171076 1.111739923 1.081679231 11

¶þ¼¾¶È 14 20 17.65044118 1.133116153 Èý¼¾¶È 15 16.9 18.29029412 0.923987329 Ëļ¾¶È 16 18 18.93014706 0.950864245 ÉϱíÖУ¬ÆäÇ÷ÊÆÄâºÏΪֱÏß·½³ÌT?t?8.9625?0.63995?t¡£ Ç÷ÊÆÌÞ³ö·¨¼¾½Ú±ÈÀý¼ÆËã±í£¨¶þ£© ¼¾¶È Äê¶È Ò»¼¾¶È ¶þ¼¾¶È Èý¼¾¶È Ëļ¾¶È 2000Äê 1.403719 1.393874 0.744436 0.764315 ¡ª 2001Äê 0.908192 0.917679 0.73644 0.796448 ¡ª 2002Äê 1.010298 1.159629 1.017108 1.11174 ¡ª 2003Äê 1.081679 1.133116 0.923987 0.950864 ¡ª ƽ ¾ù 1.100972 1.151075 0.855493 0.905842 4.013381 ¼¾½Ú±ÈÂÊ% 1.097301 1.147237 0.852641 0.902822 4£®00000 ¸ù¾ÝÉÏ±í¼ÆËãµÄ¼¾½Ú±ÈÂÊ£¬°´ÕÕ¹«Ê½Y?t?T?t?S?t?KL¼ÆËã¿ÉµÃ£º

2004ÄêµÚÒ»¼¾¶ÈÔ¤²âÖµ£º

Y?17?T?17?S?1?(8.9625?0.63995?17)?1.097301?21.7723 2004ÄêµÚ¶þ¼¾¶ÈÔ¤²âÖµ£º

Y?18?T?18?S?2?(8.9625?0.63995?18)?1.147237?23.49725 2004ÄêµÚÈý¼¾¶ÈÔ¤²âÖµ£º

Y?19?T?19?S?3?(8.9625?0.63995?19)?0.852641?18.009 2004ÄêµÚËļ¾¶ÈÔ¤²âÖµ£º

Y?20?T?20?S?4?(8.9625?0.63995?20)?0.902822?19.6468 9.6 (1)ÓÃԭʼ×ÊÁÏ·¨¼ÆËãµÄ¸÷Ô¼¾½Ú±ÈÂÊΪ: ÔÂ·Ý 1Ô 2Ô 3Ô 4Ô 5Ô 6Ô ¼¾½Ú±ÈÂÊ 0.9195 0.7868 0.9931 1.0029 1.0288 1.0637 ÔÂ·Ý 7Ô 8Ô 9Ô 10Ô 11Ô 12Ô ¼¾½Ú±ÈÂÊ 0.9722 0.9851 1.0407 1.0350 1.0765 1.0958

ƽ¾ù·¨¼ÆËã¼¾½Ú±ÈÂÊ±í£º

Äê±ð ÔÂ·Ý 2000Äê 2001Äê 2002Äê 2003Äê Æ½¾ù ¼¾½Ú±ÈÂÊ% 1Ô 4.78 5.18 6.46 6.82 5.80875 0.9195 2Ô 3.97 4.61 5.62 5.68 4.97025 0.7868 3Ô 5.07 5.69 6.96 7.38 6.2735 0.9931 4Ô 5.12 5.71 7.12 7.40 6.33575 1.0029 5Ô 5.27 5.90 7.23 7.60 6.49925 1.0288 6Ô 5.45 6.05 7.43 7.95 6.7195 1.0637 7Ô 4.95 5.65 6.78 7.19 6.1415 0.9722 8Ô 5.03 5.76 6.76 7.35 6.223 0.9851 9Ô 5.37 6.14 7.03 7.76 6.574 1.0407 10Ô 5.34 6.14 6.85 7.83 6.53825 1.0350 11Ô 5.54 6.47 7.03 8.17 6.80025 1.0765 12Ô 5.44 6.55 7.22 8.47 6.9225 1.0958 ƽ¾ù 6.317208 1.0000

12