Znn3bq.jpeg
±±¾©Ê¯ÓÍ»¯¹¤Ñ§Ôº2026ÄêÑо¿ÉúÕÐÉú½ÓÊÕµ÷¼Á¹«¸æ
²é¿´: 1676  |  »Ø¸´: 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 µÄÖ÷Ìâ¸üÐÂ
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼²©] ²ÄÁÏ·½Ïò¿¼²©£¬ÇóÍÆ¼ö +3 ÑÔÓïaaa 2026-04-05 4/200 2026-04-08 22:22 by nxgogo
[¿¼ÑÐ] 264Çóµ÷¼Á +11 ÂóС¶£µ± 2026-04-07 11/550 2026-04-08 16:05 by Ò»Ö»ºÃ¹û×Ó?
[¿¼ÑÐ] Ò»Ö¾Ô¸¹þ¹¤´ó£¬³õÊÔ329£¬Çó»·¾³¿ÆÑ§Ó빤³Ìµ÷¼Á£¡ +11 ÓàδÐÁ 2026-04-06 11/550 2026-04-08 15:21 by screening
[¿¼ÑÐ] ²ÄÁϵ÷¼Á +19 Ò»ÑùYWY 2026-04-02 20/1000 2026-04-08 11:02 by ²»³Ôô~µÄ؈
[¿¼ÑÐ] Çóµ÷¼Á +15 ÐܶþÏëÉϰ¶ 2026-04-06 15/750 2026-04-08 04:53 by Î޼ʵIJÝÔ­
[¿¼ÑÐ] 323Çóµ÷¼Á +3 ÁÖzlu 2026-04-07 4/200 2026-04-07 23:21 by lbsjt
[¿¼ÑÐ] 0854µç×ÓÐÅÏ¢319Çóµ÷¼Á£¨½ÓÊÜ¿çרҵµ÷¼Á£© +5 ÐÇÐDz»Õ£ÑÛà¶ 2026-04-05 6/300 2026-04-07 22:16 by hemengdong
[¿¼²©] ²©Ê¿ÉêÇë +3 IQwQl 2026-04-05 3/150 2026-04-07 20:31 by greychen00
[¿¼ÑÐ] 081200-11408-276ѧ˶Çóµ÷¼Á +6 ´Þwj 2026-04-02 6/300 2026-04-07 18:45 by Çóµ÷¼Ázz
[¿¼ÑÐ] 318Çóµ÷¼Á +5 ÀîÇàɽɽɽ 2026-04-07 5/250 2026-04-07 18:24 by À¶ÔÆË¼Óê
[¿¼ÑÐ] 315Çóµ÷¼Á +3 TUZEIQAQ 2026-04-02 3/150 2026-04-07 17:32 by chenp123
[¿¼ÑÐ] ¹¤¿Æ 22408 267ÇóÍÆ¼ö +4 wanwan00 2026-04-05 5/250 2026-04-06 22:47 by chenzhimin
[¿¼ÑÐ] Çóµ÷¼Áµ½²ÄÁÏ +5 ³Ì9915 2026-04-06 5/250 2026-04-06 15:21 by yulian1987
[¿¼ÑÐ] 308Çóµ÷¼Á +3 ÖÕ²»ËÆ´Óǰ 2026-04-05 3/150 2026-04-05 20:07 by à£à£à£0119
[¿¼ÑÐ] 085400µç×ÓÐÅÏ¢319Çóµ÷¼Á£¨½ÓÊÜ¿çרҵµ÷¼Á£© +5 ÐÇÐDz»Õ£ÑÛà¶ 2026-04-03 6/300 2026-04-04 21:50 by hemengdong
[¿¼ÑÐ] 319Çóµ÷¼Á +4 ÐÇÐDz»Õ£ÑÛà¶ 2026-04-03 4/200 2026-04-04 16:25 by ÖзÉÔº¿Õ¹ÜѧԺÑ
[¿¼ÑÐ] Ò»Ö¾Ô¸±±¾©¿Æ¼¼´óѧ²ÄÁϹ¤³Ì085601£¬Çóµ÷¼Á +17 cdyw 2026-04-02 18/900 2026-04-04 11:14 by w_xuqing
[¿¼ÑÐ] ±¾9Ò»Ö¾Ô¸2 0854µÍ·Öר˶286Çóµ÷¼Á +9 âÖÖ111 2026-04-04 9/450 2026-04-04 11:01 by tangruihua
[¿¼ÑÐ] 357Çóµ÷¼Á +13 1050389037 2026-04-03 13/650 2026-04-03 22:27 by Î޼ʵIJÝÔ­
[¿¼ÑÐ] ÊýÒ»Ó¢Ò»285Çóµ÷¼Á +7 AZMK 2026-04-03 9/450 2026-04-03 13:03 by ms629
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û