ã³ã³ãã¥ãŒã¿ã®åºç€ãšãªãè«çåè·¯ãæ§æããã«ã¯ãããŸããŸãªæ¹æ³ãããã
ããã§ã¯äžçåŒãçšããŠANDåè·¯ãšORåè·¯ãæ§æããŠã¿ãã
å€æ° xãy ãšéã¿ W0ãW1ãW2 ã«ã€ããŠã次ã®äžçåŒãèããã
W0x + W1y + W2 > 0
ãã®äžçåŒãæç«ããŠããã° 'ç' ããªãã¡åŒã®å€ã '1' ãšãæç«ããŠããªããã° 'åœ' ããªãã¡åŒã®å€ã '0' ãšããã
åŒã®å€ã t ãšæžãããšããxãyãt ã®ççå€è¡šã
 x |  y |  t |
 0 |  0 |  0 |
 1 |  0 |  0 |
 0 |  1 |  0 |
 1 |  1 |  1 |
ã§ãããšããANDåè·¯ãæ§æããããšèããã
ãŸãççå€è¡šã
 x |  y |  t |
 0 |  0 |  0 |
 1 |  0 |  1 |
 0 |  1 |  1 |
 1 |  1 |  1 |
ã§ãããšããORåè·¯ãæ§æããããšèããã
Â
ANDåè·¯ãŸãã¯ORåè·¯ãæ§æããéã¿ W0ïœW2 ã®çµã¿åããã¯ç¡éã«ãããããšã«ããäžæ²ã®ççå€è¡šãæºããããŠããã°ããªãã§ãããããšã«ããã
人éãæãã€ãã®ã¯ãé äœããªãããšã ãäŸãã° W0 = W1 = 0.4ãW1= - 0.5 ãšããã°ANDåè·¯ãæ§æã§ããã
 x |  y | 0.4x+0.4y-0.5 |  t |
 0 |  0 | - 0.5 |  0 |
 1 |  0 | - 0.1 |  0 |
 0 |  1 | - 0.1 |  0 |
 1 |  1 | 0.1 |  1 |
Â
W0 = W1 = 0.6ãW1= - 0.5 ãšããã°ORåè·¯ãæ§æã§ããã
 x |  y | 0.6x+0.6y-0.5 |  t |
 0 |  0 | - 0.5 |  0 |
 1 |  0 | 0.1 |  1 |
 0 |  1 | 0.1 |  1 |
 1 |  1 | 0.7 |  1 |
Â
ä»åã®ããŒãã¯ããããã®éã¿ã®å€ãã人éã決ããã®ã§ã¯ãªãã³ã³ãã¥ãŒã¿ã«æ±ºããããããšããããšã ã
èãæ¹ã¯ã7æ19æ¥ä»æãšã³ããªãŒ ã§è¿°ã¹ããã¥ãŒãã³æ³ã«ããæ¹çšåŒã®è§£æ³ãšãã£ããã§ããã
ãã ããã¥ãŒãã³æ³ã®ãããªãã£ãããããã®ã§ã¯ãªãããšããã©ãããããéã§ããããããããããªããå æžã§ããã®ïŒããšããèãæ¹ããéæã«åºãŠããã
ã©ãã«ãæ°ã«ãªããšããã«ã€ããŠã¯ãåŸæ¥ã®ãšã³ããªãŒã§ç§ãªãã®è§£éãè¿°ã¹ãããšã«ããã
Â
ããã€ãéå ·ãå°å ¥ããã
ãŸãã¯ã·ã°ã¢ã€ãé¢æ°ãšããã®ã䜿ããã·ã°ã¢ã€ãé¢æ° h(x) ã¯ã次ã®åŒã§äžããããã
e ã¯ãã€ãã¢æ°ããªãã¡èªç¶å¯Ÿæ°ã®åºã§ããã
 x â - â ã®ãšã h(x) â 0ãx = 0 ã®ãšã h(x) = 0.5ã x â â ã®ãšã h(x) â 1 ã§ããã
h(x) ã®ã°ã©ãã®æŠåœ¢ã¯ã次ã®ããã«ãªãã
 ãªãã§ãããªãã®ã䜿ãããšãããšãããããçžæã«ããã®ã¯ããžã¿ã«å€ã§ãããããžã¿ã«å€ã¯åŸ®åã«é©ããªãïŒå€§éšåã®å€ããŒãã§ãç¹å®ã®å€ã®ã¿ç¡é倧ïŒãããã§ãã®ãããªããªã ãããªåŸæãæã€é¢æ°ã«åœãŠã¯ããŠã匷åŒã«åŸ®åå¯èœã«ããŠããŸãã®ã§ããã
Â
次ã«äºä¹å誀差 E ãšãããã®ãå°å ¥ãããäºä¹å誀差ã®äžè¬çãªå®çŸ©ã¯ç¢ºçã»çµ±èšã®æç§æžã«åºãŠããããä»åã¯äžå€æ°ã®å ŽåãšããŠãããé¢æ°ã®å€ f ãšç®æšãšãªãå€ t ã«ãã
ãšå®çŸ©ããããªã t ããæåž«ããŒã¿ããšåŒã¶ããšãããã
Â
ããããçšããŠããŸã㯠AND åè·¯ãããœã³ã³ã«æ§æãããŠã¿ãããããæ£ç¢ºã«ã¯ãéã¿W0ãW1ãW2ã®å€ã Excel ã«æ±ºããããã®ã ã
Excel ã®ã·ãŒãã«ã次ã®ããã«ããŒã¿ãå ¥åããã
ã»ã«ã«å ¥åããŠããæ°åŒãšãã®æå³ã¯ã以äžã®éãã
ã»ã« | æ°åŒ | æå³ |
B2ïœD2 | (æ°å€) | éã¿W0ïœW3 |
A4 | ççå€è¡šã®è¡çªå·(0ïœ3) | |
B4ïœD4 | å€æ°x, y, t | |
G4 | =B2*B4+C2*C4+D2 | æšå®å€ |
I4 | =1/(1+EXP(-1*G4)) | ã·ã°ã¢ã€ãé¢æ° |
K4 | =0.5*(I4-D4)^2 | 2ä¹å誀差 |
G7 | (æ°å€) | 埮å°é |
G8 | =G4+G7 | æšå®å€ã®åŸ®å°å€å |
I8 | =1/(1+EXP(-1*G8)) | 埮å°å€ååŸã®ã·ã°ã¢ã€ãé¢æ° |
K8 | =0.5*(I8-D4)^2 | 埮å°å€ååŸã®2ä¹å誀差 |
K9 | =(K8-K4)/G7 | 2ä¹å誀差ã®æ°å€åŸ®å |
B7 | =B4*$K9 | éã¿W0ïœW3ã®ä¿®æ£å€ |
C7 | =C4*$K9 | |
D7 | =$K9 | |
B10 | =B2-B7 | éã¿W0ïœW3ã®æŽæ°å€ |
C10 | =C2-C7 | |
D10 | =D2-D7 | |
A13 | =A4+1 | ççå€è¡šã®æ¬¡ã®è¡çªå· |
B13ïœD16 | (æ°å€) | ççå€è¡š |
A17 | =MOD(A13,4) | è¡çªå·ã0ïœ3ã®ç¯å²ã« |
B18 | =INDEX(B13:B16,$A$13,1) | ççå€è¡šã®æ¬¡ã®è¡ãååºã |
C18 | =INDEX(C13:C16,$A$13,1) | |
D18 | =INDEX(D13:D16,$A$13,1) | |
G13 | =-C2/B2 | åŸã(-W0/W1)ïŒåèå€ |
I13 | =-D2/B2 | xåç(-W2/W0)ïŒåèå€ |
K13 | =-D2/C2 | yåç(-W2/W1)ïŒåèå€ |
D13ïœD16ã®å€ãã0 0 0 1ããšãªã£ãŠããããšããANDåè·¯ãè¡šããŠããã
B2ïœD2ã®å€ã¯åæå€ã§ãã¹ã¯ãªãŒã³ã·ã§ããã§ã¯ãããã0.5ãšãªã£ãŠãããé©åœãªå€ã§ãããæåããANDåè·¯ãæ§æããªãã»ãããããÂ
ãã®ã·ãŒãã§ã次ã®4æäœããã¯ããšããŠèšé²ããããã¯ããžã®èšé²æ¹æ³ã¯ 7æ19æ¥ä»æèšäº åç §ã
- ç¯å²B10ïœD10ããã©ãã°ããŠå³ã¯ãªãã¯ãã·ã§ãŒãã«ããã¡ãã¥ãŒã®ãã³ããŒ(C)ããéžæãã
- ã»ã«B2äžã§å³ã¯ãªãã¯ãã·ã§ãŒãã«ããã¡ãã¥ãŒã®ã貌ãä»ãã®ãªãã·ã§ã³ããããå€(V)ããéžæãã
- ç¯å²A17ïœD17ããã©ãã°ããŠå³ã¯ãªãã¯ãã·ã§ãŒãã«ããã¡ãã¥ãŒã®ãã³ããŒ(C)ããéžæãã
- ã»ã«A4äžã§å³ã¯ãªãã¯ãã·ã§ãŒãã«ããã¡ãã¥ãŒã®ã貌ãä»ãã®ãªãã·ã§ã³ããããå€(V)ããéžæãã
1.ãš2.ã§ã¯BïœDåãæäœå¯Ÿè±¡ã ãã3.ãš4.ã§ã¯AïœDåãæäœå¯Ÿè±¡ãšãªã£ãŠããç¹ãèŠæ³šæã§ããã
æåŸã«ãã¿ã³ãäœæãããã®ãã¿ã³ã«èšé²ãããã¯ããç»é²ããããã¿ã³ã®äœæãšãã¿ã³ãžã®ãã¯ãã®ç»é²ã¯ããã¯ã 7æ19æ¥ä»æèšäº åç
§ã ããã§æºåå®äºã§ããã
Â
ããšã¯ããã¿ã³2ããç¹°ãè¿ãã¯ãªãã¯ããã ãã§ããã
ãŸã確èªããŠã»ããã®ã¯ãã»ã«A4ã®å€ã0ïœ3ãç¹°ãè¿ããŠãããã©ããã§ããããããªããªãã£ãããã¯ãã®èšé²ãã©ããã§ééããŠããããã¯ãã®èšé²ãããçŽããŠããã ããããªãã
æšå®å€ïŒã»ã«G2ïŒã¯ãéã¿W0ïœW2ïŒã»ã«B2ïœD2ïŒãé©åã«æ±ããããç¶æ ã§ã¯ãx ãš yïŒã»ã«B4ãšC4ïŒãå ±ã« 1 ã®ãšãã ãæ£ããã以å€ã¯è² ã«ãªãããã¹ã¯ãªãŒã³ã·ã§ããã®ããã«W0ïœW2ã®åæå€ããã¹ãŠ0.5ãšããå Žåã«ã¯ãæåã®ãã¡ã¯ãããªããªãã¯ãã§ããã
ãã¿ã³ãã ããã60åãããã¯ãªãã¯ããé ãããããªãã¡ççå€è¡šã®ãåŠç¿ãã15åãããç¹°ãè¿ããé ãããx ãš y ãå ±ã« 1 ã®ãšãã ãæ£ããã以å€ã¯è² ã«èœã¡çãã®ã§ã¯ãªããã
Â
ã·ã°ã¢ã€ãé¢æ°ã®å€ã¯ããããã«ãããšæãã2ä¹å誀差ã®å€ã¯ããã¿ã³ãã¯ãªãã¯ããã°ããã»ã©å°ãããªãã¯ãã ã
Â
W0ãW1ãW2 ã®å€ããŸããçŽæ¥èŠ³å¯ããŠããŠããã©ã®ãããªå€åãèµ·ããŠããããããã«ãããäŸãã°
0.2x + 0.2y - 0.4 > 0
ãšã
0.3x + 0.3y - 0.6 > 0
ã¯åãã ããã ã
ããã§ãåèå€ãšãªã¢ãã«ãåŸãïŒ-W0/W1ïŒãx åçïŒ-W2/W0ïŒãyåçïŒ-W2/W1ïŒã衚瀺ããŠã¿ãã
ããã¿ã³2ããèŸæ±åŒ·ãã¯ãªãã¯ãç¶ããŠãããšïŒã ããã3ïœ400åãããïŒãåŸãã¯ããã - 1 ã«ãx åçãš y åçã¯å ±ã« 1.5 ååŸã®å€ã«è¿ã¥ããããã Excel ã®æ±ºããANDåè·¯ãæ§æããéã¿ W0ãW1ãW2 ãšããããã ã
B4ïœD4ã®ãããªæ°å€ãçŽæ¥å ¥åããŠããã»ã«ã¯ãäžæžãã§ããŒã¿æžãæããå¯èœã ãããåæå€ãããããå€ããŠè©ŠããŠã»ããã
äžçåŒãã°ã©ãã«ãããšã次ã®ãããªå€åãèµ·ããã®ã ã
ãã ããã¥ãŒãã³æ³ã®ãšããšéã£ãŠãã·ã£ãŒãã«ã¯åæããªãã
Â
ä»åãã·ãŒãã®å 容ãCSVã«ä¿åãããã®ã瀺ãããšãã£ã¿ã«ã³ããããŠæ¡åŒµåã.csvãã§ä¿åãããšã眫ç·ãåå¹ ã®ããŒã¿ã¯å€±ãããŠãããã®ã®å ¥åã®æéãå€§å¹ ã«çç¥ã§ããã¯ãã ã
éã¿,W0,W1,W2,,,,,,,
,0.5,0.5,0.5,,,,,,,
å ¥å,x,y,t,,,æšå®å€,,ã·ã°ã¢ã€ãé¢æ°,,2ä¹å誀差
1,0,0,0,,,=B2*B4+C2*C4+D2,,=1/(1+EXP(-1*G4)),,=0.5*(I4-D4)^2
,,,,,,,,,,
,dW0,dW1,dW2,,æ°å€åŸ®åäœæ¥ãšãªã¢,,,,,
çµæ,=B$4*$K9,=C$4*$K9,=$K9,,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,0,,,,,,,
,1,0,0,,,,,,,
,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)ãã«ãã§ãã¯ãå ¥ããå¿ èŠããããŸãããåèãŸã§ã
è¿œèšããã
次åïŒ
ã¹ãã³ãµãŒãªã³ã¯
Â