²é¿´: 541  |  »Ø¸´: 10
µ±Ç°Ö÷ÌâÒѾ­´æµµ¡£

parklyn

Ìú¸Ëľ³æ (Ö°Òµ×÷¼Ò)

°¢É­Äɶӳ¤

[½»Á÷] excelÀïÊý¾Ý¼ÆËãÎÊÌâ

excelÀïÓÐÒ»ÁÐÊý£¬ÈçºÎ¿ìËÙµÄÇó³öǰnÏîÆ½¾ùÖµ£¬Ç°nÏîµÄ±ê×¼²î£¿±ÈÈç300¸öÊý£¬ÏÖÔÚÒªÇóǰ1£¬2£¬3£¬4£¬5£¬6.¡£¡£¡£300¸öÊýµÄƽ¾ùÖµ¼°±ê×¼²î£¿Ð»Ð»£¡

» ²ÂÄãϲ»¶

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

daisiwuxie

½ð³æ (ÕýʽдÊÖ)

parklyn(½ð±Ò+1): 2010-03-14 14:47
ÀÁµÃ˵ÁË£¬¿´Á´½Ó°É£¬
http://www0.ccidnet.com/school/zhuan/excelfunction.htm
2Â¥2010-03-14 11:50:33
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

sinaky

parklyn(½ð±Ò+1): 2010-03-14 14:48
²åÈëAVERAGE(C1:C300) CΪÁкſÉÇ󯽾ùÖµ£»STDEVP(C1:C300)·µ»Ø±ê×¼²î
3Â¥2010-03-14 11:51:17
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

sinaky

Èô²»»á²åÈëÖ±½ÓÕÒÒ»¸ö¸ñд=AVERAGE(C1:C300)CΪÄãÄÇÁÐÊýµÄÁкż´¿É£¬ÄÇÒ»¸öÒ²Ïàͬ¡£
ÀàËÆµÄһЩͨÓú¯ÊýÄã¿ÉÒԵ㹤¾ßÀ¸¡°²åÈ루I£©¡±À´ÊìϤ¡£
4Â¥2010-03-14 11:54:46
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

parklyn

Ìú¸Ëľ³æ (Ö°Òµ×÷¼Ò)

°¢É­Äɶӳ¤

ÒýÓûØÌû:
Originally posted by sinaky at 2010-03-14 11:51:17:
²åÈëAVERAGE(C1:C300) CΪÁкſÉÇ󯽾ùÖµ£»STDEVP(C1:C300)·µ»Ø±ê×¼²î

ÎÒÊÇÏëÇóͬһÁÐµÄ ±ÈÈçÇó³öǰ3¸ö£¬Äܲ»ÄÜÖ±½ÓÍϳöǰ4£¬5£¬6....n¸öÄØ£¿
5Â¥2010-03-14 12:16:57
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

magictang

ľ³æ (ÕýʽдÊÖ)

¶À¹ÂÇó°Ü

¿ÉÒÔµÄ
6Â¥2010-03-14 12:35:53
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

SP_spark

½ð³æ (ÕýʽдÊÖ)

´ó½«¾ü

parklyn(½ð±Ò+1): 2010-03-15 23:14
......excelûÓÐѧºÃ°¡   ¸Ï¿ìÈ¥²¹Ï°
[img=http://i.WoTuLa.com/note.png?name=zÖ콡ΰ&say=ÉñÖ®ÁìÓò]
7Â¥2010-03-14 12:41:45
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

charmee

ľ³æ (ÖøÃûдÊÖ)

parklyn(½ð±Ò+1): 2010-03-15 23:15
Ò»°ãµÄ°ì¹«ÊÒÈí¼þÊéÉ϶¼ÓÐдµÄ°É£¿·­³öÀ´¿´¿´£¬²»Äѵģ¡
8Â¥2010-03-14 13:57:09
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

parklyn

Ìú¸Ëľ³æ (Ö°Òµ×÷¼Ò)

°¢É­Äɶӳ¤

´ó¼Ò¿ÉÄÜÎó½âÎÒµÄÒâ˼ÁË ÎÒ»áËã ÎÒÖ»ÊÇÏë¼òµ¥µÄ¿ìËÙ¼ÆËã³öÀ´ Ò»¸ö¸öÀ´¿Ï¶¨¿ÉÒÔ°¡
9Â¥2010-03-14 14:45:59
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

zhixian-ma

ľ³æ (ÕýʽдÊÖ)

parklyn(½ð±Ò+1): 2010-03-15 23:15
Äã°ÑAverageº¯Êý´òÉÏ£¬À¨ºÅÄÚµÄÄÚÈÝÄãÏëÇóÄÇЩֱ½ÓÍÏÄÇЩ¾ÍOKÁË
¾²£¬¼ó£¬Îò£¬Éú£¬³É
10Â¥2010-03-14 18:09:46
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
Ïà¹Ø°æ¿éÌø×ª ÎÒÒª¶©ÔÄÂ¥Ö÷ parklyn µÄÖ÷Ìâ¸üÐÂ
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] 302Çóµ÷¼Á +7 ºôºôºô¡£¡£¡£¡£ 2026-03-17 7/350 2026-03-18 08:00 by ms629
[¿¼ÑÐ] 312Çóµ÷¼Á +5 İå·Ï£ 2026-03-16 6/300 2026-03-18 08:00 by Iveryant
[¿¼ÑÐ] 0703»¯Ñ§336·ÖÇóµ÷¼Á +5 zbzihdhd 2026-03-15 6/300 2026-03-18 04:34 by anny19840123
[¿¼ÑÐ] 301Çóµ÷¼Á +6 yyÒªÉϰ¶Ñ½ 2026-03-17 6/300 2026-03-17 23:58 by ÐÇ¿ÕÐÇÔÂ
[¿¼ÑÐ] ¿¼ÑÐÇóµ÷¼Á +3 éÙËÌ. 2026-03-17 4/200 2026-03-17 21:43 by ÓÐÖ»ÀêÅ«
[¿¼ÑÐ] ÄÜÔ´²ÄÁÏ»¯Ñ§¿ÎÌâ×éÕÐÊÕ˶ʿÑо¿Éú8-10Ãû +3 ÍÑÓ±¶ø³ö 2026-03-16 6/300 2026-03-17 21:19 by z1z2z3879
[¿¼ÑÐ] 328Çóµ÷¼Á£¬Ó¢ÓïÁù¼¶551£¬ÓпÆÑо­Àú +3 ÉúÎ﹤³Ìµ÷¼Á 2026-03-16 8/400 2026-03-17 19:03 by Wangjingyue
[¿¼ÑÐ] 290Çóµ÷¼Á +3 p asserby. 2026-03-15 4/200 2026-03-17 16:35 by wangkm
[ÂÛÎÄͶ¸å] ÓÐûÓдóÀз¢Ð¡ÂÛÎÄÄÜ´øÎÒ¸ö¶þ×÷ +3 ÔöÈñ©ÈË 2026-03-17 4/200 2026-03-17 09:26 by xs74101122
[¿¼ÑÐ] ²ÄÁÏÓ뻯¹¤Ò»Ö¾Ô¸Äϲý´óѧ327Çóµ÷¼ÁÍÆ¼ö +7 Ncdx123456 2026-03-13 8/400 2026-03-16 12:15 by karry wen
[¿¼ÑÐ] 0703 ÎïÀí»¯Ñ§µ÷¼Á +3 ÎÒ¿ÉÒÔÉϰ¶µÄ¶Ô 2026-03-13 5/250 2026-03-16 10:50 by ÎÒ¿ÉÒÔÉϰ¶µÄ¶ÔÂ
[¿¼ÑÐ] ÇóÀÏʦÊÕÁôµ÷¼Á +4 jiang½ª66 2026-03-14 5/250 2026-03-15 20:11 by Winj1e
[¿¼ÑÐ] 288Çóµ÷¼Á +4 Ææµã0314 2026-03-14 4/200 2026-03-14 23:04 by JourneyLucky
[¿¼ÑÐ] 308Çóµ÷¼Á +5 ÊÇLupa°¡ 2026-03-11 5/250 2026-03-13 22:13 by JourneyLucky
[¿¼ÑÐ] 336Çóµ÷¼Á +6 Iuruoh 2026-03-11 6/300 2026-03-13 22:06 by JourneyLucky
[¿¼ÑÐ] Çó²ÄÁϵ÷¼Á 085600Ó¢Ò»Êý¶þ×Ü·Ö302 ǰÈý¿Æ235 ¾«Í¨»úÆ÷ѧϰ Ò»Ö¾Ô¸¹þ¹¤´ó +4 ÁÖyaxin 2026-03-12 4/200 2026-03-13 22:04 by ÐÇ¿ÕÐÇÔÂ
[¿¼ÑÐ] 281Çóµ÷¼Á +9 Koxui 2026-03-12 11/550 2026-03-13 20:50 by Koxui
[¿¼ÑÐ] 277Çóµ÷¼Á +4 anchor17 2026-03-12 4/200 2026-03-13 11:15 by °×Ò¹ÓÆ³¤
[¿¼ÑÐ] 0817»¯Ñ§¹¤³ÌÓë¼¼Êõ¿¼ÑÐ312·Öµ÷¼Á +3 T123 tt 2026-03-12 3/150 2026-03-13 10:49 by houyaoxu
[¿¼ÑÐ] 081200-11408-276ѧ˶Çóµ÷¼Á +3 ´Þwj 2026-03-12 4/200 2026-03-12 19:33 by Çóµ÷¼Ázz
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û