ͳ¼ÆÑ§±¾¿Æ±ÏÒµÂÛÎijõ¸å ¡ª¡ªExcel ÔÚ¶àÔª»Ø¹é·ÖÎöÖеÄÓ¦ÓÃÑо¿(3)

2019-05-17 19:36

Óɻعéͳ¼Æ±í¿ÉÒԵõ½ÒÔϼ¸¸ö²¿·Ö¡£ 1.Multiple R£¨¸´Ïà¹ØÏµÊýR£©£ºÊÇR2µÄƽ·½¸ù£¬ÓÖ³ÆÎªÏà¹ØÏµÊý£¬ÊÇÓÃÀ´ºâÁ¿xºÍyÖ®¼äÏà¹Ø³Ì¶ÈµÄ´óС¡£ÕâÀïµÄR=0.99791496£¬±íʾÁËËûÃÇÖ®¼äÊÇÕýÏà¹ØµÄ¹ØÏµ¡£

2.R Square£¨¸´²â¶¨ÏµÊýR2£©£ºÓÃÀ´ËµÃ÷×Ô±äÁ¿½âÊÍÒò±äÁ¿±ä²îµÄ³Ì¶È£¬ÒԲⶨÒò±äÁ¿yµÄÄâºÏ¶È¡£ÕâÀïµÄR2=0.995834268£¬±íÏÖÁË×Ô±äÁ¿ÓëÒò±äÁ¿Ö®¼äµÄÄâºÏЧ¹ûºÜºÃ¡£¸´Ïà¹ØÏµÊý×÷Ϊһ¸ö¼ìÑé×ܵĻعéЧ¹ûµÄÒ»¸öÖ¸±ê£¬ÔÚÕâÀï˵Ã÷ÁËÊý¾ÝÖ®¼äµÄÄâºÏ¶ÈºÜºÃ£¬»Ø¹éЧ¹ûÒ²ºÜºÃ¡£ 3.Adjusted R Square£¨µ÷Õû¸´²â¶¨ÏµÊýR2£©£ºÓÃÓÚ¼ÓÈë¶ÀÁ¢±äÁ¿ºóÄ£Ð͵ÄÄâºÏ³Ì¶È£¬ÕâÀïµÄµ÷Õû¸´²â¶¨ÏµÊýΪ0.990279958£¬ËµÃ÷¸Ã¶àÔª»Ø¹éÖУ¬¼ÓÈë¶ÀÁ¢±äÁ¿ºó£¬Ä£Ð͵ÄÄâºÏ¶ÈºÜºÃ¡£

4.±ê×¼Îó²î£ºÊÇÓÃÀ´ºâÁ¿ÄâºÏ³Ì¶ÈµÄ´óСµÄ£¬±ê×¼Îó²îԽС˵Ã÷ÄâºÏ³Ì¶ÈÔ¼ºÃ£¬ÕâÀïµÄ±ê×¼ÎóΪ4.20449866£¬ËµÃ÷Ä£Ð͵ÄÄâºÏ³Ì¶ÈºÜºÃ¡£

5.¹Û²âÖµ£ºÕâÀïµÄ¹Û²âֵΪ8£¬ËµÃ÷ÓÃÀ´¹À¼Æ»Ø¹é·½³ÌµÄÊý¾ÝµÄ¹Û²âֵΪ8¸ö¡£

ÒÔÉÏΪ·½²î·ÖÎö±í£¬ÆäÖ÷ÒªÖØÓÃÊÇͨ¹ýF¼ìÑéÀ´ÅжϻعéÄ£Ð͵ĻعéЧ¹û¡£¡°»Ø¹é·ÖÎö¡±ÐмÆËãµÄÊǹÀ¼ÆÖµÍ¬¾ùÖµÖ®²îµÄ¸÷ÏîÖ¸±ê£»¡°²Ð²î¡±ÐÐÊÇÓÃÓÚ¼ÆËãÿ¸öÑù±¾¹Û²âÖµÓë¹À¼ÆÖµÖ®²îµÄ¸÷ÏîÖ¸±ê£»¡°×ܼơ±ÐÐÓÃÓÚ¼ÆËãÿ¸öֵͬ¾ùÖµÖ®²îµÄ¸÷ÏîÖ¸±ê¡£ÓÉ·½²î·ÖÎö±í¿ÉÖª£º

DfÊÇ×ÔÓɶȣ¬ÕâÀïµÄ»Ø¹é·ÖÎöµÄ×ÔÓɶÈΪ4£¬²Ð²îµÄ×ÔÓɶÈΪ3¡£»Ø¹é·ÖÎöµÄÀë²îƽ·½ºÍΪ12677.84455£¬²Ð²îµÄÀë²îƽ·½ºÍΪ53.03342694£»»Ø¹é·ÖÎöµÄ¾ù·½²î£¨¼´Àë²îƽ·½ºÍ³ýÒÔ×ÔÓɶȣ©Îª3169.461138£¬²Ð²îµÄ¾ù·½²îΪ17.67780898£»Fͳ¼ÆÁ¿Îª179.2903827£¬Significance FÊÇÔÚÏÔÖøÐÔˮƽÏÂFµÄÁÙ½çÖµ£¬ÆäΪ0.000670487¡£

ÒÔÉÏΪ»Ø¹é²ÎÊý±í£¬ÆäÖ÷ÒªÓÃÓڻع鷽³ÌµÄÃèÊöºÍ»Ø¹é²ÎÊýµÄÍÆ¶Ï¡£ÆäÖеÚÒ»ÁзֱðΪ?0£¨½Ø¾à£©ºÍ?1£¬?2£¬?3£¬?4£¨Ð±ÂÊ£©µÄ¸÷ÏîÖ¸±ê¡£µÃµ½ÈçϵĻع鷽³Ì£¨ËùÓÐȡֵ±£ÁôÁ½Î»Ð¡Êý£©£º

y??46.02?3.07x1?18.06x2?62.11x3?120.78x4

3.2 SPSS¶àÔª»Ø¹é·ÖÎö 3.2.1Ïà¹Ø·ÖÎö

£¨1£©¶ÔyÓë¸÷¸ö±äÁ¿×÷³öÉ¢µãͼ

ÌÔ±¦×¢²áÈËÊýx1ÓëyµÄÏà¹ØÐÔÉ¢µãͼ£º

ÍøÂçÆÕ¼°¶ÈÓëÌÔ±¦Íø½»Ò××ܶîµÄÏà¹ØÐÔ¼ìÑ飺

ÎÒ¹ú¾ÓÃñÏû·ÑˮƽÓëÌÔ±¦½»Ò×µÄÏà¹ØÐÔ¼ìÑ飺

ÎÒ¹úÈ˾ùÊÕÈëÓëÌÔ±¦½»Ò×µÄÏà¹ØÐÔ¼ìÑ飺

ÓÉÒÔÉÏËĸöÉ¢µãͼ¿ÉÖª£¬ÆäËùÓеĵã¾ùÂäÔÚÁË×óÉÏÖÁÓÒϵÄÒ»ÌõÖ±ÏßÉÏ£¬±íÃ÷ÁËÊý¾ÝÖ®¼ä´æÔÚÍêÈ«ÕýÏà¹Ø¹ØÏµ¡£ËùÒÔÎÒÃÇ»¹ÐèÒª¶ÔÊý¾Ý½øÐнøÒ»²½µÄ·ÖÎö£¬µÃµ½È·ÇеĴ𰸡£

£¨2£©¼ÆËãÏà¹ØÏµÊý

ÓÃSPSS¶ÔÊý¾Ý½øÐÐÏà¹ØÐÔ·ÖÎö£¬µÃµ½ÈçϵÄÏà¹ØÏµÊýͼ

½âÎö£ºÍ¼ÖÐÓдø¡°**¡±ºÅµÄ½á¹û±íÃ÷ÓйصÄÁ½±äÁ¿ÔÚ0.01µÄÏÔÖøÐÔˮƽÏÂÏÔÖøÏà¹Ø£¬ÓÉÉÏͼ¿ÉÖª£¬yÓëx1µÄÏà¹ØÏµÊýΪ0.992>0£¬±íʾ³ÊÒ»¶¨µÄÏßÐÔ¹ØÏµ£¬Ïà¹ØÏµÊý¼ìÑé¶ÔÓ¦µÄ¸ÅÂÊPֵΪ0.000£¬Ð¡ÓÚÏÔÖøÐÔˮƽ0.05£¬ËµÃ÷ÌÔ±¦½»Ò×¶îÓëÌÔ±¦×¢²áÈËÊýÖ®¼äÏà¹ØÐÔÏÔÖø¡£yÓëx2µÄÏà¹ØÏµÊýΪ0.901>0£¬±íʾ³ÊÒ»¶¨µÄÏßÐÔ¹ØÏµ£¬Ïà¹ØÏµÊý¼ìÑé¶ÔÓ¦µÄ¸ÅÂÊPֵΪ0.002£¬Ð¡ÓÚÏÔÖøÐÔˮƽ0.05£¬ËµÃ÷ÌÔ±¦½»Ò×¶îÓëÎÒ¹úÍøÂçÆÕ¼°¶ÈÖ®¼äÏà¹ØÐÔÏÔÖø¡£yÓëx3µÄÏà¹ØÏµÊýΪ0.965>0£¬±íʾ³ÊÒ»¶¨µÄÏßÐÔ¹ØÏµ£¬Ïà¹ØÏµÊý¼ìÑé¶ÔÓ¦µÄ¸ÅÂÊPֵΪ0.000£¬Ð¡ÓÚÏÔÖøÐÔˮƽ0.05£¬ËµÃ÷ÌÔ±¦½»Ò×¶îÓë¾ÓÃñÏû·Ñˮƽ֮¼äÏà¹ØÐÔÏÔÖø¡£yÓëx4µÄÏà¹ØÏµÊýΪ0.958>0£¬±íʾ³ÊÒ»¶¨µÄÏßÐÔ¹ØÏµ£¬Ïà¹ØÏµÊý¼ìÑé¶ÔÓ¦µÄ¸ÅÂÊPֵΪ0.000£¬Ð¡ÓÚÏÔÖøÐÔˮƽ0.05£¬ËµÃ÷ÌÔ±¦½»Ò×¶îÓëÎÒ¹úÈ˾ù´¿ÊÕÈëÖ®¼äÏà¹ØÐÔÏÔÖø¡£ 3.2.2»Ø¹é·ÖÎö

½âÎö£º¸´Ïà¹ØÏµÊýΪ0.998£¬Åж¨ÏµÊýΪ0.996£¬µ÷ÕûϵÊýΪ0.991£¬¹À¼ÆÖµµÄ±ê×¼Îó²îΪ2.115 ¡£


ͳ¼ÆÑ§±¾¿Æ±ÏÒµÂÛÎijõ¸å ¡ª¡ªExcel ÔÚ¶àÔª»Ø¹é·ÖÎöÖеÄÓ¦ÓÃÑо¿(3).doc ½«±¾ÎĵÄWordÎĵµÏÂÔØµ½µçÄÔ ÏÂÔØÊ§°Ü»òÕßÎĵµ²»ÍêÕû£¬ÇëÁªÏµ¿Í·þÈËÔ±½â¾ö£¡

ÏÂһƪ£ºÐÄÀíѧ¸´Ï°Ìâ

Ïà¹ØÔĶÁ
±¾ÀàÅÅÐÐ
¡Á ×¢²á»áÔ±Ãâ·ÑÏÂÔØ£¨ÏÂÔØºó¿ÉÒÔ×ÔÓɸ´ÖƺÍÅŰ棩

ÂíÉÏ×¢²á»áÔ±

×¢£ºÏÂÔØÎĵµÓпÉÄÜ¡°Ö»ÓÐĿ¼»òÕßÄÚÈݲ»È«¡±µÈÇé¿ö£¬ÇëÏÂÔØÖ®Ç°×¢Òâ±æ±ð£¬Èç¹ûÄúÒѸ¶·ÑÇÒÎÞ·¨ÏÂÔØ»òÄÚÈÝÓÐÎÊÌ⣬ÇëÁªÏµÎÒÃÇЭÖúÄã´¦Àí¡£
΢ÐÅ£º QQ£º