ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] §ä¥X¦U¸s²Õªº²³¼Æ(¤£§t0)

¦^´_ 40# Bodhidharma
bin_array«D»¼¼W¼Æ­È°}¦C®É
·|¥H¤p©óµ¥©óbin_array°}¦C¤¸¯À¡A¨Ã¦©°£¨ä¾l¤¸¯À¥H­pºâ¹L¤§¤¸¯À§@¬°­pºâ
¨Ò¦p:°}¦C¤¸¯À¤¤¦³­«½Æªº­È¡A¦]¬°¦b²Ä¤@¦¸¥X²{®É¤w¸g­pºâ¹L¸Ó­È¥H¤Uªº¥X²{ÀW²v
©Ò¥H²Ä¤G¦¸¥X²{®É´N·|¦©°£¤w­pºâ¹Lªºµ²ªG

¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 40# Bodhidharma

1.
¹ï¡A
«eE2¤½¦¡
=IF(B2=B3,INT(N(E3))+1+1/ROW(),"")
¨Ã¨S¦³³B²z"¤£¦P²Õ"©Î¬O"¼Æ­È¬°¹s"ªº±¡ªp¡A¥i¥H§ï¬°
=IF(AND(A2=A3,B2=B3,B2<>0),INT(N(E3))+1+1/ROW(),"")

2.
FREQUENCY¬Ý»¡©ú½T¹ê¤£®e©öÀ´¡A°O±o­è¶}©l¾Ç¦¹¨ç¼Æ®É¤]¦bºô¸ô¤W§ä«Ü¦h¹ê¨Ò¨Ó¤F¸Ñ¡A¤´»Ý°µ°µ¤p¼Ò«¬¤ÏÂФñ¸û®t²§¤~¯à²`¤J¡C

FREQUENCY¨ÃµL »¼¼W©Î»¼´î ªº³W©w
¬O­pºâ¤p©ó©Îµ¥©óbins_array¶¡ªºdata_array¼Æ¶q¡C

¦]¬°ÃD¥Ø­n¨D¦b³sÄò­«½Æ¼Æªº²Ä¤@­ÓÅã¥Ü¨ä­È¡A¦]¼Ð°O¼Æ­n¤j©óµ¥©ódata_array(¸Ó­«½Æ¼Æ°Ï¤º)¡C

¨Ò¦p A1:A9¤¤A4:A6¬O­«½Æ¼Æ {1,2,3,4,4,4,7,8,9}

¤@¦¡
=FREQUENCY(ROW(1:9),ROW(1:9)*(L1:L9<>L2:L10))
={1;1;1;0;0;3;1;1;1;0}

¤G¦¡
=FREQUENCY(-ROW(1:9),-ROW(1:9)*(L1:L9<>L2:L10))
={1;1;3;0;0;1;1;1;1;0}

¨â¦¡³£¥i¥H±o³Ì¤j­«½Æ¼Æ 3¡A¦ý¦ì¸m«o¤£¦P¡C³o´N¬O ROW(1:9) »P -ROW(1:9) ®t¤@­Ó­t¸¹ªº¥Î·N¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 42# ML089

­è­è´ú¸Õ¤F¤@¤U¡A¤£ª¾¹D³o¼Ëªº²z¸Ñ¥¿¤£¥¿½T¡G
frequency(data_array,bin_array)
­Ydata_arrayªº­È¬°d[1],d[2]...d[n]¡Abin_arrayªº­È¬°b[1],b[2]...b[x]¡A¦^¶Çresult_arrayªº­È¬°r[1],r[2]...r[x+1]
·|¥ý·j´Mbin_array¤¤¡A²Ä¤@­Ó¥X²{³Ì¤pªº­Èmin(bin_array)¡A°²³]²Ä¤@­Ó¥X²{ªº¬°b[y]
«hr[y]=data_array¤¤¤p©óµ¥©ób[y]ªº­Èªº¼Æ¶q
¦Ü©ó¤£¬O²Ä¤@­Ó¥X²{ªºb[y']=min(bin_array)¡Ar[y']ªº­È·|¬O¹s
µM«á¦A·j´Mbin_array¤¤²Ä¤@­Ó¥X²{¡A²Ä¤G¤pªº­Èb[z]
r[z]=data_array¤¤¡A¤p©óµ¥©ób[z]¥B¤j©ób[y]ªº­Èªº¼Æ¶q¡A¨ä¥¦ªºr[z']ªº­È¤@¼Ë¬O¹s
¥H¦¹Ãþ±À¡AµM«ár[x+1]=data_array¤¤¡A¤j©ómax(bin_array)ªº­Èªº¼Æ¶q

TOP

¦^´_ 43# Bodhidharma

µy·L¼ÒÀÀ¤F¤@¤U¡A¸Õ¤F¤@¨Ç¼Æ¦r¡A¬Ý°_¨ÓÀ³¸Ó¬O¥¿½Tªº
(Ãi±o¥Î°ÊºA½d³ò¡A¦]¦¹§â¥i¿é¤Jªº¸ê®Æ­­©w¦b100¦C¥H¤º)

frequency¨ç¼Æ¼ÒÀÀ.rar (10.37 KB)

TOP

¦^´_ 43# Bodhidharma


bin_array ¤£¥Î±Æ§Ç¡A­Y¦³­«½Æ¼Æ®É¡A­pºâ­È·|¼Ðµù©ó²Ä¤@¦¸¥X²{¤§¼Æ¦ì¸m¨ä¥L¬°0
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_  Bodhidharma


bin_array ¤£¥Î±Æ§Ç¡A­Y¦³­«½Æ¼Æ®É¡A­pºâ­È·|¼Ðµù©ó²Ä¤@¦¸¥X²{¤§¼Æ¦ì¸m¨ä¥L¬°0
ML089 µoªí©ó 2013-4-8 17:28


¶â¡A¤Ï¥¿result_array[x]´N¬O¦^¶Ç¡u¤p©óµ¥©óbin_array[x]¡A¥B¤j©ó"bin_array¤¤¡A¦¸¤p©óbin_array[x]"¡v³o­Ó°Ï¶¡ªº¼Æ­È­Ó¼Æ
¦pªG¤w¸g¬Obin_array¤¤³Ì¤pªº¡A«h¦^¶Ç©Ò¦³¤p©óµ¥©ó¸Ó­Èªº­Ó¼Æ
­Y¦³­«½Æªº¸Ü´N¼Ðµù²Ä¤@­Ó¡A¨ä¥¦¬°¹s
µM«á¤j©óbin_array¤¤³Ì¤j¼Æ­È­Ó¼Æªº¡A´N©ñ¦bresult_arrayªº¦C«á¤@¦C

TOP

¦^´_ 46# Bodhidharma


§â¾ã­Ó¨ç¼Æ¼g¦b¤@°_¡A°ò¥»¤WÀ³¸Ó´Nº¡²M·¡ªº
½Ð¤j®aÀ°§Ú¬Ý¤@¤U³o¼Ëªº·§©À¥¿¤£¥¿½T
frequency¨ç¼Æ»¡©ú.rar (10.83 KB)

TOP

¦^´_ 47# Bodhidharma


¦pªG¯à¼ÒÀÀ¥X¥¿½Tµª®×¡A¹ïFREQUENCY¨ç¼Æ¤w¸g¥R¤À¤F¸Ñ
¥t¥~¥[¤@ÂI¡A«D¼Æ¦r¦Û°Ê±Æ°£¡A­pºâ­È·|©¹«e±Æ¦C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 48# ML089


·PÁ»¡©ú

§Ú¸Õ¹Ï§â¤½¦¡¼g¦b¦P¤@¦æ¡A¤£¹Lµo²{¥\¤O¤£¨¬
ª½¦n¥t¥~¥[¤@¦æ¡A§â­ì¥»ªºµ²ªG·í¦¨»²§U¦C

ª½Ä±¤WÀ³¸Ó¬O­n¥Î©w¸q¦WºÙ¡A¤£¹L§Ú©w¸q¦WºÙÁÙ¤£°÷¼ô
¤£·|³B²z³oºØ¦³°ÊºA½d³òªº¤½¦¡¡GIF(COUNTIF(OFFSET($B$2,,,ROW()-1,),B2)>1,0,......)

·Q½Ð±Ð³oºØ¦³°ÊºA½d³òªº¤½¦¡¡A¬O§_¥i¥H¥Î©w¸q¦WºÙ³B²z¡H
(ÁÙ¬O»¡³o¸ò¥»¤£¬O©w¸q¦WºÙªº°ÝÃD¡H)

frequency¨ç¼Æ»¡©ú(³B²z«D¼Æ¦r).rar (12.37 KB)

TOP

¦^´_ 49# Bodhidharma

I2
=IF(ROW()=COUNTA(B:B)+1,COUNTIF(A:A,">"&MAX(B:B)),IF(OR(ISERR(-B2),MATCH(B2,B:B,)<>ROW()),0,COUNTIF(A:A,"<="&B2)-IF(B2=MIN(B:B),0,COUNTIF(A:A,"<="&SMALL(B:B,COUNTIF(B:B,"<"&B2))))))

¤@¯ë¤½¦¡

¦¹¤½¦¡¼ÒÀÀ FREQUENCY ¦ý¨S¦³³B²z bin_array ¦³«D¼Æ­È¤§±¡ªp¡A
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¤Hªº²´·úªø¦b«e­±¡A¥u¬Ý¨ì§O¤Hªº¯ÊÂI¡Aµ·²@¬Ý¤£¨ì¦Û¤vªº¯ÊÂI¡C
ªð¦^¦Cªí ¤W¤@¥DÃD