03_엑셀로알아보는신경망기초_SingleNeuron_withTwoInputs

	B	C	D	E	F	G	H	I	J	K	M	N	O
1
2	Try	X1	X2	W1	W2	WB	X1W1+X2W2+1*WB	Y	Error	SumError	초기 학습계수(α)		0.25
3	0	-	-	-0.2845432606	-0.01840146786	0.6142195549					최소 에러값(Minimum Allowable Error)		0.01
4	1	1	0	-0.2845432606	-0.01840146786	0.6142195549	0.3296762944	0.5816806122	0.4183193878	0.1749911102
5	2	0	0	-0.1799634136	-0.01840146786	0.7187994019	0.7187994019	0.6723425824	-0.6723425824	0.4520445481
6	3	1	0	-0.1799634136	-0.01840146786	0.5507137563	0.3707503427	0.5916402752	0.4083597248	0.1667576648	진리표(Truth Table)
7	4	1	1	-0.07787348241	-0.01840146786	0.6528036875	0.5565287372	0.6356489772	0.3643510228	0.1327516678	X1,X2	Y
8	5	0	0	0.01321427328	0.07268628783	0.7438914432	0.7438914432	0.6778462209	-0.6778462209	0.4594754992	(0,0)	0
9	6	0	0	0.01321427328	0.07268628783	0.5744298879	0.5744298879	0.6397847191	-0.6397847191	0.4093244867	(0,1)	1
10	7	0	0	0.01321427328	0.07268628783	0.4144837082	0.4144837082	0.6021624991	-0.6021624991	0.3625996753	(1,0)	1
11	8	1	1	0.01321427328	0.07268628783	0.2639430834	0.3498436445	0.5865796626	0.4134203374	0.1709163754	(1,1)	1
12	9	1	1	0.1165693576	0.1760413722	0.3672981677	0.6599088976	0.6592399233	0.3407600767	0.1161174299
13	10	1	0	0.2017593768	0.2612313914	0.4524881869	0.6542475637	0.6579670021	0.3420329979	0.1169865717	정확도(Accuracy)
14	11	0	0	0.2872676263	0.2612313914	0.5379964364	0.5379964364	0.6313462148	-0.6313462148	0.398598043	1-2000	21.40%
15	12	0	0	0.2872676263	0.2612313914	0.3801598827	0.3801598827	0.5939116641	-0.5939116641	0.3527310648	2001-4000	40.35%
16	13	0	0	0.2872676263	0.2612313914	0.2316819667	0.2316819667	0.5576627939	-0.5576627939	0.3109877917	4001-6000	74.00%
17	14	0	1	0.2872676263	0.2612313914	0.09226626821	0.3534976596	0.5874654945	0.4125345055	0.1701847182	6001-8000	76.30%
18	15	1	0	0.2872676263	0.3643650177	0.1953998946	0.4826675209	0.6183775728	0.3816224272	0.1456356769	8001-10000	97.65%
19	16	0	1	0.3826732331	0.3643650177	0.2908055014	0.6551705191	0.6581746796	0.3418253204	0.1168445497	10001-12000	100.00%
20	17	1	0	0.3826732331	0.4498213478	0.3762618315	0.7589350646	0.6811224801	0.3188775199	0.1016828727	12001-14000	100.00%
21	18	1	1	0.4623926131	0.4498213478	0.4559812114	1.368195172	0.7970884	0.2029116	0.04117311742	14001-16000	100.00%
22	19	0	0	0.5131205131	0.5005492478	0.5067091114	0.5067091114	0.6240346971	-0.6240346971	0.3894193032	16001-18000	100.00%
23	20	1	0	0.5131205131	0.5005492478	0.3507004372	0.8638209502	0.7034583417	0.2965416583	0.08793695511	18001-20000	100.00%
24	21	1	1	0.5872559276	0.5005492478	0.4248358518	1.512641027	0.8194522772	0.1805477228	0.03259748022
25	22	1	1	0.6323928583	0.5456861785	0.4699727825	1.648051819	0.8386275744	0.1613724256	0.02604105975
26	23	0	0	0.6727359647	0.5860292849	0.5103158889	0.5103158889	0.6248805233	-0.6248805233	0.3904756684
27	24	1	1	0.6727359647	0.5860292849	0.354095758	1.612861008	0.8338082209	0.1661917791	0.02761970744
28	25	1	0	0.7142839095	0.6275772297	0.3956437028	1.109927612	0.7521156159	0.2478843841	0.06144666788
29	26	0	1	0.7762550055	0.6275772297	0.4576147988	1.085192029	0.7474752685	0.2525247315	0.06376874003
30	27	0	0	0.7762550055	0.6907084126	0.5207459817	0.5207459817	0.6273221852	-0.6273221852	0.3935331241
31	28	0	1	0.7762550055	0.6907084126	0.3639154354	1.054623848	0.7416618159	0.2583381841	0.06673861735
32	29	0	1	0.7762550055	0.7552929586	0.4284999814	1.18379294	0.765629099	0.234370901	0.05492971923
33	30	1	0	0.7762550055	0.8138856839	0.4870927067	1.263347712	0.7796018594	0.2203981406	0.04857534036
34	31	1	1	0.8313545407	0.8138856839	0.5421922418	2.187432466	0.8991152517	0.1008847483	0.01017773245
35	32	0	1	0.8565757278	0.839106871	0.5674134289	1.4065203	0.8032165234	0.1967834766	0.03872373667
36	33	1	1	0.8565757278	0.8883027401	0.6166092981	2.361487766	0.9138430153	0.08615698465	0.007423026004
37	34	0	1	0.8781149739	0.9098419863	0.6381485442	1.54799053	0.8246233125	0.1753766875	0.03075698252
38	35	0	0	0.8781149739	0.9536861581	0.6819927161	0.6819927161	0.6641833058	-0.6641833058	0.4411394637
39	36	0	1	0.8781149739	0.9536861581	0.5159468897	1.469633048	0.8130016047	0.1869983953	0.03496839985
40	37	1	1	0.8781149739	1.000435757	0.5626964885	2.441247219	0.9199190161	0.08008098386	0.006412963976
41	38	1	0	0.8981352199	1.020456003	0.5827167344	1.480851954	0.8147012289	0.1852987711	0.03433563458
42	39	1	1	0.9444599127	1.020456003	0.6290414272	2.593957343	0.9304716706	0.06952832944	0.004834188595
43	40	1	0	0.961841995	1.037838085	0.6464235096	1.608265505	0.8331704353	0.1668295647	0.02783210367
44	41	1	0	1.003549386	1.037838085	0.6881309008	1.691680287	0.8444450062	0.1555549938	0.02419735611
45	42	1	1	1.042438135	1.037838085	0.7270196492	2.807295869	0.9430688082	0.05693119185	0.003241160605
46	43	0	0	1.056670933	1.052070883	0.7412524472	0.7412524472	0.6772696712	-0.6772696712	0.4586942076
47	44	0	1	1.056670933	1.052070883	0.5719350294	1.624005913	0.8353468534	0.1646531466	0.02711065868
48	45	0	1	1.056670933	1.09323417	0.613098316	1.706332486	0.8463599855	0.1536400145	0.02360525406
49	46	1	0	1.056670933	1.131644174	0.6515083196	1.708179252	0.8465999757	0.1534000243	0.02353156745
50	47	1	1	1.095020939	1.131644174	0.6898583257	2.916523438	0.9486572311	0.05134276886	0.002636079915
51	48	0	0	1.107856631	1.144479866	0.7026940179	0.7026940179	0.6687847997	-0.6687847997	0.4472731084
52	49	0	0	1.107856631	1.144479866	0.535497818	0.535497818	0.6307644753	-0.6307644753	0.3978638233
53	50	0	0	1.107856631	1.144479866	0.3778066992	0.3778066992	0.5933439967	-0.5933439967	0.3520570984
54	51	0	0	1.107856631	1.144479866	0.2294707	0.2294707	0.5571172603	-0.5571172603	0.3103796418
55	52	0	0	1.107856631	1.144479866	0.0901913849	0.0901913849	0.5225325741	-0.5225325741	0.2730402909
56	53	0	1	1.107856631	1.144479866	-0.04044175861	1.104038107	0.7510159604	0.2489840396	0.06199305199
57	54	0	1	1.107856631	1.206725876	0.0218042513	1.228530127	0.7735612086	0.2264387914	0.05127452626
58	55	0	0	1.107856631	1.263335574	0.07841394915	0.07841394915	0.5195934487	-0.5195934487	0.269977352
59	56	1	0	1.107856631	1.263335574	-0.05148441303	1.056372218	0.7419966613	0.2580033387	0.06656572279
60	57	1	1	1.172357466	1.263335574	0.01301642166	2.448709461	0.9204670249	0.07953297506	0.006325494122
61	58	0	1	1.192240709	1.283218817	0.03289966542	1.316118483	0.7885351983	0.2114648017	0.04471736235
62	59	0	1	1.192240709	1.336085018	0.08576586584	1.421850884	0.8056284126	0.1943715874	0.037780314
63	60	1	0	1.192240709	1.384677915	0.1343587627	1.326599472	0.7902775913	0.2097224087	0.04398348872
64	61	0	1	1.244671312	1.384677915	0.1867893649	1.571467279	0.82799268	0.17200732	0.02958651815
65	62	1	1	1.244671312	1.427679745	0.2297911949	2.902142251	0.9479522345	0.05204776551	0.002708969894
66	63	0	1	1.257683253	1.440691686	0.2428031363	1.683494822	0.8433667488	0.1566332512	0.02453397538
67	64	0	1	1.257683253	1.479849999	0.2819614491	1.761811448	0.8534363861	0.1465636139	0.02148089292
68	65	0	0	1.257683253	1.516490902	0.3186023525	0.3186023525	0.578983597	-0.578983597	0.3352220056
69	66	1	0	1.257683253	1.516490902	0.1738564533	1.431539706	0.8071411065	0.1928588935	0.03719455281
70	67	0	1	1.305897976	1.516490902	0.2220711767	1.738562079	0.8505043307	0.1494956693	0.02234895515
71	68	1	0	1.305897976	1.55386482	0.259445094	1.56534307	0.8271187124	0.1728812876	0.02988793961
72	69	0	1	1.349118298	1.55386482	0.3026654159	1.856530235	0.8648920059	0.1351079941	0.01825417007
73	70	1	1	1.349118298	1.587641818	0.3364424144	3.273202531	0.9634979709	0.03650202911	0.001332398129
74	71	1	0	1.358243805	1.596767325	0.3455679217	1.703811727	0.846031913	0.153968087	0.02370617182
75	72	0	0	1.396735827	1.596767325	0.3840599435	0.3840599435	0.5948519375	-0.5948519375	0.3538488276
76	73	0	0	1.396735827	1.596767325	0.2353469591	0.2353469591	0.5585666639	-0.5585666639	0.311996718
77	74	1	0	1.396735827	1.596767325	0.09570529312	1.49244112	0.8164443887	0.1835556113	0.03369266244
78	75	1	0	1.44262473	1.596767325	0.1415941959	1.584218926	0.8298011912	0.1701988088	0.02896763452
79	76	1	0	1.485174432	1.596767325	0.1841438981	1.66931833	0.8414849157	0.1585150843	0.02512703194
80	77	1	0	1.524803203	1.596767325	0.2237726692	1.748575873	0.8517730878	0.1482269122	0.02197121749
81	78	0	0	1.561859931	1.596767325	0.2608293973	0.2608293973	0.5648401651	-0.5648401651	0.3190444121
82	79	1	0	1.561859931	1.596767325	0.119619356	1.681479287	0.8431003138	0.1568996862	0.02461751153
83	80	1	0	1.601084853	1.596767325	0.1588442775	1.75992913	0.8532007841	0.1467992159	0.0215500098
84	81	0	1	1.637784657	1.596767325	0.1955440815	1.792311407	0.857210428	0.142789572	0.02038886187
85	82	0	1	1.637784657	1.632464718	0.2312414745	1.863706193	0.8657283504	0.1342716496	0.01802887588
86	83	0	0	1.637784657	1.666032631	0.2648093869	0.2648093869	0.565818176	-0.565818176	0.3201502082
87	84	1	1	1.637784657	1.666032631	0.1233548429	3.427172131	0.9685430239	0.03145697611	0.0009895413461
88	85	0	1	1.645648901	1.673896875	0.1312190869	1.805115962	0.8587705574	0.1412294426	0.01994575546
89	86	0	1	1.645648901	1.709204235	0.1665264476	1.875730683	0.8671199738	0.1328800262	0.01765710136
90	87	1	1	1.645648901	1.742424242	0.1997464541	3.587819597	0.9730858358	0.02691416422	0.0007243722356
91	88	1	1	1.652377442	1.749152783	0.2064749952	3.60800522	0.9736094748	0.02639052523	0.0006964598222
92	89	1	0	1.658975073	1.755750414	0.2130726265	1.8720477	0.8666950356	0.1333049644	0.01777021352
93	90	1	0	1.692301314	1.755750414	0.2463988676	1.938700182	0.8742092754	0.1257907246	0.0158233064
94	91	0	1	1.723748996	1.755750414	0.2778465487	2.033596963	0.8842796611	0.1157203389	0.01339119682
95	92	0	1	1.723748996	1.784680499	0.3067766335	2.091457132	0.8900700803	0.1099299197	0.01208458724
96	93	1	1	1.723748996	1.812162979	0.3342591134	3.870171088	0.9795712367	0.02042876332	0.0004173343708
97	94	0	1	1.728856186	1.81727017	0.3393663042	2.156636474	0.8962873039	0.1037126961	0.01075632334
98	95	0	0	1.728856186	1.843198344	0.3652944782	0.3652944782	0.590321471	-0.590321471	0.3484794392
99	96	0	1	1.728856186	1.843198344	0.2177141105	2.060912454	0.8870456262	0.1129543738	0.01275869056
100	97	0	1	1.728856186	1.871436937	0.2459527039	2.117389641	0.8925819061	0.1074180939	0.01153864689