±±¾©Ê¯ÓÍ»¯¹¤Ñ§Ôº2026ÄêÑо¿ÉúÕÐÉú½ÓÊÕµ÷¼Á¹«¸æ
²é¿´: 3124  |  »Ø¸´: 5

lm334723460

Òø³æ (СÓÐÃûÆø)

[½»Á÷] excelÓй«Ê½ÄÜ´ò³ö¾ùÖµ¡À±ê×¼²îÂð ÒÑÓÐ2È˲ÎÓë

Çó½ÌÔõô´ò³ö¾ùÖµ¡À±ê×¼²î£¬Ò»¸öÒ»¸öÊäÈëÌ«ÂýÁË
»Ø¸´´ËÂ¥

» ²ÂÄãϲ»¶

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

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

feixiaolin

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

ÓÅÐã°æÖ÷

¡ï
Сľ³æ: ½ð±Ò+0.5, ¸ø¸öºì°ü£¬Ð»Ð»»ØÌû
Á½º¯Êý
AVERAGE¡¾¾ùÖµ¡¿£¬   STDEVA¡¾±ê×¼²î¡¿
2Â¥2014-03-08 11:51:33
ÒÑÔÄ   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

lm334723460

Òø³æ (СÓÐÃûÆø)

ÒýÓûØÌû:
2Â¥: Originally posted by feixiaolin at 2014-03-08 11:51:33
Á½º¯Êý
AVERAGE¡¾¾ùÖµ¡¿£¬   STDEVA¡¾±ê×¼²î¡¿

ÎÒµÄÒâ˼ÊÇÔÚÒ»¸öµ¥Ôª¸ñÀïÊäÈë¡°¾ùÖµ¡À±ê×¼²î¡±£¬È»ºóÏÂÀ­£¬ÆäËûµ¥Ôª¸ñÒ²»á°´ÕâÖÖ¸ñʽÏÔʾÊý¾Ý
3Â¥2014-03-08 14:55:46
ÒÑÔÄ   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

feixiaolin

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

ÓÅÐã°æÖ÷

¡ï
Сľ³æ: ½ð±Ò+0.5, ¸ø¸öºì°ü£¬Ð»Ð»»ØÌû
ÒýÓûØÌû:
3Â¥: Originally posted by lm334723460 at 2014-03-08 14:55:46
ÎÒµÄÒâ˼ÊÇÔÚÒ»¸öµ¥Ôª¸ñÀïÊäÈë¡°¾ùÖµ¡À±ê×¼²î¡±£¬È»ºóÏÂÀ­£¬ÆäËûµ¥Ôª¸ñÒ²»á°´ÕâÖÖ¸ñʽÏÔʾÊý¾Ý...

=AVERAGE(A1:A6)+STDEVA(A1:A6)¿ÉʵÏÖ¡¾½á¹ûÊÇÒ»¸öÊý¡¿
=AVERAGE(A1:A6)-STDEVA(A1:A6)Ò²¿ÉʵÏÖ
4Â¥2014-03-08 16:03:00
ÒÑÔÄ   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

yumoym

ÖÁ×ðľ³æ (ÎÄ̳¾«Ó¢)

¡ï
Сľ³æ: ½ð±Ò+0.5, ¸ø¸öºì°ü£¬Ð»Ð»»ØÌû
ÄѵÀÊÇÒªÊäÈëÎÄ×Ö£¿
5Â¥2014-03-23 10:36:03
ÒÑÔÄ   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

feixiaolin

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

ÓÅÐã°æÖ÷

¡ï
Сľ³æ: ½ð±Ò+0.5, ¸ø¸öºì°ü£¬Ð»Ð»»ØÌû
ÒýÓûØÌû:
5Â¥: Originally posted by yumoym at 2014-03-23 10:36:03
ÄѵÀÊÇÒªÊäÈëÎÄ×Ö£¿

X1=AVERAGE(A1:A6);
Y1=STDEVA(A1:A6);
¶ÔX1, Y1 ×Ö·û´®»¯£¬Öмä¼ÓÉÏ¡°¡À¡±µÄÒâ˼¡£
6Â¥2014-03-23 14:44:18
ÒÑÔÄ   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
Ïà¹Ø°æ¿éÌø×ª ÎÒÒª¶©ÔÄÂ¥Ö÷ lm334723460 µÄÖ÷Ìâ¸üÐÂ
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] ²ÄÁÏ¿¼ÑÐÇóµ÷¼Á×Ü·Ö280 +15 mkjlz1 2026-04-06 17/850 2026-04-07 09:23 by audery861007
[¿¼ÑÐ] 085600£¬321·ÖÇóµ÷¼Á +14 ´ó²öС×Ó 2026-04-04 15/750 2026-04-06 22:58 by qlm5820
[¿¼ÑÐ] ²ÄÁϹ¤³Ìµ÷¼Á +3 СÁõͬѧ߹߹ 2026-04-06 4/200 2026-04-06 20:56 by lbsjt
[¿¼ÑÐ] 305Çóµ÷¼Á +3 77Qi 2026-04-06 3/150 2026-04-06 15:36 by going home
[¿¼ÑÐ] 285Çóµ÷¼Á +8 AZMK 2026-04-04 11/550 2026-04-06 13:56 by BruceLiu320
[¿¼ÑÐ] ÇóÖú071001µ÷¼Á£¡£¡£¡ +4 »ÆÊØËÉ 2026-04-05 5/250 2026-04-06 10:55 by 1028907439
[¿¼ÑÐ] ¸´ÊÔµ÷¼Á +5 asdasdassda 2026-04-05 5/250 2026-04-06 09:32 by dongzh2009
[¿¼ÑÐ] ²ÄÁÏר˶322·Ö +10 ¹þ¹þ¹þºðºðºð¹þ 2026-04-04 10/500 2026-04-05 21:22 by ѧԱ8dgXkO
[¿¼ÑÐ] 085600£¬320·ÖÇóµ÷¼Á +7 ´ó²öС×Ó 2026-04-01 8/400 2026-04-05 21:19 by ѧԱ8dgXkO
[¿¼ÑÐ] 285Çóµ÷¼Á +4 ¶ñ·¨´ó¶þµÄÆøÎ¶ß 2026-04-05 5/250 2026-04-05 20:32 by 286640313
[¿¼ÑÐ] ÉúÎïѧ308·ÖÇóµ÷¼Á£¨Ò»Ö¾Ô¸»ª¶«Ê¦´ó£© +8 ÏàÐűػá¹ââÍòÕ 2026-04-05 10/500 2026-04-05 12:19 by Hdyxbekcb
[¿¼ÑÐ] 271·ÖÇóµ÷¼ÁѧУ +12 zph158488£¡ 2026-04-02 13/650 2026-04-05 10:13 by lqwchd
[¿¼ÑÐ] 295Çóµ÷¼Á +4 AÄãºÃÑо¿Éú 2026-04-04 5/250 2026-04-04 22:46 by yu221
[¿¼ÑÐ] ±¾¿Æ211 ·ÖÊý293ÇëÇóµ÷¼Á +4 Á«²Ë¾ÍÊÇź°É 2026-04-01 4/200 2026-04-04 22:32 by hemengdong
[¿¼ÑÐ] 309Çóµ÷¼Á +4 ¿ìÀÖµÄС°×¸ë 2026-04-04 5/250 2026-04-04 15:55 by cql1109
[¿¼ÑÐ] 265Çóµ÷¼Á +17 ÁÖÉîÎÂÀ½ 2026-04-01 20/1000 2026-04-04 01:09 by userper
[¿¼ÑÐ] 366Çóµ÷¼Á +7 sbdnd 2026-04-03 7/350 2026-04-03 12:40 by cymywx
[¿¼ÑÐ] 085600£¬320·ÖÇóµ÷¼Á +6 ´ó²öС×Ó 2026-04-02 6/300 2026-04-02 21:54 by dongzh2009
[¿¼ÑÐ] 08¿ªÍ·¿´¹ýÀ´£¡£¡£¡ +4 wwwwffffff 2026-03-31 6/300 2026-04-02 11:42 by ¾ùÖµ»Ø¹é
[¿¼ÑÐ] 279Çóµ÷¼Á +6 ѧ¶øË¼ÙâÖª 2026-04-01 6/300 2026-04-02 09:16 by vgtyfty
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û