Znn3bq.jpeg
²é¿´: 413  |  »Ø¸´: 8
µ±Ç°Ö÷ÌâÒѾ­´æµµ¡£

liguanghui

½ð³æ (СÓÐÃûÆø)

[½»Á÷] 6½ð±ÒÇóÖúÒ»ÎÊÌ⣬½ØÖÁ2009Äê6ÔÂ4ÈÕ

ÓÐûÓм¸ºÎ±ê׼ƫ²î£¿
ÈçºÎ¼ÆË㣿
ÄÜÔÚexcel¼ÆËãÂð£¿

» ²ÂÄãϲ»¶

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

wpq113

ÖÁ×ðľ³æ (ÖøÃûдÊÖ)


¡ï
liguanghui(½ð±Ò+1,VIP+0):Ö÷ÒªÊÇÏòÖªµÀÈçºÎËãµÄ 6-2 15:12
¼¸ºÎ±ê×¼²î;geometric standard deviation
ÐÔÖÊ£º ÈôÒ»×é²â¶¨Öµ£¬È¡¶ÔÊýºó×ñ´ÓÕý̬·Ö²¼£¬Ôò³ÆÆä×ñÑ­¶ÔÊýÕý̬·Ö²¼£¬Æä·½²îΪ½«È¡·´¶ÔÊýÖ®ºó£¬³ÆÎª¼¸ºÎ·½²î£¬Æä·½¸ùÖµ³ÆÎª¼¸ºÎ±ê×¼²î¡£
2Â¥2009-06-02 15:09:31
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

wpq113

ÖÁ×ðľ³æ (ÖøÃûдÊÖ)


¡ï
liguanghui(½ð±Ò+1,VIP+0): 6-6 21:21
´øÍ³¼Æ¹¦ÄܵļÆËãÆ÷¾ÍÄÜËã
excelÖÐÓÃSTDEV»òSTDEVP
3Â¥2009-06-02 15:12:09
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

wpq113

ÖÁ×ðľ³æ (ÖøÃûдÊÖ)


¡ï
liguanghui(½ð±Ò+1,VIP+0): 6-6 21:21
¼¸ºÎ±ê×¼²î ¦Ò£¨geo£© = exp(¦Ò)

¦Ò¹«Ê½¼û£º

http://zh.wikipedia.org/wiki/%E5 ... 1%E5%88%86%E5%B8%83
4Â¥2009-06-02 15:16:02
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

º£½Ç¹ÂÐÐ

Ìú¸Ëľ³æ (ÖøÃûдÊÖ)

Сľ³æ_×øµØ»§

¡ï
liguanghui(½ð±Ò+1,VIP+0): 6-6 21:21
=STDEV(A1:A5)   ÊÇÔÚexcelÖеļÆËã±ê׼ƫ²î·½·¨
£¨Óñê׼ƫ²î/ƽ¾ùÖµ£©*100%ΪÏà¶Ô±äÒìϵÊý
µ±ÄãÕÒ²»µ½·½Ïòʱ,¾Í»Øµ½Ô­µãºÃºÃÏëÏë.
5Â¥2009-06-02 15:36:54
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

zfq184

Òø³æ (ÕýʽдÊÖ)

¡ï
liguanghui(½ð±Ò+1,VIP+0): 6-6 21:21
ÓÐ
Ò²¿ÉÒÔÓÃexcel¼ÆËã
¾ßÌåµÄÄã¿ÉÒÔ²éÏÂ
°®Á˾ͺÃ
6Â¥2009-06-02 15:59:54
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
ÒýÓûØÌû:
Originally posted by wpq113 at 2009-6-2 15:09:
¼¸ºÎ±ê×¼²î;geometric standard deviation
ÐÔÖÊ£º ÈôÒ»×é²â¶¨Öµ£¬È¡¶ÔÊýºó×ñ´ÓÕý̬·Ö²¼£¬Ôò³ÆÆä×ñÑ­¶ÔÊýÕý̬·Ö²¼£¬Æä·½²îΪ½«È¡·´¶ÔÊýÖ®ºó£¬³ÆÎª¼¸ºÎ·½²î£¬Æä·½¸ùÖµ³ÆÎª¼¸ºÎ±ê×¼²î¡£

7Â¥2009-06-02 16:13:27
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

wuweijwt

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

¼¸ºÎ±ê×¼²îÕâ¸öÊdz£ÓõÄͳ¼ÆÑ§Á¿£¬Â¥Ö÷ÓÃmatlab»òÕßspssÈí¼þÖ±½Ó¾Í¿ÉÒÔËã°É
8Â¥2009-06-02 22:57:14
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

csuliu3976

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

origin¿ÉÒÔ¼ÆË㣡
9Â¥2009-06-03 08:34:23
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
Ïà¹Ø°æ¿éÌø×ª ÎÒÒª¶©ÔÄÂ¥Ö÷ liguanghui µÄÖ÷Ìâ¸üÐÂ
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] ÖÐҩѧµ÷¼Á ³õÊÔ324 +3 Ñó¸Ê¾Õ¡¢ 2026-04-10 4/200 2026-04-10 18:56 by Ñó¸Ê¾Õ¡¢
[¿¼ÑÐ] Çóµ÷¼Á288 +5 ioodiiij 2026-04-10 7/350 2026-04-10 15:49 by ioodiiij
[¿¼ÑÐ] 302·ÖÇóµ÷¼Á +7 ·²ÓïÆíÔ¸ 2026-04-08 8/400 2026-04-10 10:28 by Delta2012
[¿¼ÑÐ] 293Çóµ÷¼Á +5 ÓÂÔ¶¿â°®314 2026-04-08 5/250 2026-04-10 08:46 by vgtyfty
[¿¼ÑÐ] ¿¼Ñе÷¼Á-²ÄÁÏÀà-284 +28 Ïë»»ÊÖ»ú²»Ïë½âÊ 2026-04-08 28/1400 2026-04-09 20:08 by µ¹Êý321?
[¿¼ÑÐ] 267Çóµ÷¼Á +5 ÔÙæҲҪ³Ô·¹°¡ 2026-04-09 5/250 2026-04-09 18:47 by stone_128
[¿¼ÑÐ] ¸´ÊÔµ÷¼Á£¬Ò»Ö¾Ô¸Ö£ÖÝ´óѧ²ÄÁÏÓ뻯¹¤289·Ö +31 ˶ÐǸ° 2026-04-08 31/1550 2026-04-09 16:54 by Delta2012
[¿¼ÑÐ] 288Çóµ÷¼Á +15 ûÓдð°¸_ 2026-04-05 15/750 2026-04-09 10:22 by 5268321
[¿¼ÑÐ] Çóµ÷¼Á +3 ÖíÈâ¶Õ·ÛÌõcc 2026-04-08 4/200 2026-04-09 10:05 by ÖíÈâ¶Õ·ÛÌõcc
[¿¼ÑÐ] Èí¼þ¹¤³ÌÇóµ÷¼Á22Èí¹¤296·ÖÇóµ÷¼Á£¬½ÓÊÜ¿çµ÷ +4 yangchen2017 2026-04-08 5/250 2026-04-08 21:56 by ÍÁľ˶ʿÕÐÉú
[¿¼ÑÐ] Èí¹¤Ñ§Ë¶299Çóµ÷¼Á +6 useryy 2026-04-07 6/300 2026-04-07 09:50 by vgtyfty
[¿¼ÑÐ] 307Çóµ÷¼Á +3 Youth@@ 2026-04-07 3/150 2026-04-07 09:25 by СºÚ²»ÅÂÄÑ
[¿¼ÑÐ] Çóµ÷¼Á +10 chenxrlkx 2026-04-05 10/500 2026-04-06 11:31 by Öí»á·É
[¿¼ÑÐ] 0855Çóµ÷¼Á²ÄÁÏ +11 ºìÌÒׯׯ 2026-04-04 12/600 2026-04-06 10:26 by À¶ÔÆË¼Óê
[¿¼ÑÐ] 348Çóµ÷¼Á +6 wukira 2026-04-04 6/300 2026-04-05 18:11 by Öí»á·É
[¿¼ÑÐ] ¿¼ÑÐÉúÎïѧ¿¼AÇø211£¬³õÊÔ322£¬¿ÆÄ¿Éú»¯ºÍÉúÎï×ۺϣ¬Çóµ÷¼Á +6 ¡£¡£¡£54 2026-04-03 6/300 2026-04-05 14:54 by JOKER0401
[¿¼ÑÐ] 085600µ÷¼Á +9 ¶«ÕÕÕÕÕÕ 2026-04-04 9/450 2026-04-05 13:44 by ujn_zhuj
[¿¼ÑÐ] 272Çóµ÷¼Á +4 µçÆøÀî 2026-04-05 4/200 2026-04-05 10:41 by lbsjt
[¿¼ÑÐ] 309Çóµ÷¼Á +4 ¿ìÀÖµÄС°×¸ë 2026-04-04 5/250 2026-04-04 15:55 by cql1109
[¿¼ÑÐ] ¿¼Ñе÷¼Á +4 zybz³å³å³å 2026-04-03 6/300 2026-04-04 13:08 by zybz³å³å³å
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û