²é¿´: 1147  |  »Ø¸´: 4
±¾Ìû²úÉú 1 ¸ö ·­ÒëEPI £¬µã»÷ÕâÀï½øÐв鿴
µ±Ç°Ö»ÏÔʾÂú×ãÖ¸¶¨Ìõ¼þµÄ»ØÌû£¬µã»÷ÕâÀï²é¿´±¾»°ÌâµÄËùÓлØÌû

pengxp163

½ð³æ (СÓÐÃûÆø)

´óÁú

[ÇóÖú] ¶ÌÎÄ·­ÒëÇóÖú£¬Ð»Ð»£¡

ÔÚEXCELÈí¼þÖУ¬ÄâºÏ·ÇÏßÐÔʵÑéÊý¾ÝÓÐËÄÖÖ·½·¨¡£ÆäÖй滮Çó½â·½·¨ÓëËæ»ú³éÑù·½·¨Æä×î´óµÄÓŵãÊDz»Òª±ä»»·½³Ì£¬ÇÒÊʺÏÈκÎʵÑéÊý¾Ý·ÇÏßÐÔÄâºÏ¡£¹æ»®Çó½â·½·¨×îΪ¼ò±ã£¬µ«¾«¶ÈÏà¶ÔÒª²î£¬½á¹ûÓÐʱÄÑÒÔ°ÑÎÕ¡£ºóÕß¼ÓÈëÁËVBA»ìºÏ±à³Ì£¬´ïµ½É¸Ñ¡ÓëÓÅ»¯Ä¿µÄ£¬Ìá¸ßÁËÄâºÏ¾«¶È¡£ÁíÁ½ÖÖΪº¯Êý¹«Ê½·½·¨ºÍ»Ø¹é·ÖÎö·½·¨£¬Ç°Õ߸ù¾Ý×îС¶þ³Ë·¨Ô­Àí½ö½öÔÚµç×Ó±í¸ñÖÐÊäÈ뺯Êý¹«Ê½µÃµ½¾«¶È¼«¸ßµÄÄâºÏ½á¹û¡£ºóÕßÀûÓÃÁËEXCEL×Ô´øµÄÊýѧ·ÖÎö¹¤¾ßÍê³ÉÄâºÏ£¬¾«¶È×î¸ß¡£µ«ËüÃÇÔÚÓ¦ÓÃ֮ǰ£¬ÐèÒª¶ÔʵÑéÊý¾Ý½øÐжàÔª¶àÏîʽ·½³Ì±ä»»£¬¶ÔÄÑÓڱ任µÄ·ÇÏßÐÔʵÑéÊý¾Ý²»Êʺϡ£´¦Àí¹¤³ÌʵÑéÊý¾Ý£¬ÕÆÎÕÕâËÄÖÖ·ÇÏßÐÔʵÑéÊý¾ÝµÄÄâºÏ·½·¨ºÜÓбØÒª¡£
¿ìÀÖÉú»î£¡¿ìÀÖ¹¤×÷£¡£¡¿ìÀÖÑо¿£¡£¡£¡
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

RXMCDM

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

ÓÅÐã°æÖ÷ÓÅÐã°æÖ÷ÓÅÐã°æÖ÷

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

ÒýÓûØÌû:
4Â¥: Originally posted by RXMCDM at 2014-05-02 11:36:00
The Mcrosoft EXCEL softwares provided four methods with  nonlinear  experimental data fitting . The advantages of the first importance of  programming calculation & random sampling method  are no ...

The Mcrosoft EXCEL softwares ¸ÄΪThe Mcrosoft EXCEL
£¿
5Â¥2014-05-02 12:21:24
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
²é¿´È«²¿ 5 ¸ö»Ø´ð

reko34

ľ³æ (ÕýʽдÊÖ)

¡ï
phu_grassman: ½ð±Ò+1, Thanks. 2014-05-02 10:44:54
4ÖÖ·½·¨µÄÓ¢ÎÄÃû¶¼Ã»Ìý¹ý£¬LZ±ÈÆäËûÈ˸üÇå³þ£¬Ó¦¸ÃÏȸø³öÀ´ÃâµÃ×öÎÞÓù¦¡£

ÁíÍâͲÛһϣ¬×îС¶þ³Ë·¨ÊÇ×î³£¼ûµÄ»Ø¹é±ê×¼£¬ÈÃÎÒ»³Òɺ¯Êý¹«Ê½·¨ÊÇʲô¶«Î÷£¬»Ø¹é±¾À´¾ÍÊÇ»ùÓÚ¹«Ê½µÄÄâºÏ¡£»¹ÓжàÏîʽ·½³ÌËãÏßÐÔÄâºÏ£¬·ÇÏßÐÔÊÇÖ¸Êý¡¢Èý½Çº¯ÊýÖ®ÀàµÄ¡£
2Â¥2014-05-01 00:28:47
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

pengxp163

½ð³æ (СÓÐÃûÆø)

´óÁú

ÒýÓûØÌû:
2Â¥: Originally posted by reko34 at 2014-05-01 00:28:47
4ÖÖ·½·¨µÄÓ¢ÎÄÃû¶¼Ã»Ìý¹ý£¬LZ±ÈÆäËûÈ˸üÇå³þ£¬Ó¦¸ÃÏȸø³öÀ´ÃâµÃ×öÎÞÓù¦¡£

ÁíÍâͲÛһϣ¬×îС¶þ³Ë·¨ÊÇ×î³£¼ûµÄ»Ø¹é±ê×¼£¬ÈÃÎÒ»³Òɺ¯Êý¹«Ê½·¨ÊÇʲô¶«Î÷£¬»Ø¹é±¾À´¾ÍÊÇ»ùÓÚ¹«Ê½µÄÄâºÏ¡£»¹ÓжàÏîʽ·½³ÌËãÏßÐÔÄâºÏ ...

ÕâËÄÖÖ·½·¨Êµ¼ÊÉ϶¼ÊÇ»ùÓÚ×îС¶þ³Ë»Ø¹é±ê×¼µÄ·½·¨£¬EXCELÈí¼þÖÐÖ»Óлعé·ÖÎö·¨ÊÇÏֳɵ쬵«¶ÔºÜ¶à·ÇÏßÐÔÊý¾Ý²»Êʺϣ¬¿ÉÒÔÓÃÁíÍâÈý·¨¡£ÁíÍâÈý·¨ÊǸù¾ÝÆäÔ­ÀíÉè¼ÆµÄ£¬½ÏΪÓÐÓ㬾«¶ÈÉԵͣ¬µ«½â¾öÁËÎÊÌâ¡£
¿ìÀÖÉú»î£¡¿ìÀÖ¹¤×÷£¡£¡¿ìÀÖÑо¿£¡£¡£¡
3Â¥2014-05-01 14:07:29
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

RXMCDM

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

ÓÅÐã°æÖ÷ÓÅÐã°æÖ÷ÓÅÐã°æÖ÷

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

¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï
pengxp163: ½ð±Ò+50, ·­ÒëEPI+1, ¡ï¡ï¡ïºÜÓаïÖú, °æÖ÷ÕæµÄºÜÔÞ£¡ÎþÉü¼ÙÆÚΪ³æÓÑÖúÁ¦£¬Ê®Íò·Ö¸Ð¼¤£¡ 2014-05-02 15:53:46
The Mcrosoft EXCEL softwares provided four methods with  nonlinear  experimental data fitting . The advantages of the first importance of  programming calculation & random sampling method  are no need   to transform the equation  and suitable for  non-linear fitting of  any  data. The programming calculation method is simple  and its  accuracy is  poor,relatively and  sometimes the results are  difficult to make sure of . The latter are combined with  the VBA mixed programming to achieve the purpose of screening and optimization and  improved the fitting precision. The next  two methods are excel function formula and regression analysis method . The former can  get fitting result of high precision by  function formula inputting based on the principle of least squares . The latter is  with  the highest fitting accuracy by the use of EXCEL mathematical analysis tools . Hower , before the application of both of these methods,  multivariate polynomial equation transformation of data is required .It is natural that both of these methods are  not suitable for nonlinear experimental data which is difficult to transform and it is necessary to grasp these   four non-linear fitting method to process experimental data of projects.
£¿
4Â¥2014-05-02 11:36:00
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] 311Çóµ÷¼Á +11 ¶¬Ê®Èý 2026-03-15 12/600 2026-03-18 14:36 by ÐÇ¿ÕÐÇÔÂ
[¿¼ÑÐ] 280Çóµ÷¼Á +6 ¹¾ààÏþÏþ 2026-03-18 7/350 2026-03-18 11:25 by Î޼ʵIJÝÔ­
[»ù½ðÉêÇë] ±»ÎÒÑÔÖУºÐÂÄ£°å²»Ç¿µ÷¸ñʽÁË£¬¼Ùר¼Ò¿ªÊ¼¹Ü¸ñʽÁË +4 beefly 2026-03-14 4/200 2026-03-17 22:04 by »ÆÄñÓÚ·ÉChao
[¿¼ÑÐ] 085601Çóµ÷¼Á +4 Du.11 2026-03-16 4/200 2026-03-17 17:08 by ruiyingmiao
[¿¼ÑÐ] 290Çóµ÷¼Á +6 ¿×Ö¾ºÆ 2026-03-12 11/550 2026-03-17 14:41 by ÖÜÖÛÖÛ77
[¿¼ÑÐ] 302Çóµ÷¼Á +4 С¼Öͬѧ123 2026-03-15 8/400 2026-03-17 10:33 by С¼Öͬѧ123
[¿¼ÑÐ] 326Çóµ÷¼Á +4 ŵ±´¶û»¯Ñ§½±êéê 2026-03-15 7/350 2026-03-16 17:11 by ŵ±´¶û»¯Ñ§½±êéê
[¿¼ÑÐ] 070303Ò»Ö¾Ô¸Î÷±±´óѧѧ˶310ÕÒµ÷¼Á +5 dÈçÔ¸Éϰ¶ 2026-03-12 8/400 2026-03-16 15:19 by peike
[¿¼ÑÐ] 285Çóµ÷¼Á +6 ytter 2026-03-12 6/300 2026-03-16 15:05 by njzyff
[¿¼ÑÐ] 070303 ×Ü·Ö349Çóµ÷¼Á +3 LJY9966 2026-03-15 5/250 2026-03-16 14:24 by xwxstudy
[¿¼ÑÐ] 0703 ÎïÀí»¯Ñ§µ÷¼Á +3 ÎÒ¿ÉÒÔÉϰ¶µÄ¶Ô 2026-03-13 5/250 2026-03-16 10:50 by ÎÒ¿ÉÒÔÉϰ¶µÄ¶ÔÂ
[¿¼ÑÐ] 327Çóµ÷¼Á +6 ʰ¹âÈÎȾ 2026-03-15 11/550 2026-03-15 22:47 by ʰ¹âÈÎȾ
[¿¼ÑÐ] 26¿¼ÑÐÒ»Ö¾Ô¸ÖйúʯÓÍ´óѧ(»ª¶«)305·ÖÇóµ÷¼Á +3 ¼ÎÄêÐÂ³Ì 2026-03-15 3/150 2026-03-15 13:58 by ¹þ¹þ¹þ¹þºÙºÙºÙ
[»ù½ðÉêÇë] ÏÖÔÚÈçºÎ»Ø±ÜÈ¥ÄêµÄijһ¸öר¼Ò£¬²»ÖªµÀÃû×Ö +3 zk200107 2026-03-12 6/300 2026-03-14 17:13 by zk200107
[¿¼ÑÐ] 308 085701 ËÄÁù¼¶ÒѹýÇóµ÷¼Á +7 ÎÂÇÇÇÇÇÇÇÇ 2026-03-12 14/700 2026-03-14 10:49 by JourneyLucky
[¿¼ÑÐ] ²ÄÁÏÓ뻯¹¤£¨0856£©304ÇóBÇøµ÷¼Á +6 Çñgl 2026-03-12 7/350 2026-03-13 23:24 by Çñgl
[¿¼ÑÐ] ²ÄÁϹ¤³Ìµ÷¼Á +9 ßäßä¿Õ¿Õ 2026-03-12 9/450 2026-03-13 22:05 by ÐÇ¿ÕÐÇÔÂ
[¿¼ÑÐ] 0856²ÄÁÏÓ뻯¹¤301Çóµ÷¼Á +5 ÞÈÊø¹â 2026-03-13 5/250 2026-03-13 22:00 by ÐÇ¿ÕÐÇÔÂ
[ÂÛÎÄͶ¸å] Ͷ¸åÎÊÌâ 5+4 Ðǹâ²ÓÀÃxt 2026-03-12 6/300 2026-03-13 14:17 by god_tian
[¿¼²©] 26¶Á²© +4 Rui135246 2026-03-12 10/500 2026-03-13 07:15 by gaobiao
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û