Znn3bq.jpeg
ÉÇÍ·´óѧº£Ñó¿ÆÑ§½ÓÊܵ÷¼Á
²é¿´: 2013  |  »Ø¸´: 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]Çø¼ä
ÐèÒª¼ÆËã¾ùÖµ
12Â¥2014-08-17 17:10:08
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢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µÄ»ØÌû
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] 279Çóµ÷¼Á +11 ÕÅ·¬ÇѲ»³´µ° 2026-04-11 11/550 2026-04-13 22:25 by zhq0425
[¿¼ÑÐ] Ò»Ö¾Ô¸¹þ¹¤´ó 085600 277 12²Ä¿Æ»ùÇóµ÷¼Á 5+5 chenny174 2026-04-10 36/1800 2026-04-13 22:17 by zhq0425
[¿¼ÑÐ] 339Çóµ÷¼Á +4 hanwudada 2026-04-12 4/200 2026-04-13 12:03 by À¶ÔÆË¼Óê
[¿¼ÑÐ] 085408¹âµçÐÅÏ¢¹¤³Ìר˶355Ò»Ö¾Ô¸³¤´º¹â»úËùµ÷¼Á +3 Íõymaa 2026-04-13 3/150 2026-04-13 11:01 by zhshch
[¿¼ÑÐ] ÉúÎïѧ308Çóµ÷¼Á +5 ÏàÐűػá¹ââÍòÕ 2026-04-11 5/250 2026-04-12 18:14 by zhouxiaoyu
[¿¼ÑÐ] 326Çóµ÷¼Á +6 Shansyn 2026-04-10 6/300 2026-04-12 09:46 by hammer3
[¿¼ÑÐ] Ò»Ö¾Ô¸Î÷±±¹¤Òµ´óѧ289 085602 +33 yangæÃ 2026-04-10 34/1700 2026-04-12 08:11 by Art1977
[¿¼ÑÐ] 298Çóµ÷¼Á +5 ²ÐºÉÐÂÁø 2026-04-07 5/250 2026-04-11 11:02 by ×ÏêØ×ÏÆå
[¿¼ÑÐ] 346£¬¹¤¿ÆÇóµ÷¼Á +3 moser233 2026-04-09 3/150 2026-04-11 10:04 by zhq0425
[¿¼ÑÐ] 337Çóµ÷¼Á +4 ÑÐs. 2026-04-10 4/200 2026-04-11 08:57 by zhq0425
[¿¼ÑÐ] 302·ÖÇóµ÷¼Á +9 ·²ÓïÆíÔ¸ 2026-04-08 10/500 2026-04-10 23:26 by 314126402
[¿¼ÑÐ] 309Çóµ÷¼Á +14 wdhw 2026-04-10 15/750 2026-04-10 21:06 by zhouxiaoyu
[¿¼ÑÐ] ²ÄÁÏרҵ344Çóµ÷¼Á +16 hualkop 2026-04-10 21/1050 2026-04-10 17:28 by laoshidan
[¿¼ÑÐ] 298Çóµ÷¼Á +13 ¶¤¶£ß˶¬¹Ï 2026-04-09 13/650 2026-04-10 15:49 by jiajinhpu
[¿¼ÑÐ] Ò»Ö¾Ô¸»¦9£¬326ÉúÎïѧÇóÏà¹Ø×¨Òµµ÷¼Á +4 Áõīī 2026-04-09 4/200 2026-04-10 12:07 by pengliang8036
[¿¼ÑÐ] 344Çóµ÷¼Á +7 ؼ·çѩҹ¹éÈËØ¼ 2026-04-09 7/350 2026-04-10 12:05 by pengliang8036
[¿¼ÑÐ] 314Çóµ÷¼Á +14 weltZeng 2026-04-09 14/700 2026-04-09 23:14 by wolf97
[¿¼ÑÐ] ¿¼Ñе÷¼Á +13 ±ù±ù£¬£¬£¬ 2026-04-07 13/650 2026-04-09 17:01 by Lilly_Li
[¿¼ÑÐ] 283µç×ÓÐÅÏ¢Çóµ÷¼Á +4 ÈýʯWL 2026-04-08 4/200 2026-04-09 10:21 by wp06
[¿¼ÑÐ] ²ÄÁϹ¤³ÌרҵÈÕÓïÉúÇóµ÷¼Á +9 111623 2026-04-07 9/450 2026-04-07 23:31 by Ò»Ö»ºÃ¹û×Ó?
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û