²é¿´: 3105  |  »Ø¸´: 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 µÄÖ÷Ìâ¸üÐÂ
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] Ò»Ö¾Ô¸Ìì½ò´óѧ»¯Ñ§¹¤ÒÕרҵ£¨081702£©315·ÖÇóµ÷¼Á +5 yangfz 2026-03-17 5/250 2026-03-17 17:01 by ruiyingmiao
[¿¼ÑÐ] 301Çóµ÷¼Á +3 A_JiXing 2026-03-16 3/150 2026-03-17 08:21 by Î޼ʵIJÝÔ­
[»ù½ðÉêÇë] ¹ú×Ô¿ÆÃæÉÏ»ù½ð×ÖÌå +6 iwuli 2026-03-12 7/350 2026-03-16 21:18 by sculhf
[¿¼ÑÐ] 326Çóµ÷¼Á +4 ŵ±´¶û»¯Ñ§½±êéê 2026-03-15 7/350 2026-03-16 17:11 by ŵ±´¶û»¯Ñ§½±êéê
[¿¼ÑÐ] 304Çóµ÷¼Á +4 ahbd 2026-03-14 4/200 2026-03-16 16:48 by ÎҵĴ¬Îҵĺ£
[¿¼ÑÐ] 304Çóµ÷¼Á +3 ÂüÊâ2266 2026-03-14 3/150 2026-03-16 16:39 by houyaoxu
[¿¼ÑÐ] 070303 ×Ü·Ö349Çóµ÷¼Á +3 LJY9966 2026-03-15 5/250 2026-03-16 14:24 by xwxstudy
[¿¼ÑÐ] 070305Çóµ÷¼Á +3 mlpqaz03 2026-03-14 4/200 2026-03-15 11:04 by peike
[¿¼ÑÐ] 297Ò»Ö¾Ô¸ÉϽ»085600Çóµ÷¼Á +5 Ö¸¼â°ËǧÀï 2026-03-14 5/250 2026-03-14 17:26 by a²»Ò×
[¿¼ÑÐ] 308 085701 ËÄÁù¼¶ÒѹýÇóµ÷¼Á +7 ÎÂÇÇÇÇÇÇÇÇ 2026-03-12 14/700 2026-03-14 10:49 by JourneyLucky
[¿¼ÑÐ] ÕÐÊÕ0805£¨²ÄÁÏ£©µ÷¼Á +3 18595523086 2026-03-13 3/150 2026-03-14 00:33 by 123%¡¢
[¿¼ÑÐ] ¸´ÊÔµ÷¼Á +9 Copy267 2026-03-10 9/450 2026-03-13 23:45 by userper
[¿¼ÑÐ] 337Ò»Ö¾Ô¸»ªÄÏÀí¹¤0805²ÄÁÏÇóµ÷¼Á +7 mysdl 2026-03-11 9/450 2026-03-13 22:43 by JourneyLucky
[¿¼ÑÐ] ²ÄÁÏÓ뻯¹¤Çóµ÷¼ÁÒ»Ö¾Ô¸ 985 ×Ü·Ö 295 +8 dream¡­¡­ 2026-03-12 8/400 2026-03-13 22:17 by ÐÇ¿ÕÐÇÔÂ
[¿¼ÑÐ] £Û0860£Ý321·ÖÇóµ÷¼Á£¬abÇø½Ô¿É +4 ±¦¹óÈÈ 2026-03-13 4/200 2026-03-13 22:01 by ÐÇ¿ÕÐÇÔÂ
[¿¼ÑÐ] ËÄ´¨´óѧ085601²ÄÁϹ¤³Ìר˶ ³õÊÔ294Çóµ÷¼Á +4 ×£ÎÒÃǺÃÔÚ¶¬Ìì 2026-03-11 4/200 2026-03-13 21:39 by peike
[¿¼ÑÐ] ²ÄÁÏÓ뻯¹¤085600µ÷¼ÁÇóÀÏʦÊÕÁô +9 jiaanl 2026-03-11 9/450 2026-03-13 20:22 by JourneyLucky
[¿¼ÑÐ] 301Çóµ÷¼Á +6 Liyouyumairs 2026-03-11 6/300 2026-03-13 20:11 by JourneyLucky
[¿¼ÑÐ] Çóµ÷¼Á +3 ³ÌÓ꺼 2026-03-12 3/150 2026-03-13 15:06 by JourneyLucky
[¿¼ÑÐ] 277Çóµ÷¼Á +4 anchor17 2026-03-12 4/200 2026-03-13 11:15 by °×Ò¹ÓÆ³¤
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û