Znn3bq.jpeg
ÉÇÍ·´óѧº£Ñó¿ÆÑ§¡¢ÉúÎïѧ¡¢ÉúÎïÓëÒ½Ò©½ÓÊܵ÷¼Á
²é¿´: 2009  |  »Ø¸´: 14
µ±Ç°Ö»ÏÔʾÂú×ãÖ¸¶¨Ìõ¼þµÄ»ØÌû£¬µã»÷ÕâÀï²é¿´±¾»°ÌâµÄËùÓлØÌû

²ý´ó¸¶Ö¾Ç¿

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

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

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

» ²ÂÄãϲ»¶

» ±¾Ö÷ÌâÏà¹Ø¼ÛÖµÌùÍÆ¼ö£¬¶ÔÄúͬÑùÓаïÖú:

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

feixiaolin

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

ÓÅÐã°æÖ÷

ÒýÓûØÌû:
5Â¥: Originally posted by ²ý´ó¸¶Ö¾Ç¿ at 2014-08-16 14:08:50
¸ÕËãÁËÏ£¬Êý¾Ý¾ùÔÚ Çø¼ä£¬ÄÇÖ¤Ã÷ÊDzÙ×÷ÓÐÎÊÌâÂð£¿...

Êý¾Ý²¨¶¯ÂäÔÚ¾ù²»ÔÚ [-3STDEV, +3STDEV]Çø¼ä£¬Ö¤Ã÷ÊDzÙ×÷ºÜºÃ¡£
ʵ¼ÊΪ£º
[ AVERAGE-3*STDEV,  AVERAGE+3*STDEV]Çø¼ä
6Â¥2014-08-16 15:59:22
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢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µÄ»ØÌû
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] ¿¼ÑÐÓ¢Ò»ÊýÒ»338·Ö +6 ³¤½­´óѧ¶«Ð£Çø 2026-04-13 7/350 2026-04-13 09:40 by fqwang
[¿¼ÑÐ] ÉúÎïѧ308Çóµ÷¼Á +5 ÏàÐűػá¹ââÍòÕ 2026-04-11 5/250 2026-04-12 18:14 by zhouxiaoyu
[¿¼ÑÐ] 086000µ÷¼Á +6 Ê®Æßsa 2026-04-07 6/300 2026-04-12 11:05 by ´óÁ¦Ë®ÊÖÁ¦´óÎÞÇ
[¿¼ÑÐ] µ÷¼Á +10 ÔÂ@163.com 2026-04-11 10/500 2026-04-12 09:14 by zhouyuwinner
[¿¼ÑÐ] ²ÄÁϹ¤³ÌÈÕÓÉúÇóµ÷¼Á +7 0856?µ÷¼Á 2026-04-10 7/350 2026-04-11 21:33 by À¶ÔÆË¼Óê
[¿¼ÑÐ] µ÷¼ÁÇóÖú +6 ¹ûÈ»ÓÐÎÒ 2026-04-11 7/350 2026-04-11 16:22 by Ã÷Ô´ËʱÓÐ
[¿¼ÑÐ] 297Çóµ÷¼Á +9 Kwgyz 2026-04-09 9/450 2026-04-11 10:09 by zhq0425
[¿¼ÑÐ] ¹ã¶«Ê¡ 085601 329·ÖÇóµ÷¼Á +14 Eddieddd 2026-04-10 14/700 2026-04-11 09:58 by bljnqdcc
[¿¼ÑÐ] 311Çóµ÷¼Á +13 xypÏë¶ÁÊé 2026-04-10 14/700 2026-04-11 09:41 by Öí»á·É
[¿¼ÑÐ] 342µç×ÓÐÅϢר˶Çóµ÷¼Á +9 ÄãÈÃÎÒÔõôÀóÖ¦ 2026-04-10 10/500 2026-04-11 08:33 by zhq0425
[¿¼ÑÐ] 083200 305·Ö Çó¶þÂÖµ÷¼Á ²»½ÓÊÜ¿çרҵ +9 Claireyyyy 2026-04-09 10/500 2026-04-10 21:21 by Claireyyyy
[¿¼ÑÐ] 289 ·Ö105500ҩѧר˶Çóµ÷¼Á(ÕÒBÇøÑ§Ð£) +6 °×ÔÆ123456789 2026-04-09 8/400 2026-04-10 21:13 by zhouxiaoyu
[¿¼ÑÐ] Çൺ¿Æ¼¼´óѧ²ÄÁÏѧԺ£¬»·¾³Ñ§Ôºµ÷¼Á²¹Â¼4ÔÂ10ÈÕÒÔǰ¶¼¿ÉÒÔ +3 1Çà¿Æ´ó¡£ 2026-04-09 5/250 2026-04-10 09:58 by ôæôæÒ»ÊéÉú
[¿¼ÑÐ] 0703»¯Ñ§Çóµ÷¼Á +21 ²»ÖªÃûµÄСئ 2026-04-08 21/1050 2026-04-09 18:55 by l_paradox
[¿¼ÑÐ] Ò»Ö¾Ô¸Î÷ÄÏ´óѧÉúÎïѧѧ˶344 ÇóÉúÎïѧÏà¹Øµ÷¼Á/ÉúÎïÓëÒ½Ò© +7 ³¬È˲»»á·É@ 2026-04-08 7/350 2026-04-09 09:35 by gong120082
[¿¼ÑÐ] ¶þ´Îµ÷¼ÁÇóÀÏʦÊÕÁô +3 ЦЦԬ 2026-04-08 3/150 2026-04-08 23:50 by ×íÔÚ·çÀï
[¿¼ÑÐ] 331Çóµ÷¼Á +5 luoxin0706. 2026-04-08 5/250 2026-04-08 22:15 by zhouyuwinner
[¿¼ÑÐ] Èí¼þ¹¤³ÌÇóµ÷¼Á22Èí¹¤296·ÖÇóµ÷¼Á£¬½ÓÊÜ¿çµ÷ +4 yangchen2017 2026-04-08 5/250 2026-04-08 21:56 by ÍÁľ˶ʿÕÐÉú
[¿¼ÑÐ] µç×ÓÐÅÏ¢346 +4 zuoshaodian 2026-04-08 4/200 2026-04-08 11:54 by zzucheup
[¿¼ÑÐ] ר˶085403£¬291·Ö£¬ÓÐÁ½Æª×¨Àû£¬Ò»¹úÒ»½± +3 ¹þ¼ªßä¹þ¼ªßä 2026-04-07 3/150 2026-04-07 18:21 by À¶ÔÆË¼Óê
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û