±±¾©Ê¯ÓÍ»¯¹¤Ñ§Ôº2026ÄêÑо¿ÉúÕÐÉú½ÓÊÕµ÷¼Á¹«¸æ
²é¿´: 1655  |  »Ø¸´: 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 µÄÖ÷Ìâ¸üÐÂ
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] 288×ÊÔ´Óë»·¾³×¨Ë¶Çóµ÷¼Á£¬²»ÏÞרҵ£¬ÓÐѧÉϾÍÐÐ +5 lllllos 2026-03-30 5/250 2026-03-30 15:05 by cq2548
[¿¼ÑÐ] 287Çóµ÷¼Á +11 land xuxu 2026-03-26 11/550 2026-03-30 13:17 by °×ÔÆ¶ä¶ä·É
[¿¼ÑÐ] 22408 359·Öµ÷¼Á +4 Qshers 2026-03-27 6/300 2026-03-29 14:16 by Qshers
[¿¼ÑÐ] Ò»Ö¾Ô¸±±¾©Àí¹¤´óѧ±¾¿Æ211²ÄÁϹ¤³Ì294Çóµ÷¼Á +8 mikasaµÄΧ½í 2026-03-28 8/400 2026-03-29 12:48 by Î޼ʵIJÝÔ­
[¿¼ÑÐ] 343Çóµ÷¼Á +6 °®î¿°í 2026-03-29 6/300 2026-03-29 12:00 by Î޼ʵIJÝÔ­
[¿¼ÑÐ] 085602 »¯¹¤×¨Ë¶ 338·Ö Çóµ÷¼Á +12 ·³ÕСç÷ 2026-03-27 12/600 2026-03-28 15:41 by L135790
[¿¼ÑÐ] 086502»¯Ñ§¹¤³Ì342Çóµ÷¼Á +6 °¢Ò̸´¹Å²»¹ý 2026-03-27 6/300 2026-03-28 07:06 by wangy0907
[Óлú½»Á÷] ¸ßθßѹ·´Ó¦ÇóÖú 10+4 chibby 2026-03-25 4/200 2026-03-27 21:08 by BT20230424
[¿¼ÑÐ] ²ÄÁÏ292µ÷¼Á +12 éÙËÌ˼ÃÀÈË 2026-03-23 12/600 2026-03-27 15:44 by caszguilin
[¿¼ÑÐ] 305Çóµ÷¼Á +5 ÍÛ¬¿¨¿â 2026-03-26 5/250 2026-03-27 14:01 by laoshidan
[˶²©¼ÒÔ°] ±±¾©ÁÖÒµ´óѧ˶µ¼ÕÐÉú¹ã¸æ +6 kongweilin 2026-03-26 8/400 2026-03-27 10:18 by FF_16
[¿¼ÑÐ] Çóµ÷¼Á +6 ÁÖ֮Ϧ 2026-03-24 6/300 2026-03-27 08:38 by hypershenger
[¿¼ÑÐ] 081200-11408-276ѧ˶Çóµ÷¼Á +4 ´Þwj 2026-03-26 4/200 2026-03-27 08:04 by chemisry
[¿¼ÑÐ] Öйú¿ÆÑ§ÔºÉîÛÚÏȽø¼¼ÊõÑо¿Ôº-¹âÏË´«¸Ð¿ÎÌâ×éÕÐÉú-Öйú¿ÆÑ§Ôº´óѧ¡¢ÉîÛÚÀí¹¤´óѧÁªÅà +5 YangTyu1 2026-03-26 5/250 2026-03-26 18:27 by èßäèßäѽ
[¿¼ÑÐ] 290·Öµ÷¼ÁÇóÖú +3 ¼ªÏéÖ¹Ö¹³Â 2026-03-25 3/150 2026-03-25 19:58 by barlinike
[¿¼ÑÐ] ¿¼ÑÐÒ»Ö¾Ô¸ËÕÖÝ´óѧ³õʼ315£¨Ó¢Ò»£©Çóµ÷¼Á +3 sbdksD 2026-03-24 4/200 2026-03-25 18:16 by xcjcqu
[¿¼ÑÐ] 296Çóµ÷¼Á +4 Íô£¡£¿£¡ 2026-03-25 7/350 2026-03-25 16:41 by Íô£¡£¿£¡
[¿¼ÑÐ] 285Çóµ÷¼Á +3 AZMK 2026-03-24 3/150 2026-03-25 12:23 by userper
[¿¼ÑÐ] 292Çóµ÷¼Á +4 ¶ì¶ì¶ì¶î¶î¶î¶î¶ 2026-03-24 4/200 2026-03-24 16:41 by peike
[¿¼ÑÐ] 080500Çóµ÷¼Á +3 zzzzfan 2026-03-24 3/150 2026-03-24 16:38 by barlinike
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û