²é¿´: 1969  |  »Ø¸´: 14
µ±Ç°Ö»ÏÔʾÂú×ãÖ¸¶¨Ìõ¼þµÄ»ØÌû£¬µã»÷ÕâÀï²é¿´±¾»°ÌâµÄËùÓлØÌû

²ý´ó¸¶Ö¾Ç¿

Ìú³æ (³õÈëÎÄ̳)

[ÇóÖú] ÔõÑùͨ¹ýÊý¾Ý¿´ÊµÑé²Ù×÷µÄ׼ȷ¶È

ͨ¹ýʵÑé²Ù×÷µÃµ½Ò»×éÊý¾Ý£º
0.0020
0.0018
0.0013
0.0021
0.0013
¸ÃÔõÑùͨ¹ýÕâ×éÊý¾Ý¿´²Ù×÷µÄ׼ȷ¶È£¿
¾¡Á¿Ïêϸµã£¬Ð»Ð»£¡
»Ø¸´´ËÂ¥

» ²ÂÄãϲ»¶

ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

²ý´ó¸¶Ö¾Ç¿

Ìú³æ (³õÈëÎÄ̳)

ÒýÓûØÌû:
10Â¥: Originally posted by ¶Àľ³æ at 2014-08-17 16:42:07
µÚ¶þ¸ö¹«Ê½ÎªÊ²Ã´°Ñƽ¾ùÖµ¼ÓÉÏ£¿²»½â
...

Êý¾Ý²¨¶¯ÂäÔÚ¾ù²»ÔÚ [-3STDEV, +3STDEV]Çø¼ä£¬Ö¤Ã÷ÊDzÙ×÷ºÜºÃ¡£
ʵ¼ÊΪ£º
[ AVERAGE-3*STDEV,  AVERAGE+3*STDEV]Çø¼ä
ÐèÒª¼ÆËã¾ùÖµ
11Â¥2014-08-17 17:07:01
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
²é¿´È«²¿ 15 ¸ö»Ø´ð

feixiaolin

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

ÓÅÐã°æÖ÷

±ê׼ƫ²îԽС£¬¾«×¼¶ÈÔ½¸ß¡£
Excel    Êý×Ö×°ÈëC1:C5
=AVERAGE(C1:C5)
=STDEV(C1:C5, AVERAGE(C1:C5))
--------------------------------
¾ùÖµ0.0017£¬ ±ê׼ƫ²î0.000341
2Â¥2014-08-15 17:24:07
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

²ý´ó¸¶Ö¾Ç¿

Ìú³æ (³õÈëÎÄ̳)

ÒýÓûØÌû:
2Â¥: Originally posted by feixiaolin at 2014-08-15 17:24:07
±ê׼ƫ²îԽС£¬¾«×¼¶ÈÔ½¸ß¡£
Excel    Êý×Ö×°ÈëC1:C5
=AVERAGE(C1:C5)
=STDEV(C1:C5, AVERAGE(C1:C5))
--------------------------------
¾ùÖµ0.0017£¬ ±ê׼ƫ²î0.000341

¾ùÖµºÍ±ê׼ƫ²î¿ØÖÆÔÚʲô·¶Î§ÄÚ¿ÉÒÔÈÏΪ¸Ã²Ù×÷¿ÉÐУ¿Ð»Ð»£¡
3Â¥2014-08-16 10:13:19
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

feixiaolin

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

ÓÅÐã°æÖ÷

ÒýÓûØÌû:
3Â¥: Originally posted by ²ý´ó¸¶Ö¾Ç¿ at 2014-08-16 10:13:19
¾ùÖµºÍ±ê׼ƫ²î¿ØÖÆÔÚʲô·¶Î§ÄÚ¿ÉÒÔÈÏΪ¸Ã²Ù×÷¿ÉÐУ¿Ð»Ð»£¡...

±ê׼ƫ²î/¾ùÖµ ԽСԽºÃ¡£
²âÁ¿Êý¾ÝÂäÔÚ [-3STDEV, +3STDEV] ¸ÅÂÊÔ½´óÔ½ºÃ¡£
4Â¥2014-08-16 10:44:22
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] 319Çóµ÷¼Á +4 СÁ¦Æøçæçæ 2026-03-20 4/200 2026-03-22 15:53 by ColorlessPI
[¿¼ÑÐ] ÉúÎïѧµ÷¼Á +5 Surekei 2026-03-21 5/250 2026-03-22 14:39 by tcx007
[¿¼ÑÐ] 291 Çóµ÷¼Á +3 »¯¹¤2026½ì±ÏÒµÉ 2026-03-21 3/150 2026-03-22 14:26 by ColorlessPI
[¿¼ÑÐ] Çóµ÷¼Á +5 Zhangbod 2026-03-21 7/350 2026-03-22 13:13 by Zhangbod
[¿¼ÑÐ] ÕÐ08¿¼Êýѧ +3 laoshidan 2026-03-20 7/350 2026-03-22 12:54 by ÔÚ·çÂäÖÐ
[¿¼ÑÐ] Çóµ÷¼Á +7 Auroracx 2026-03-22 7/350 2026-03-22 12:38 by ËØÑÕÇã³Ç1988
[¿¼ÑÐ] 286·ÖÈ˹¤ÖÇÄÜרҵÇëÇóµ÷¼ÁÔ¸Òâ¿ç¿¼£¡ +4 lemonzzn 2026-03-17 8/400 2026-03-21 22:49 by lemonzzn
[¿¼ÑÐ] Ò»Ö¾Ô¸Î÷°²½»Í¨´óѧ²ÄÁϹ¤³Ìרҵ 282·ÖÇóµ÷¼Á +10 ·ãÇÅZL 2026-03-18 12/600 2026-03-21 22:02 by peike
[¿¼ÑÐ] Ò»Ö¾Ô¸Éî´ó£¬0703»¯Ñ§£¬×Ü·Ö302£¬Çóµ÷¼Á +4 ÆßÔÂ-ÆßÆß 2026-03-21 4/200 2026-03-21 18:20 by ѧԱ8dgXkO
[¿¼ÑÐ] 307Çóµ÷¼Á +3 ÓàÒâÇä 2026-03-18 3/150 2026-03-21 17:31 by ColorlessPI
[¿¼ÑÐ] 306Çóµ÷¼Á +4 chuanzhu´¨Öò 2026-03-18 4/200 2026-03-21 08:25 by laoshidan
[¿¼ÑÐ] »¯Ñ§Çóµ÷¼Á +4 ÁÙÔó¾³llllll 2026-03-17 5/250 2026-03-21 02:23 by JourneyLucky
[¿¼ÑÐ] Ò»Ö¾Ô¸»ªÖпƼ¼´óѧ£¬080502£¬354·ÖÇóµ÷¼Á +5 ÊØºòϦÑôCF 2026-03-18 5/250 2026-03-21 01:06 by JourneyLucky
[¿¼ÑÐ] 296Çóµ÷¼Á +6 www_q 2026-03-18 10/500 2026-03-20 23:56 by JourneyLucky
[¿¼ÑÐ] ¹ãÎ÷´óѧ¼ÒÇÝÒÅ´«ÓýÖÖ¿ÎÌâ×é2026Äê˶ʿÕÐÉú£¨½ÓÊÕ¼ÆËã»úרҵµ÷¼Á£© +3 123°¢±ê 2026-03-17 3/150 2026-03-20 15:58 by ·ÉÐÐçù
[¿¼ÑÐ] ²ÄÁÏѧ˶318Çóµ÷¼Á +5 February_Feb 2026-03-19 5/250 2026-03-19 23:51 by 23Postgrad
[¿¼ÑÐ] 085600²ÄÁÏÓ뻯¹¤µ÷¼Á 324·Ö +10 llllkkkhh 2026-03-18 12/600 2026-03-19 14:33 by llllkkkhh
[¿¼ÑÐ] 085600²ÄÁÏÓ뻯¹¤Çóµ÷¼Á +6 Ð÷ÐÒÓë×Ó 2026-03-17 6/300 2026-03-19 13:27 by houyaoxu
[ÂÛÎÄͶ¸å] ÓÐûÓдóÀз¢Ð¡ÂÛÎÄÄÜ´øÎÒ¸ö¶þ×÷ +3 ÔöÈñ©ÈË 2026-03-17 4/200 2026-03-17 09:26 by xs74101122
[¿¼ÑÐ] 11408 Ò»Ö¾Ô¸Î÷µç£¬277·ÖÇóµ÷¼Á +3 zhouzhen654 2026-03-16 3/150 2026-03-17 07:03 by laoshidan
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û