±±¾©Ê¯ÓÍ»¯¹¤Ñ§Ôº2026ÄêÑо¿ÉúÕÐÉú½ÓÊÕµ÷¼Á¹«¸æ
²é¿´: 1453  |  »Ø¸´: 7

zxhappy

ÖÁ×ðľ³æ (Ö°Òµ×÷¼Ò)

[ÇóÖú] Çó¶þÔª»Ø¹é·½³ÌµÄ×ö·¨

ÎÒÏë×ÉѯÏÂÔõôÓÃexcel»òorigin×ö¸ö¶þÔª»Ø¹é·½³Ì£¬ÏñÕâÖÖY=aX1+bX2+c µÄ ¾ßÌåÊý¾ÝÈçÏ£¬ÍùÄÄλ´óÏÀ°ïæÇó½â£¬¸Ð¼¤ÌéÁ㣡
X1            X2               Y
40        6.4        1246
38        6.6        1241
36        6.8        1239
34        7.07        1229
32        7.3        1225
30        7.56        1220
28        7.82        1218
26        8.11        1215
24        8.41        1197
22        8.73        1192
20        9.08        1185


[ Last edited by zxhappy on 2013-3-19 at 15:16 ]
»Ø¸´´ËÂ¥

» ²ÂÄãϲ»¶

» ±¾Ö÷ÌâÏà¹Ø¼ÛÖµÌùÍÆ¼ö£¬¶ÔÄúͬÑùÓаïÖú:

¼á³ÖŬÁ¦
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

ÕÅåûÇí

ľ³æ (³õÈëÎÄ̳)

¡¾´ð°¸¡¿Ó¦Öú»ØÌû

¸Ðл²ÎÓ룬ӦÖúÖ¸Êý +1
ÎÒÃÇֻѧ¹ýÈçºÎʹÓüÆËã»ú¼ÆËã³ö¶þÔª»Ø¹é·½³Ì£¬Ã»ÓÐÓÃexcel×ö¹ý£¬
·Ü¶·¡¢¼á³Ö¡¢Î¢Ð¦¡¢ºñ»ý±¡·¢¡¢
2Â¥2013-03-19 20:15:34
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

zxhappy

ÖÁ×ðľ³æ (Ö°Òµ×÷¼Ò)

ÒýÓûØÌû:
2Â¥: Originally posted by ÕÅåûÇí at 2013-03-19 20:15:34
ÎÒÃÇֻѧ¹ýÈçºÎʹÓüÆËã»ú¼ÆËã³ö¶þÔª»Ø¹é·½³Ì£¬Ã»ÓÐÓÃexcel×ö¹ý£¬

ÔõôÇó£¬ÄãÄܰïÎÒÇóÒ»ÏÂÂð£¬Êý¾Ý¾ÍÊÇÉÏÃæÄÇÈýÁУ¬Ð»Ð»O(¡É_¡É)Oлл
¼á³ÖŬÁ¦
3Â¥2013-03-20 08:36:06
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

dingd

Ìú¸Ëľ³æ (Ö°Òµ×÷¼Ò)

¡¾´ð°¸¡¿Ó¦Öú»ØÌû

¡ï ¡ï ¡ï ¡ï ¡ï
¸Ðл²ÎÓ룬ӦÖúÖ¸Êý +1
zxhappy: ½ð±Ò+5, ¡ï¡ï¡ïºÜÓаïÖú, ллÄã 2013-04-08 19:30:02
×î¼òµ¥µÄ¶àÔªÏßÐԻع飺

¾ù·½²î(RMSE): 2.76465289364822
²Ð²îƽ·½ºÍ(SSE): 84.0763618459321
Ïà¹ØÏµÊý(R): 0.989782941926688
Ïà¹ØÏµÊý֮ƽ·½(R^2): 0.97967027212905

²ÎÊý        ×î¼Ñ¹ÀËã
----------        -------------
a        -2.09342912671277
b        -38.2471689221857
c        1573.27310372801
4Â¥2013-03-20 10:45:23
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

zxhappy

ÖÁ×ðľ³æ (Ö°Òµ×÷¼Ò)

ÒýÓûØÌû:
4Â¥: Originally posted by dingd at 2013-03-20 10:45:23
×î¼òµ¥µÄ¶àÔªÏßÐԻع飺

¾ù·½²î(RMSE): 2.76465289364822
²Ð²îƽ·½ºÍ(SSE): 84.0763618459321
Ïà¹ØÏµÊý(R): 0.989782941926688
Ïà¹ØÏµÊý֮ƽ·½(R^2): 0.97967027212905

²ÎÊý        ×î¼Ñ¹ÀËã
----------        ------- ...

ллÄ㣬ÄÜÈÃÎÒ¿´ÏÂÄãµÄͼÂð£¬ÒòΪÎÒ²»¶®ÊDz»ÊÇÕâ¸öÀàÐÍ·½³Ì£¬Ò²ÐíÊÇY=Ax2+bX+c  ÄǸöÊÇxµÄƽ·½£¬»¹ÓÐÕâ¸ö»Ø¹é·½³ÌÊÇÄâºÏ·½³ÌÂð£¿Ð»Ð»Ä㣬ÎÊÌâ±È½Ï¶à£¬Âé·³ÁË
¼á³ÖŬÁ¦
5Â¥2013-03-20 14:47:28
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

huansiqi

Òø³æ (³õÈëÎÄ̳)

ÒýÓûØÌû:
4Â¥: Originally posted by dingd at 2013-03-20 10:45:23
×î¼òµ¥µÄ¶àÔªÏßÐԻع飺

¾ù·½²î(RMSE): 2.76465289364822
²Ð²îƽ·½ºÍ(SSE): 84.0763618459321
Ïà¹ØÏµÊý(R): 0.989782941926688
Ïà¹ØÏµÊý֮ƽ·½(R^2): 0.97967027212905

²ÎÊý        ×î¼Ñ¹ÀËã
----------        ------- ...

ÄúºÃ£¬ÎÒÒ²Óöµ½¸ú°æÖ÷ͬÑùµÄÎÊÌ⣬ҲÊÇÏë×ö³öÒ»¸öy=ax1+bx2+cµÄ·½³Ì£¬Èç¹ûÄú·½±ã£¬ÄÜ·ñ°ïÎÒÒ²×öһϣ¬Èç¹ûÄÜÓлعéͼ¸üºÃ£¬·Ç³£¸Ðл¡£
6Â¥2013-10-14 09:00:31
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

huansiqi

Òø³æ (³õÈëÎÄ̳)

ÒýÓûØÌû:
4Â¥: Originally posted by dingd at 2013-03-20 10:45:23
×î¼òµ¥µÄ¶àÔªÏßÐԻع飺

¾ù·½²î(RMSE): 2.76465289364822
²Ð²îƽ·½ºÍ(SSE): 84.0763618459321
Ïà¹ØÏµÊý(R): 0.989782941926688
Ïà¹ØÏµÊý֮ƽ·½(R^2): 0.97967027212905

²ÎÊý        ×î¼Ñ¹ÀËã
----------        ------- ...

ÕâÊÇÎÒµÄÊý¾Ý£¬·Ç³£¸Ðл¡£

» ±¾Ìû¸½¼þ×ÊÔ´Áбí

  • »¶Ó­¼à¶½ºÍ·´À¡£ºÐ¡Ä¾³æ½öÌṩ½»Á÷ƽ̨£¬²»¶Ô¸ÃÄÚÈݸºÔð¡£
    ±¾ÄÚÈÝÓÉÓû§×ÔÖ÷·¢²¼£¬Èç¹ûÆäÄÚÈÝÉæ¼°µ½ÖªÊ¶²úȨÎÊÌ⣬ÆäÔðÈÎÔÚÓÚÓû§±¾ÈË£¬Èç¶Ô°æÈ¨ÓÐÒìÒ飬ÇëÁªÏµÓÊÏ䣺xiaomuchong@tal.com
  • ¸½¼þ 1 : н¨MicrosoftExcel¹¤×÷±í.xlsx
  • 2013-10-14 09:01:42, 38.2 K
7Â¥2013-10-14 09:03:46
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

feixiaolin

ÈÙÓþ°æÖ÷ (ÎÄ̳¾«Ó¢)

ÓÅÐã°æÖ÷

¡¾´ð°¸¡¿Ó¦Öú»ØÌû

ÔÚExcelÖÐ
ÏÈÓùÀ¼ÆÓÃCORREL¹À¼Æx1¡¢x2¶Ô Y µÄÏà¹ØÏµÊý£¬ÓÃx1+x2¶Ô Y ÄâºÏÒ»´Î£»
ºóÓÃÏà¹ØÏµÊý´óµÄÒ»¸ö¡¾Èçx2¡¿¶Ôǰ´ÎÄâºÏµÄ²Ð²îÄâºÏÒ»´Î¡£
ExcelÁ½´ÎÄâºÏ£¬Ò²¿É¸ã¶¨¡£
8Â¥2013-10-14 09:36:58
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
Ïà¹Ø°æ¿éÌø×ª ÎÒÒª¶©ÔÄÂ¥Ö÷ zxhappy µÄÖ÷Ìâ¸üÐÂ
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] Ò»Ö¾Ô¸¹þ¶û±õ¹¤Òµ´óѧ085600Ó¢Ò»Êý¶þ337·ÖÇóµ÷¼Á +12 lyz0427 2026-04-03 12/600 2026-04-06 06:37 by houyaoxu
[¿¼ÑÐ] 085600£¬320·ÖÇóµ÷¼Á +7 ´ó²öС×Ó 2026-04-01 8/400 2026-04-05 21:19 by ѧԱ8dgXkO
[¿¼ÑÐ] 081200-11408-276ѧ˶Çóµ÷¼Á +4 ´Þwj 2026-04-05 4/200 2026-04-05 20:29 by à£à£à£0119
[¿¼ÑÐ] 296Çóµ÷¼Á +3 Íô£¡£¿£¡ 2026-04-05 5/250 2026-04-05 17:38 by À¶ÔÆË¼Óê
[¿¼ÑÐ] Çó +5 »¯¹¤×¨Ë¶323·Ö 2026-04-04 5/250 2026-04-05 08:02 by 544594351
[¿¼ÑÐ] 290Çóµ÷¼Á +7 luoziheng 2026-04-04 7/350 2026-04-04 23:17 by lqwchd
[¿¼ÑÐ] 413Çóµ÷¼Á +4 ¿Âijij 2026-03-31 4/200 2026-04-04 22:18 by ѧԱ6BFVa3
[¿¼ÑÐ] 315Çóµ÷¼Á +13 СÑòСÑò_ 2026-04-02 14/700 2026-04-04 20:30 by À¶ÔÆË¼Óê
[¿¼ÑÐ] 085701Çóµ÷¼Á +7 ¹¨ÓíÃú 2026-04-04 8/400 2026-04-04 13:49 by ССÊ÷2024
[¿¼ÑÐ] ²ÄÁÏ295 +13 СӢ11 2026-04-03 14/700 2026-04-04 09:02 by À´¿´Á÷ÐÇÓê10
[¿¼ÑÐ] Çóµ÷¼Á +3 wos666 2026-04-03 3/150 2026-04-04 05:16 by gswylq
[¿¼ÑÐ] ²ÄÁÏ¿ÆÑ§Ó빤³Ì¿¼ÑÐ +10 Õü¾ÈÆ¤ÌØÍÐÏÈÉú 2026-04-02 10/500 2026-04-03 23:57 by userper
[¿¼ÑÐ] 295Çóµ÷¼Á +3 ÉÐټѽ 2026-04-03 4/200 2026-04-03 21:23 by zhq0425
[¿¼ÑÐ] Ò»Ö¾Ô¸´ó¹¤Ñ§Ë¶£¬Çóµ÷¼Á +4 yub0811 2026-04-02 4/200 2026-04-02 21:36 by °ÙÁéͯ888
[¿¼ÑÐ] ¡¾Çóµ÷¼Á¡¿ÐÂÄÜÔ´²ÄÁϱ¾¿Æ£¬Ò»Ö¾Ô¸211£¬³õÊÔ321 +6 Çóµ÷¼ÁѧУ£¬ 2026-04-02 6/300 2026-04-02 09:41 by Çç¿Õ210210
[¿¼ÑÐ] ²ÄÁϵ÷¼Á +12 Ò»ÑùYWY 2026-04-01 12/600 2026-04-02 00:21 by °ÙÃë¹âÄê
[¿¼ÑÐ] ½­ËտƼ¼´óѧÕвÄÁÏÑо¿Éú +4 Su032713. 2026-04-01 5/250 2026-04-01 22:03 by cccchenso
[¿¼ÑÐ] °²È«¹¤³Ì 285 Çóµ÷¼Á +3 Xinyu56 2026-04-01 4/200 2026-04-01 21:50 by ¾²¾²¾²¾²¾²¾²¾²¾
[¿¼ÑÐ] 307·ÖÇóµ÷¼Á +14 (o~o) 2026-03-31 15/750 2026-04-01 20:43 by longlotian
[¿¼ÑÐ] 08¹¤¿Æ£¬295£¬½ÓÊÜ¿çרҵµ÷¼Á +6 lmnlzy 2026-03-31 6/300 2026-04-01 11:02 by ÄæË®³Ë·ç
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û