ORåè·¯ã«é¢ããŠã¯ãåèšäºã®Excelã·ãŒãã«ãããŠã»ã«B13ïœD16ã«å ¥ã£ãŠããççå€è¡šããŒã¿ã®ãã¡ãD14ãšD15ã 1 ã«å€æŽããã ãã§ãããççå€è¡šããŒã¿ãåæå€ãããã«åŸ®å°å€ãªã©ã®æ°å€ããŒã¿ã¯ããããã§ãäžæžããå¯èœã§ããã
Â
ä»åãcsvãã¡ã€ã«ã®ãã³ãã貌ãä»ãããååã®csvãšã®çžéç¹ã¯13è¡ç®ãš14è¡ç®ã ãã ããããã¡ã€ã«ãä¿åããŠããã ããæ¹ã¯Excelã§éããŠããŒã¿ãæžãæããŠããã ããæ¹ãæ©ãã®ã ãã
远èšïŒ
csvãã¡ã€ã«ã®ãã³ãã¯ãšã³ããªãŒæ«å°Ÿã«ç§»åããŸããããµã€ãããŒã«ã¯ã¿åºããŠç¯å²éžæããã¥ããã£ãã®ã§ã
远èšããã
Â
ååãšåæ§ã®æäžã§ãã¯ãããã¿ã³ã«ç»é²ãããšããã¯ãã ããã60åãããã¯ãªãã¯ããé ãããããªãã¡ççå€è¡šã®ãåŠç¿ãã15åãããç¹°ãè¿ããé ãããx ãš y ãäž¡æ¹ãšã 1 ã®ãšããæšå®å€ãã®å€ãè² ããã以å€ã®å Žåã«ã¯æ£ã«ãªãã¯ãã§ããããã¡ãããã®åæ°ã¯éã¿ W0ãW1ãW2 ã®åæå€ã«ãã£ãŠå€åããã
Â
ãã¿ã³ã®ã¯ãªãã¯ãäœçŸåãç¹°ãè¿ããŠãããšãã2ä¹å誀差ãã®å€ã¯ã©ãã©ãå°ãããªãããåèå€ãšãªã¢ãã®ãåŸããã¯ããã - 1 ã«ããx åçããšã y åçãã¯å ±ã« 0.4 ååŸã®å€ã«è¿ã¥ããšæãããã
Â
åååæ§ããåŠç¿ãã®æŠå¿µå³ãã°ã©ãã«è¡šããšããããªã€ã¡ãŒãžã§ããã
Â
ççå€è¡šã®ããŒã¿ã倿Žããããšã«ãã£ãŠãORåè·¯ã®ã¿ãªããNANDåè·¯ïŒANDåè·¯ã®åŠå®ïŒãâŠ
Â
NORåè·¯ïŒORåè·¯ã®åŠå®ïŒããåŠç¿ãããããšãã§ããã
Â
ããªãã¡æ¬¡ã®äžçåŒã«ãããŠ
W0x + W1y + W2 > 0
éã¿W0ãšW1ãè² ã§ããã°ã䞡蟺㫠-1 ãæããããšã«ãã
- W0x - W1y - W2 < 0
ãšããäžçåŒãå®çŸå¯èœã§ãããÂ
Â
ANDãORãNANDãNOR ããããã®ççå€è¡šããŒã¿ã«ãããŠãéã¿W0ãW1ãW2ã®åæå€ããããã0.5ãšãããã¯ããã¿ã³ã100åã¯ãªãã¯ãããšããããªãã¡ãåŠç¿ãã25åç¹°ãè¿ãããšãããW0ãW1ãW2ã®å€ã¯ã次衚ã®ããã«ãªã£ãã
 | W0 | W1 | W2 |
AND | 1.27433 | 1.20832 | Â -2.17074 |
OR | 1.74447 | 1.77601 | -0.3671 |
NAND | Â -1.57819 | Â -1.61533 | 0.2447 |
NOR | Â -1.09802 | Â -1.03452 | 1.94745 |
 ããçŽããã³ã«åŸ®åŠã«å€ãéãããšãæ°ã«ãªã£ãããè«çåè·¯ãæ§æã§ããŠããã°ãããšããããšã«ããŠãæ°ã«ããªãããšã«ããã
Â
ãããïŒããããããïŒããããããïŒ
Â
åé¡ã¯XORïŒæä»çè«çåïŒåè·¯ã§ãããXORã®ççå€è¡šã¯æ¬¡ã®ããã«ãªãã
 x |  y |  t |
 0 |  0 |  0 |
 1 |  0 |  1 |
 0 |  1 |  1 |
 1 |  1 |  0 |
Â
ãããçŽäº€åº§æšäžã«ãããããããšæ¬¡ã®ããã«ãªãããããŸã§ãšéã£ãŠäžæ¬¡äžçåŒã«ããæ§æãäžå¯èœã§ãããããšã¯ããã ã¡ã«äºæ³ãããã
å®éãäžæ²Excelã·ãŒãäžã®ççå€è¡šããŒã¿ã次ã®ããã«å€æŽãããšããã¯ããã¿ã³ãã©ãã ãã¯ãªãã¯ããŠãã2ä¹å誀差ãã®å€ã¯å°ãããªããããæšå®å€ãã«æ£ããçµæã¯åŸãããªããããªãã¡XORåè·¯ããåŠç¿ãããããšã¯ã§ããªãããšããããšã ã
Â
XORåè·¯ãå®çŸããããã«ã¯ãããã²ãšå·¥å€«ãä»ãè¶³ãããšãå¿ èŠã§ããã
ãããŠãã®å·¥å€«ãä»ãè¶³ãããšããæ©æ¢°åŠç¿ã§ã§ããããšãäžæ°ã«æ¡ããã®ã§ããã
Â
远èšïŒ
ä»åã®ãšã³ããªãŒã®æåã«ã¹ã¯ãªãŒã³ã·ã§ããã瀺ããORåè·¯ãåŠç¿ãããExceã·ãŒãã®csvãã³ãã§ãããµã€ãããŒã«ã¯ã¿åºããŠç¯å²æå®ããã¥ããã£ãã®ã§ç§»åããŸããã
éã¿,W0,W1,W2,,,,,,,
,1.283922956,1.310624771,-0.000851633,,,,,,,
å ¥å,x,y,t,,,æšå®å€,,ã·ã°ã¢ã€ã颿°,,2ä¹å誀差
0,1,1,1,,,=B2*B4+C2*C4+D2,,=1/(1+EXP(-1*G4)),,=0.5*(I4-D4)^2
,,,,,,,,,,
,dW0,dW1,dW2,,æ°å€åŸ®åäœæ¥ãšãªã¢,,,,,
çµæ,=B$4*$K9,=C$4*$K9,=(K8-K4)/G7,,h,0.0001,,,,
,,,,,æšå®å€+h,=G4+G7,,=1/(1+EXP(-1*G8)),,=0.5*(I8-D4)^2
,W0-dW0,W1-dW1,W2-dW2,,,,,,æ°å€åŸ®å,=(K8-K4)/G7
æŽæ°å€,=B2-B7,=C2-C7,=D2-D7,,,,,,,
,,,,,åèå€ãšãªã¢,,,,,
index,x,y,t,,,,,,,
=A4+1,0,0,0,,åŸã,=-C2/B2,xåç,=-D2/B2,yåç,=-D2/C2
,0,1,1,,,,,,,
,1,0,1,,,,,,,
,1,1,1,,,,,,,
"=MOD(A13,4)","=INDEX(B13:B16,$A$13,1)","=INDEX(C13:C16,$A$13,1)","=INDEX(D13:D16,$A$13,1)",,,,,,,
远èšïŒ
ãã¿ãŸããã2019幎8æ3æ¥ä»æèšäº ããã以äžããã®èšäºã«ã転èŒããŸãã
ãã¿ãŸããããã©ãŠã¶ç»é¢ãããã³ãéšåãã³ããŒããŠã¡ã¢åž³ã«è²Œãä»ããæ¡åŒµåã.csvã«å€æŽããŠä¿åãšããã®ãèªåã§è©Šããšãããã«ã¯ãªãã¯ã§éãããšãæååããçºçãããšããçŸè±¡ãçãããããã調ã¹ãã®ã§ããæ¹åãããŸããã§ãããWindows10ïŒChromeã§ãã
ããã§æ¡åŒµå.txtã§ä¿åããExcelã®ãéããããããã¹ãŠã®ãã¡ã€ã«(*.*)ããæå®ããŠèªã¿èŸŒãã ãšãããæååããèµ·ããŸããã§ããããã ããããã¹ããã¡ã€ã«ãŠã£ã¶ãŒã 2 / 3ããåºåãèšå·ãã®ãâ¡ã«ã³ã(C)ãã«ãã§ãã¯ãå ¥ããå¿ èŠããããŸãããåèãŸã§ã
远èšããã
次åïŒ
ã¹ãã³ãµãŒãªã³ã¯
Â