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

Ãö©óExcel ¼gSigma¬ÛÃöªº°ÝÃD

Ãö©óExcel ¼gSigma¬ÛÃöªº°ÝÃD


³o­Ó°ÝÃD¥Ø«e¥d¦b¬õ®Ø³B,¦]¬°¥»¨­¨S¾Ç¹LVBA,©Ò¥H±o¥Î¤@¯ë¤½¦¡¼g¥X¦¹­pºâ¦¡,¦ý¬OSigma¤p§Ì¥u¼g±o¥X:¿é¤Jn,±q1¥[¨ìnªº­È,´N¤w¸g¦³ÂI«j±j¤F

¤½¦¡¦p¤U:
=SUMPRODUCT(ROW(INDIRECT("1:"&($A$1-1))))  
¦bA1¿é¤Jn¥i±o1¥[¨ìnªº¼Æ­È

¦ý¬O³o¼Ëªº¤½¦¡·Q¤£¨ì­n«ç»ò®M¥Î¨ì¬õ®Ø¸Ì­±ªº­pºâ¦¡...

·Q¸Õ°Ý¦U¦ì¤j¤j¬O§_¦³¿ìªk¤£¥ÎVBA¼g¥X¬õ®Ø¸Ìªº­pºâ¦¡,©Ò¦³¥¼ª¾¼Æ³£¬O¥i¥H¿é¤Jªº¡C

¦^´_ 1# larry6705
B1¶ñu
C1¶ñ£f
D1¶ñs
E1=¬õ®Ø­È =SUMPRODUCT(POWER(C1,ROW(INDIRECT("1:"&D1-1)))/(POWER(B1,ROW(INDIRECT("1:"&D1-1)))*FACT(ROW(INDIRECT("1:"&D1-1)))))
³o¼Ë¶Ü?

TOP

¦^´_ 2# stillfish00

ÅçÃÒ¤¤,·PÁ¤j¤j¼ö±¡¸Ñµª

TOP

¥¿½TµL»~ ! ¦A¦¸·PÁ¤j¤j

TOP

        ÀR«ä¦Û¦b : ¦¨¥\¬OÀuÂIªºµo´§¡A¥¢±Ñ¬O¯ÊÂIªº²Ö¿n¡C
ªð¦^¦Cªí ¤W¤@¥DÃD