±±¾©Ê¯ÓÍ»¯¹¤Ñ§Ôº2026ÄêÑо¿ÉúÕÐÉú½ÓÊÕµ÷¼Á¹«¸æ
²é¿´: 3125  |  »Ø¸´: 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 µÄÖ÷Ìâ¸üÐÂ
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] 265Çóµ÷¼Á +14 Сľ³æ085600 2026-04-06 16/800 2026-04-07 10:08 by dongzh2009
[¿¼ÑÐ] 295Çóµ÷¼Á +17 xndjjj 2026-04-04 18/900 2026-04-07 09:42 by piklet
[¿¼ÑÐ] 277¹¤¿ÆÇóµ÷¼Á +10 1915668 2026-04-04 11/550 2026-04-06 23:53 by ÐÄæÂÒâ±±
[¿¼ÑÐ] Ò»Ö¾Ô¸ÄϺ½£¬ÊýһӢһѧ˶317Çóµ÷¼Á£¡£¡ +6 Acaciad 2026-04-04 6/300 2026-04-06 12:13 by ¿¼ÑÐѧУÕеãÈË
[¿¼ÑÐ] Ò»Ö¾Ô¸Î÷°²½»´ó²ÄÁÏѧ˶£¨Ó¢Ò»Êý¶þ£©347£¬Çóµ÷¼Áµ½¸ß·Ö×Ó/²ÄÁÏÏà¹Ø×¨Òµ +8 zju51 2026-03-31 10/500 2026-04-06 09:03 by ×íÎÌwl
[¿¼ÑÐ] 316Çóµ÷¼Á +5 yyxÏëµ÷¼Á 2026-04-05 5/250 2026-04-05 22:22 by ßÇßÇßÇßÇ9
[¿¼ÑÐ] ÉúÎïÓëÒ½Ò©086000µ÷¼ÁÒ»Ö¾Ô¸Î÷±±Å©ÁÖ320·Ö +3 ÃÀÃÀŮʿ 2026-04-03 3/150 2026-04-05 21:55 by ѧԱ8dgXkO
[¿¼ÑÐ] ±¾¿Æ211£¬293·ÖÇëÇóµ÷¼Á +8 Á«²Ë¾ÍÊÇź°É 2026-04-03 9/450 2026-04-05 19:12 by À¶ÔÆË¼Óê
[¿¼ÑÐ] 324Çóµ÷¼Á +9 ÏëÉÏѧÇóµ÷ 2026-04-03 9/450 2026-04-04 23:57 by ¹û¶³´óÍõ
[¿¼ÑÐ] ²ÄÁϵ÷¼Á +15 Ò»ÑùYWY 2026-04-01 15/750 2026-04-04 22:23 by hemengdong
[ÂÛÎÄͶ¸å] ÇóÎÄÏ× 5+3 ys879651$ 2026-04-02 3/150 2026-04-04 17:22 by bobvan
[¿¼ÑÐ] Ò»Ö¾Ô¸¶«±±´óѧ085901ÍÁľר˶345Çóµ÷¼Á +3 zxt11111 2026-04-04 3/150 2026-04-04 14:21 by ÍÁľ˶ʿÕÐÉú
[¿¼ÑÐ] Çóµ÷¼Á +3 ũҵ¹¤³ÌÓëÐÅÏ¢¼ 2026-04-04 3/150 2026-04-04 12:19 by Éá¶øºóµÃ
[¿¼ÑÐ] 265Çóµ÷¼Á +17 ÁÖÉîÎÂÀ½ 2026-04-01 20/1000 2026-04-04 01:09 by userper
[¿¼ÑÐ] 274Çóµ÷¼Á +9 ˳Àí³ÉÕÅ 2026-04-03 10/500 2026-04-03 15:10 by °¡¿¡£¡
[¿¼ÑÐ] ÉúÎïѧ308·ÖÇóµ÷¼Á£¨Ò»Ö¾Ô¸»ª¶«Ê¦´ó£© +6 ÏàÐűػá¹ââÍòÕ 2026-03-31 7/350 2026-04-02 23:16 by JourneyLucky
[¿¼ÑÐ] 298ÇóBÇøµ÷¼Á +4 zzz£¬£¬r 2026-04-02 5/250 2026-04-02 12:17 by ÍÁľ˶ʿÕÐÉú
[¿¼ÑÐ] 271Çóµ÷¼Á +15 ÀÕ²¼ÀÊ@ 2026-03-31 20/1000 2026-04-02 11:24 by Sammy2
[¿¼ÑÐ] 307·ÖÇóµ÷¼Á +14 (o~o) 2026-03-31 15/750 2026-04-01 20:43 by longlotian
[¿¼ÑÐ] 353Çóµ÷¼Á +4 À­¹³²»Ðí±ä 2026-04-01 4/200 2026-04-01 18:10 by ¼Çʱ¾2026
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û