3semestre3.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA
1	PlkPa	x1	yl	X2	Y2	Y1	Y2	Lny1	Lny2	GE/RT	GE/X1X22RT	X1/X2	LNY1	LNY2	LNY1	LNY2	LNY1	LNY2	Pcal	Pcal	Pcal	x1Cal	Y2cal	x1Cal	y2Cal	x1Cal	y1Cal
2	85.265	0	0	1	1	#DIV/0!	1	-0.3416408809	0	0	#DIV/0!	0	0.033	0	-0.3416408809	0	-0.5346	0	85.265	85.265	85.265	0	0	0	0	0	0
3	83.402	0.033	0.0141	0.967	0.9859	0.7181081735	0.9972684079	-0.3311350619	-0.002735329745	-0.0135725209	-0.4398388948	0.03412616339	0.08745139346	-0.000896767542	-0.3311603926	-0.0005726032822	-0.4927518812	-0.0006999625908	84.16459878	83.57999507	83.3940375	0.02191175404	0.01943957605	0.03307126572	0.01958189369	0.03878481891	0.01962305936
4	82.202	0.0579	0.0253	0.9421	0.9747	0.7238233241	0.9974371739	-0.3232079438	-0.00256611581	-0.02113127765	-0.4112000749	0.0614584439	0.1235371774	-0.002607542715	-0.3227017332	-0.001748487934	-0.4625837601	-0.002135452853	83.37000676	82.26859004	81.96594496	0.03756531849	0.03437384021	0.05791757761	0.03486397641	0.06636816002	0.03497916728
5	80.481	0.0924	0.0416	0.9076	0.9584	0.730168268	0.9967239305	-0.3144802673	-0.003281447588	-0.03203621853	-0.4209013337	0.1018069634	0.1667752649	-0.00610055737	-0.3102709525	-0.004400220327	-0.4227423502	-0.005370252406	82.33328035	80.4088765	79.97652108	0.05841809684	0.05535270919	0.09192941978	0.05677390333	0.1023195782	0.05702548133
6	76.719	0.1665	0.0804	0.8335	0.9196	0.7465398173	0.9927170829	-0.2923063248	-0.007309566987	-0.05476152717	-0.4734238195	0.199760048	0.2350669152	-0.01604117502	-0.2811871939	-0.01387990694	-0.3446090523	-0.01696154263	80.38932867	76.32594463	75.72699873	0.1029613951	0.1011442062	0.1638153203	0.1067593328	0.1731716661	0.107272637
7	72.422	0.2482	0.1314	0.7518	0.8686	0.7726313643	0.9813348482	-0.2579532338	-0.01884154416	-0.07818906552	-0.5573648835	0.3301409949	0.2759315435	-0.02641554324	-0.2462667074	-0.02965256585	-0.2696680064	-0.03652560086	78.66149597	71.85745182	71.20851929	0.1580630114	0.1524962693	0.2434039835	0.1663963468	0.2469169361	0.1667626252
8	68.005	0.3322	0.1975	0.6678	0.8025	0.8147353286	0.9584482636	-0.2048919686	-0.04243969439	-0.09640633989	-0.6507484426	0.4974543276	0.2864179211	-0.03032001208	-0.2085076518	-0.05035519807	-0.2040977134	-0.06328550715	77.19181162	67.52624987	66.88980777	0.2307049127	0.2071821563	0.3310561696	0.2321398931	0.3264929368	0.2313379602
9	65.096	0.388	0.2457	0.612	0.7543	0.8306842299	0.9409708985	-0.1855055444	-0.06084306602	-0.1092121076	-0.751512517	0.6339869281	0.278882466	-0.02595498995	-0.1830398344	-0.06594212059	-0.1665743989	-0.08438581332	76.29245307	64.88574936	64.25917816	0.285810284	0.2459063851	0.3857943855	0.2778023211	0.3758295271	0.2753848433
10	59.651	0.5036	0.3686	0.4964	0.6314	0.8798235247	0.889856008	-0.1280339317	-0.1166956181	-0.1224055929	-0.986397572	1.014504432	0.2357192289	0.01004368189	-0.1312186344	-0.09927528573	-0.1029922984	-0.1353700361	74.3864237	60.24294952	59.51173126	0.4365014411	0.3393483374	0.5102198122	0.3756267856	0.4899989327	0.3667620955
11	56.833	0.5749	0.4564	0.4251	0.5436	0.9092056804	0.8523503192	-0.09518393938	-0.1597576639	-0.1226342297	-1.180421711	1.352387673	0.1964980292	0.05630786667	-0.101114343	-0.118377493	-0.07254660456	-0.1709573471	73.06903687	57.98486449	57.08279955	0.5521400379	0.4130521525	0.5900406264	0.4370777898	0.5645023082	0.4212432744
12	53.689	0.6736	0.5882	0.3264	0.4118	0.9447491035	0.7944209906	-0.05683588566	-0.2301417434	-0.1134029176	-1.58023563	2.06372549	0.135129605	0.159435182	-0.06359707653	-0.1398468821	-0.0403342794	-0.2243249395	70.90402491	55.56544828	54.34342121	0.7342062871	0.5529231551	0.7018720267	0.5230633549	0.6706519367	0.4915002999
13	51.62	0.7676	0.7176	0.2324	0.2824	0.9724643651	0.7356576788	-0.02792184677	-0.3069903788	-0.09277737362	-2.237870033	3.30292599	0.0778160956	0.3086153454	-0.03416529544	-0.1527032642	-0.01927196996	-0.2784745793	68.15356804	53.8213493	52.36347525	0.9117676063	0.7609709508	0.8053469948	0.6075107509	0.7719494002	0.550628009
14	50.455	0.8476	0.8238	0.1524	0.1762	0.988196433	0.6841547573	-0.01187378215	-0.3795711336	-0.06791085851	-3.44967625	5.56167979	0.03687085684	0.4817033226	-0.01539630734	-0.1572736976	-0.007857177989	-0.326234149	64.6767783	52.5219885	51.1093335	1.034821846	1.052774683	0.8854370918	0.6842872639	0.8551505236	0.5938828828
15	49.926	0.9093	0.9002	0.0907	0.0998	0.9960171622	0.6442867948	-0.003990790398	-0.4396113184	-0.04350157229	-5.815448162	10.02535832	0.01399043122	0.6479477052	-0.005645703536	-0.1570616763	-0.002665433106	-0.3636433505	60.54236324	51.47854583	50.37887342	1.083005452	1.424753402	0.9391293398	0.7491377279	0.9163328897	0.6226187672
16	49.72	0.9529	0.9502	0.0471	0.0498	0.9990956106	0.616550649	-0.0009047986296	-0.4836148041	-0.02364043989	-11.18320825	20.23142251	0.003950142108	0.784181588	-0.001559117749	-0.1552768306	-0.0006963774449	-0.3901831018	56.27133105	50.65143702	49.97234173	1.073235232	1.840846785	0.971386683	0.7993030189	0.9575366198	0.6405529356
17	49.624	1	1	0	0	1	#DIV/0!	0	-0.5311506797	0	#DIV/0!	#DIV/0!	0	0.95	0	-0.1521310821	0	-0.4188	49.624	49.624	49.624	1	2.585709659	1	0.8588756901	1	0.6578357493
18													MODELADO
19	Psat1=	49.624
20	Psat2=	85.265		X2=1-B2	1
21				y2=1-C2	1
22							Grafica Lny
23	Parametros de Margules		Pronostico				Pronóstico
24	A12	0.033	-0.3416408809	-0.5346			GE/X1X22 vs X1/X2
25	A21	0.95	-0.5311506797	-0.4188
26				R= 0.9998
27
28
29
30
31
32
33
34
35
36
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