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

ahtczgf

Òø³æ (СÓÐÃûÆø)

[½»Á÷] ÇóÖúExcelÔÚÒ»¸öͼÖлæÖÆÌõÇúÏß ÒÑÓÐ3È˲ÎÓë

ÎÊÌâÃèÊö£ºÓÐÒÔÏÂÁ½×éÉ¢µãÊý¾Ý£º

¸Ä½øÇ°        x1        297.3        467.48        691.83        749.45        790.34        1330.4
                y1        7.54                7.22               12.26          8.04          5.95          7.41
¸Ä½øºó        x2        493.34        562.49        734.29        1071.8        1244.6        1395.3
                y2        6.81                5.34                  3.91          6.63           10.41         4.82

ÏÖÔÚÏë»æÖÆÁ½ÌõÇúÏßy1=F(x1);       y2=G(x2)
ÔÚMatlabÀïÃæ»æÖÆÈçͼ



ÎÒµÄÎÊÌâÊÇÔõôÓÃExcel2003»æÖÆ£¿
»Ø¸´´ËÂ¥

» ²ÂÄãϲ»¶

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

ÔÚÀäÀäÇåÇåÖзܶ·µÃ·ç·ç»ð»ð
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

bennglove

Í­³æ (СÓÐÃûÆø)

¡ï
Сľ³æ: ½ð±Ò+0.5, ¸ø¸öºì°ü£¬Ð»Ð»»ØÌû
XÖá ·ÅÒ»ÁÐ
YÖá ·ÅÒ»ÁÐ

Ñ¡ÔñÁ½ÁÐÊý¾Ý    ²åÈ롪¡ª¡ª¡ªÕÛÏßͼ/É¢µãͼ
2Â¥2014-03-02 09:21:16
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

ahtczgf

Òø³æ (СÓÐÃûÆø)

ÒýÓûØÌû:
2Â¥: Originally posted by bennglove at 2014-03-02 09:21:16
XÖá ·ÅÒ»ÁÐ
YÖá ·ÅÒ»ÁÐ

Ñ¡ÔñÁ½ÁÐÊý¾Ý    ²åÈ롪¡ª¡ª¡ªÕÛÏßͼ/É¢µãͼ

ÄãÊÔÊÔ°¡£¬ÊÔ¹ýÁË·¢ÕÅͼƬ¸øÎÒ¿´¿´£¬ÎÒËÍÄã15¸ö½ð±Ò
×¢ÒâÁ½¸öXÖáµÄÊý¾Ý²»Ò»Ñù°¡£¬ÎÒÊÔ¹ýºÜ¶à±éÁË£¬Ö»ÄÜÑ¡ÔñÒ»¸öXÖáµÄÊý¾Ý£¬Ñ¡x1¾Í²»ÄÜÑ¡x2
ÔÚÀäÀäÇåÇåÖзܶ·µÃ·ç·ç»ð»ð
3Â¥2014-03-02 10:20:44
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

isweiguo

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

¡ï
Сľ³æ: ½ð±Ò+0.5, ¸ø¸öºì°ü£¬Ð»Ð»»ØÌû
Äã×¢ÖØµÄÊǹØÓÚÕâ¸öµÄÇúÏß»¹ÊÇ×÷ͼÊý¾ÝµÄ±£Áô£¿
±ùÊÇ˯×ŵÄË®
4Â¥2014-03-02 14:46:39
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

ahtczgf

Òø³æ (СÓÐÃûÆø)

ÒýÓûØÌû:
4Â¥: Originally posted by isweiguo at 2014-03-02 14:46:39
Äã×¢ÖØµÄÊǹØÓÚÕâ¸öµÄÇúÏß»¹ÊÇ×÷ͼÊý¾ÝµÄ±£Áô£¿

¾ÍÊÇÁ½ÌõÇúÏß¶ÔÓ¦Á½×éÊý¾Ý£¬ÑϸñµØ£¬ÆäȷʵÓÃExcel2003×ö²»³öMatlabµÄЧ¹û
ÔÚÀäÀäÇåÇåÖзܶ·µÃ·ç·ç»ð»ð
5Â¥2014-03-02 15:48:18
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

isweiguo

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

¡ï
Сľ³æ: ½ð±Ò+0.5, ¸ø¸öºì°ü£¬Ð»Ð»»ØÌû
ÒýÓûØÌû:
5Â¥: Originally posted by ahtczgf at 2014-03-02 15:48:18
¾ÍÊÇÁ½ÌõÇúÏß¶ÔÓ¦Á½×éÊý¾Ý£¬ÑϸñµØ£¬ÆäȷʵÓÃExcel2003×ö²»³öMatlabµÄЧ¹û...

¶÷¶÷£¬ÎÒ×ö²»³öÀ´£¬»¹ÒÔΪÄãÐèÒªÇúÏßµÄÇ÷ÊÆ¡£
±ùÊÇ˯×ŵÄË®
6Â¥2014-03-02 16:09:05
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

bennglove

Í­³æ (СÓÐÃûÆø)

¡ï
Сľ³æ: ½ð±Ò+0.5, ¸ø¸öºì°ü£¬Ð»Ð»»ØÌû
ÄÇÎҾͲ»¿ÍÆøÁ˰¡£¡£¡

»¨¸ö1·ÖÖÓ×öÒ»ÏÂ

Òª²»ÊÇÄãµÄÊý¾ÝÒªÊÖÊ䣬ÎÒÉϴξÍ×öÁË


http://v1.freep.cn/3tb_14030309415296mc512293.jpg

×Ô¼º¿´°É


˳±ã˵һ¾ä£¬ÎÒÃÇÒ»°ãÔÚ  originÀï»­ÕâÖÖͼ£¬²»Ð»

[ Last edited by bennglove on 2014-3-3 at 09:45 ]
7Â¥2014-03-03 09:44:23
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

Ðļ³ÓêÆü

½ð³æ (ÕýʽдÊÖ)

¡ï
Сľ³æ: ½ð±Ò+0.5, ¸ø¸öºì°ü£¬Ð»Ð»»ØÌû
ÔÚ×ÊÔ´°å¿éËÑË÷¡°ÈçºÎ»æÖÆË«ÖáÇúÏß¡±µÄÌû×Ó£¬ÀïÃæÓÐÏêϸ½²½â£¬ÓÐͼƬºÍÎÄ×Ö˵Ã÷£¬Ò»¿´¾Í»á×öÁË¡£
8Â¥2014-05-01 13:42:00
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
Ïà¹Ø°æ¿éÌø×ª ÎÒÒª¶©ÔÄÂ¥Ö÷ ahtczgf µÄÖ÷Ìâ¸üÐÂ
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] Ò»Ö¾Ô¸±±¾©»¯¹¤085600 310·ÖÇóµ÷¼Á +16 0856²ÄÁÏÓ뻯¹¤3 2026-04-04 18/900 2026-04-06 01:54 by BruceLiu320
[¿¼ÑÐ] ²ÄÁÏÇóµ÷¼Á +11 Ò»ÑùYWY 2026-04-05 11/550 2026-04-05 23:36 by À´¿´Á÷ÐÇÓê10
[¿¼ÑÐ] Çóµ÷¼Á +11 ÐܶþÏëÉϰ¶ 2026-04-04 11/550 2026-04-05 22:21 by ×íÎÌwl
[¿¼ÑÐ] ¹¤¿Æ08-»úеר˶-Çóµ÷¼Á +3 À×Å··ÉÌß 2026-04-02 3/150 2026-04-05 18:49 by À¶ÔÆË¼Óê
[¿¼ÑÐ] 11408,335·Ö£¬±¾¿Æ211£¬Çóµ÷¼Á£¬¿Éתרҵ +5 öùÀæ´óöùÓã 2026-04-03 5/250 2026-04-04 22:49 by chongya
[¿¼ÑÐ] Ò»Ö¾Ô¸»ª±±µçÁ¦´óѧ£¨±±¾©£©£¬²ÄÁÏ¿ÆÑ§Ó빤³Ìѧ˶265£¬Çóµ÷¼Á +11 yelck 2026-04-03 12/600 2026-04-04 19:52 by dongzh2009
[¿¼ÑÐ] 265Çóµ÷¼Á +17 ÁÖÉîÎÂÀ½ 2026-04-01 20/1000 2026-04-04 01:09 by userper
[¿¼ÑÐ] 320µ÷¼Á +4 ũҵ¹¤³ÌÓëÐÅÏ¢¼ 2026-04-03 4/200 2026-04-03 21:40 by lbsjt
[¿¼ÑÐ] Ò»Ö¾Ô¸Äϲý´óѧ324Çóµ÷¼Á +13 hanamiko 2026-04-01 13/650 2026-04-03 18:30 by lsÁõ˧
[¿¼ÑÐ] Çóµ÷¼Á +4 15064154688 2026-04-03 5/250 2026-04-03 15:07 by zrongyan
[¿¼ÑÐ] ÊýÒ»Ó¢Ò»285Çóµ÷¼Á +7 AZMK 2026-04-03 9/450 2026-04-03 13:03 by ms629
[¿¼ÑÐ] 313Çóµ÷¼Á +3 ¡«Î¢Î¢Á¹¡« 2026-04-03 3/150 2026-04-03 11:25 by à£à£à£0119
[¿¼ÑÐ] Ò»Ö¾Ô¸°²»Õ´óѧ0817»¯Ñ§¹¤³ÌÓë¼¼Êõ£¬Çóµ÷¼Á +14 ÎÒ²»ÊÇÖ»Òò 2026-04-02 15/750 2026-04-03 09:49 by À¶ÔÆË¼Óê
[¿¼ÑÐ] »·¾³¹¤³Ì297·ÖÇóµ÷¼ÁÒ»Ö¾Ô¸º¼¸ßÔº +15 GENJIOW 2026-03-31 16/800 2026-04-02 17:56 by cyh¡ª315
[¿¼ÑÐ] 346Çóµ÷¼Á +5 Ö£³ÏÀÖ 2026-04-02 5/250 2026-04-02 16:38 by SZW_UJN
[¿¼ÑÐ] Çóµ÷¼ÁÍÆ¼ö +3 ÄÏɽÄÏ@ 2026-04-01 3/150 2026-04-02 12:09 by xiaoranmu
[¿¼ÑÐ] 272Çóµ÷¼Á£¬½ÓÊÜ¿çרҵµ÷¼Á£¡ +4 ÏÐÓ㬠2026-03-31 4/200 2026-04-02 11:18 by guyan1000
[¿¼ÑÐ] Ò»Ö¾Ô¸ÏÃÃÅ´óѧ»¯Ñ§¹¤³Ì£¨×¨Ë¶£©-Êý¶þÓ¢¶þ406·Ö-Çóµ÷¼Á +5 Ïô󻯹¤ 2026-04-01 5/250 2026-04-02 10:03 by jp9609
[¿¼ÑÐ] Çóµ÷¼Á ÉúÎïѧ 377·Ö +6 zzll03 2026-03-31 6/300 2026-03-31 17:33 by ÌÆãå¶ù
[¿¼ÑÐ] 269Çóµ÷¼Á +4 ÎÒÏë¶ÁÑÐ11 2026-03-31 4/200 2026-03-31 10:04 by cal0306
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û