2025_uyg5_formulsüz.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	T	U	V	W	X	Y	AA	AB	AC	AD	AE	AF	AH	AI	AJ	AK	AL	AM	AO	AP	AQ	AR	AS	AT	AV	AW	AX	AY	AZ	BA
1													(x-y)^2						x-x_ort						(x-x_ort)^2						x*y						(x-x_ort) * (y-y_ort)						(\|y-y_ort\|+\|x-y_ort\|)^2
2	id	1	2	3	4	5	6	YYYY	MM	DD	Date		1	2	3	4	5	6	1	2	3	4	5	6	1	2	3	4	5	6	1	2	3	4	5	6	1	2	3	4	5	6	1	2	3	4	5	6
3	20190102me	-0.057570596	-0.03656323	-0.052312041	-0.060075294	-0.018478965	0.124079781	2019	01	02	1/2/2019		0	0.0004413094263	0.00002765240069	0.000006273512071	0.001528155614	0.03299685946	-0.2522248638	-0.2355172636	-0.2460636286	-0.2821311013	-0.2372213696	-0.1256331944	0.06361738193	0.05546838145	0.06054730931	0.07959795832	0.05627397819	0.01578369954	0.003314373524	0.002104966943	0.003011635378	0.00345857048	0.001063845029	-0.007143346944	0.06361738193	0.05940330974	0.06206336521	0.0711604786	0.05983312764	0.03168781535	0.2544695277	0.233716517	0.2491918268	0.2570027897	0.2165581581	0.1041994208
4	20190219me	-0.022263947	-0.030209956	0.026839832	0.063375288	0.04471383	0.229361608	2019	02	19	2/19/2019		0	0.00006313905903	0.002411181112	0.007334078571	0.004486022612	0.06331541993	-0.2169182148	-0.2291639896	-0.1669117556	-0.1586805193	-0.1740285746	-0.02035136741	0.04705351192	0.05251613412	0.02785953415	0.0251795072	0.03028594477	0.0004141781555	0.000495683336	0.0006725928593	-0.0005975605971	-0.001410984053	-0.0009955063413	-0.005106494684	0.04705351192	0.04970984352	0.03620620006	0.03442069497	0.03774996773	0.004414582288	0.1882140477	0.1951717231	0.1480192125	0.1212412864	0.134585271	0.06331541993
5	20190307me	0.013320042	-0.00822596	-0.002197385	0.06208683	0.055681303	0.276681336	2019	03	07	3/7/2019		0	0.0004642302022	0.0002407905407	0.002378199612	0.001794476434	0.06935917118	-0.1813342258	-0.2071799936	-0.1959489726	-0.1599689773	-0.1630611016	0.02696836059	0.03288210146	0.04292354974	0.03839599986	0.0255900737	0.02658892285	0.0007272924728	0.0001774235189	-0.0001095701327	-0.00002926926049	0.0008269991832	0.0007416772946	0.003685407016	0.03288210146	0.03756882374	0.03553225525	0.02900785065	0.02956855862	-0.004890286789	0.1315284058	0.1476207464	0.1430245588	0.09853425444	0.1025966964	0.06935917118
6	20190323me	0.026388395	0.023982586	0.016041027	0.016383182	0.047586396	0.028916817	2019	03	23	3/23/2019		0	0.000005787916944	0.0001070680245	0.0001001042872	0.0004493552464	0.00000639291781	-0.1682658728	-0.1749714476	-0.1777105606	-0.2056726253	-0.1711560086	-0.2207961584	0.02831340396	0.03061500747	0.03158104334	0.0423012288	0.02929437928	0.04875094357	0.0006963473907	0.0006328619525	0.0004232969567	0.000432325878	0.001255728614	0.0007630683891	0.02831340396	0.02944172335	0.02990262259	0.03460768381	0.02879971517	0.03715245831	0.1132536158	0.114878666	0.1203251195	0.1200878637	0.09943537051	0.1115582202
7	20190424me	0.074893822	0.076325987	0.101799247	0.096930631	0.080793075	0.390838127	2019	04	24	4/24/2019		0	0.000002051096587	0.0007239018944	0.0004856209509	0.00003480118596	0.09982080386	-0.1197604458	-0.1226280466	-0.09195234059	-0.1251251763	-0.1379493296	0.1411251516	0.01434256438	0.01503763781	0.00845523294	0.01565630974	0.01903001753	0.01991630841	0.005609084574	0.005716344884	0.007624134685	0.007259505424	0.006050902178	0.02927136111	0.01434256438	0.01468598953	0.0110122533	0.0149850469	0.01652087321	-0.01690121107	0.05737025754	0.05668624176	0.04520533666	0.0472993262	0.05457907004	0.09982080386
8	20190510me	-0.018601084	-0.020729951	-0.012929596	-0.034838049	-0.026102858	0.290015415	2019	05	10	5/10/2019		0	0.000004532074704	0.00003216577613	0.0002636390324	0.00005627661315	0.09524414346	-0.2132553518	-0.2196839846	-0.2066811836	-0.2568938563	-0.2448452626	0.04030243959	0.04547784508	0.04826105308	0.04271711165	0.0659944534	0.05994920261	0.001624286637	0.000346000326	0.0003855995599	0.0002405045013	0.0006480254758	0.0004855414543	-0.005394601096	0.04547784508	0.04684878542	0.04407586852	0.05478398971	0.05221456262	-0.008594710934	0.1819113803	0.1837318815	0.1771056454	0.1960254981	0.1883668308	0.09524414346
9	20190611me	0.17999627	0.251887311	0.271573019	0.223447084	0.511383858	0.32257017	2019	06	11	6/11/2019		0	0.005168321776	0.008386300957	0.001887973237	0.1098177335	0.02032731696	-0.01465799782	0.05293327741	0.07782143141	0.001391276706	0.2926414534	0.07285719459	0.0002148569002	0.002801931858	0.006056175187	0.000001935650872	0.08563902025	0.005308170803	0.03239865721	0.04533877644	0.04888213045	0.04021964166	0.09204718698	0.05806142741	0.0002148569002	-0.0007758958651	-0.001140706372	-0.00002039333093	-0.004289537787	-0.0010679406	0.0008594276008	0.005168321776	0.008386300957	0.001887973237	0.1098177335	0.02032731696
10	20190627me	0.425154533	0.453188414	0.51878479	0.543914803	0.536696973	0.366908491	2019	06	27	6/27/2019		0	0.0007858984839	0.008766625026	0.01410400173	0.01244171592	0.003392601409	0.2305002652	0.2542343804	0.3250332024	0.3218589957	0.3179545684	0.1171955156	0.05313037225	0.06463512018	0.1056465827	0.1035932131	0.1010951076	0.01373478887	0.1807563769	0.1926751085	0.2205637051	0.2312478441	0.2281791509	0.1559928081	0.05313037225	0.0586010921	0.07492023935	0.07418858386	0.07328861233	0.02701359742	0.212521489	0.2391546555	0.3076153103	0.3361225856	0.3278054529	0.1622111779
11	20190713me	0.494656476	0.519962349	0.561108242	0.552138355	0.58321526	0.41389219	2019	07	13	7/13/2019		0	0.0006403872083	0.004415837205	0.003304166413	0.007842658224	0.006522869893	0.3000022082	0.3210083154	0.3673566544	0.3300825477	0.3644728554	0.1641792146	0.09000132491	0.1030463386	0.1349509115	0.1089544883	0.1328404623	0.0269548145	0.2446850292	0.2572027432	0.2775558256	0.2731188129	0.2884912053	0.2047344521	0.09000132491	0.09630320347	0.1102078075	0.09902549319	0.1093426614	0.04925412691	0.3600052996	0.391012958	0.444163843	0.4322882286	0.4741192809	0.269610313
12	20190729me	0.538143415	0.536332092	0.541827038	0.570917826	0.569693457	0.32273386	2019	07	29	7/29/2019		0	0.00000328089101	0.00001356907841	0.001074162016	0.0009954051502	0.04640127639	0.3434891472	0.3373780584	0.3480754504	0.3488620187	0.3509510524	0.07302088459	0.1179847942	0.1138239543	0.1211565192	0.1217047081	0.1231666412	0.005332049586	0.2895983351	0.2886235836	0.2915806526	0.3072356686	0.3065767825	0.1736771016	0.1179847942	0.1158857016	0.1195601396	0.1198303173	0.1205478777	0.02508188137	0.4719391769	0.4694537786	0.4770138841	0.5180439569	0.5162829701	0.2223770759
13	20190814me	0.491042936	0.484550458	0.490628873	0.542714057	0.517452971	0.291618627	2019	08	14	8/14/2019		0	0.00004215227058	0.000000171448168	0.002669904745	0.0006974899487	0.03977005502	0.2963886682	0.2855964244	0.2968772854	0.3206582497	0.2987105664	0.04190565159	0.08784624262	0.08156531764	0.08813612259	0.1028217131	0.08922800249	0.001756083635	0.241123165	0.2379350795	0.2409198423	0.266495904	0.2540916261	0.1431972668	0.08784624262	0.08464754387	0.08799106324	0.09503947157	0.08853442695	0.01242036026	0.3513849705	0.3437299351	0.3508942476	0.4153138142	0.3833930008	0.1547266041
14	20190830me	0.415170486	0.410323713	0.40747052	0.492292856	0.425217286	0.25267492	2019	08	30	8/30/2019		0	0.00002349120851	0.0000592894764	0.005947859954	0.0001009381902	0.02640480897	0.2205162182	0.2113696794	0.2137189324	0.2702370487	0.2064748814	0.002961944588	0.04862740248	0.04467714137	0.04567578207	0.07302806249	0.04263187665	0.000008773115744	0.1723665324	0.1703542953	0.1691697338	0.2043854643	0.1765376673	0.1049031693	0.04862740248	0.04661044234	0.04712849073	0.05959165199	0.04553106	0.000653156819	0.1945096099	0.1902579329	0.1877770299	0.2684844033	0.2034724775	0.07758278815
15	20190915me	0.258555869	0.257986143	0.19375404	0.380200551	0.189337056	0.219516893	2019	09	15	9/15/2019		0	0.0000003245877151	0.004199277042	0.01479742866	0.004791244073	0.001524041647	0.06390160118	0.05903210941	0.000002452411765	0.1581447437	-0.02940534859	-0.03019608241	0.004083414633	0.003484789942	0	0.02500975996	0.0008646745256	0.000911803393	0.06685113739	0.06670383139	0.05009624418	0.09830308386	0.04895420705	0.05675738103	0.004083414633	0.003772246312	0.0000001567130385	0.01010570234	-0.001879048858	-0.001929578015	0.01633365853	0.0161883575	0.004199277042	0.06222424701	0.004791244073	0.00787908788
16	20191001me	0.171286355	0.16830691	0.11905189	0.251529313	0.140503032	0.212367734	2019	10	01	10/1/2019		0	0.000008877092508	0.002728439334	0.006438932309	0.0009476129749	0.001687679701	-0.02336791282	-0.03064712359	-0.07469969759	0.02947350571	-0.07823937259	-0.03734524141	0.0005460593497	0.0009392461842	0.00558004482	0.0008686875386	0.006121399423	0.001394667056	0.02933901541	0.02882867714	0.02039196429	0.0430835392	0.02406625222	0.03637569508	0.0005460593497	0.0007161593123	0.001745576021	-0.0006887343119	0.001828290838	0.0008726803457	0.002184237399	0.002471608136	0.009795118431	0.006438932309	0.006009218407	0.001687679701
17	20191017me	0.161657558	0.14322561	0.108488013	0.137655246	0.129492842	0.197611285	2019	10	17	10/17/2019		0	0.0003397367071	0.002827000516	0.0005761109813	0.001034568955	0.001292670485	-0.03299670982	-0.05572842359	-0.08526357459	-0.08440056129	-0.08924956259	-0.05210169041	0.001088782859	0.003105657196	0.007269877152	0.007123454747	0.007965484422	0.002714586144	0.02613316606	0.02315350236	0.01753790725	0.02225301091	0.02093349662	0.03194535777	0.001088782859	0.001838854622	0.002813417429	0.00278494083	0.002944941919	0.00171918436	0.004355131437	0.007127642702	0.01419981214	0.008099231715	0.009635019594	0.001292670485
18	20191102me	0.081881769	0.07882803	-0.010725544	-0.068970669	-0.057401789	0.17513225	2019	11	02	11/2/2019		0	0.00000932532188	0.008576114421	0.02275645805	0.01939990953	0.008695652207	-0.1127724988	-0.1201260036	-0.2044771316	-0.2910264763	-0.2761441936	-0.07458072541	0.01271763649	0.01443025674	0.04181089734	0.0846964099	0.07625561565	0.005562284603	0.006704624095	0.006454578543	-0.0008782265162	-0.005647440387	-0.004700160027	0.01434013844	0.01271763649	0.0135469096	0.02305939708	0.03281978296	0.03114147075	0.008410654769	0.05087054596	0.0522573824	0.1012208928	0.1416750296	0.133099875	0.01750183913
19	20191118me	0.075410254	0.073048065	0.014575024	0.005246714	-0.011162849	0.130201078	2019	11	18	11/18/2019		0	0.000005579936872	0.003700925209	0.004922922345	0.007494902163	0.003002034395	-0.1192440138	-0.1259059686	-0.1791765636	-0.2168090933	-0.2299052536	-0.1195118974	0.01421913483	0.01585231293	0.03210424094	0.04700618294	0.05285642563	0.01428309362	0.005686706408	0.005508573136	0.001099106262	0.0003956560354	-0.0008417932785	0.009818496363	0.01421913483	0.01501353306	0.02136573263	0.02585318652	0.02741482524	0.01425107835	0.05687653933	0.05800882686	0.08959441257	0.09526579021	0.1056647387	0.03374466263
20
21												sum_sq	0	0.00800842526	0.04721630946	0.08904783641	0.1739132663	0.5197637979	0.00	0.00	0.00	0.00	0.00	0.00	0.6621468303	0.6931838306	0.7979433848	0.929128147	0.9400871554	0.1651778241	1.306281658	1.332181545	1.347591627	1.492305627	1.44293781	1.005878688	0.6621468303	0.6738182657	0.7064438789	0.7574957475	0.7190923855	0.1795478492	2.648587321	2.706637175	2.877731828	3.126035211	3.070212408	1.512438395
22
23	n	17	17	17	17	17	17
24	ave	0.1947	0.1990	0.1938	0.2221	0.2187	0.2497
25	variance	0.0414	0.0433	0.0499	0.0581	0.0588	0.0103
26	sum_sq/n	0.0000	0.0005	0.0028	0.0052	0.0102	0.0306
27	Magnitude	1.1429	1.1688	1.1984	1.3294	1.3242	1.1069
28	Cor	1.0000	0.9946	0.9719	0.9658	0.9114	0.5429
29	Min Dist	0.0000	0.0895	0.2173	0.2984	0.4170	0.7209
30	Ort_Min _Dist	0.0000	0.0217	0.0527	0.0724	0.1011	0.1749
31	Cov	0.0414	0.0421	0.0442	0.0473	0.0449	0.0112
32	Cov Ratio	1.0000	0.9946	0.9719	0.9658	0.9114	0.5429
33	Cosine Sim	1.0000	0.9973	0.9839	0.9821	0.9534	0.7951
34	NSE	1.0000	0.9879	0.9287	0.8655	0.7373	0.2150
35	IA	1.0000	0.9970	0.9836	0.9715	0.9434	0.6563
36	SAM	0.0000	4.2478	10.2996	10.8440	17.5602	37.3362
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100