exercicio VPA

Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original

Plan1
	captura	N
	idade	1974	1975	1976	1977	1978	1979	1980	idade	1974	1975	1976	1977	1978	1979	1980
	0	599	239	424	664	685	478	330	0	4389.6102847427	0	0	0	0	0
	1	678	860	431	1004	418	607	288	1	472.8099374733	3054.3199123915	0	0	0	0
	2	1097	390	1071	532	335	464	323	2	228.6634225513	234.7904664358	1728.5755756111	0	0	0
	3	275	298	159	269	203	211	243	3	113.5508951536	113.5508951536	116.5934951023	465.1011773187	0	0
	4	40	54	75	32	69	86	80	4	33.8326234594	56.3877057656	56.3877057656	57.8986161855	141.6881896899	0
	5	6	9	13	18	8	25	31	5	44.8020895964	16.8007835986	28.0013059977	28.0013059977	18.9272547623	54.4434525444
	6	1	8	3	5	5	3	8	6	2.1160163089	22.2480592727	8.3430222273	13.9050370454	13.9050370454	8.3430222273	22.2480592727
	7	6	0	1	0	1	1	1	7
	Ft	0.5
	M	0.2
	F	cel. Objetivo	F Final	cel. Variavel
	idade	1974	1975	1976	1977	1978	1979	1980	idade	1974	1975	1976	1977	1978	1979	1980
	0	0.196099686	0	0.1626834965	0.5	0.5	0.5	0.5	0.5	0.16268349649991515
	1	0.7241090768	0.4974995538	1	0.5	0.3692592506	0.5	0.5	0.5	0.5	0.36925925058109499
	2	0.7241090768	0.7241090768	2.3027004099	2	0.5	0.5	1.1127980141	0.5	0.5	0.5	1.1127980140897309
	3	0.7241090768	0.7241090768	0.7241090768	1.8985000792	3	0.5	0.5	0.5	0.9886261716	0.5	0.5	0.98862617161169331
	4	0.7241090768	0.7241090768	0.7241090768	1.6906997568	1.2673993524	4	0.5	0.5	0.5	0.91809054999068607	0.7564662009	0.5	0.7564662009081633
	5	0.7241090768	0.7241090768	0.7241090768	0.7241090768	0.958899533	1.1237002993	5	0.5	0.5	0.5	0.5	0.61917740612707761	0.6949078139	0.69490781392146084
	6	0.5	0.5	0.5	0.5	0.5	0.5	0.5	6	0.5	0.5	0.5	0.5	0.5	0.5	0.5
	7	7
	C(y;a)/N(y+1;a+1)
	idade	1974	1975	1976	1977	1978	1979	1980
	0	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!
	1	0	0.1961156713	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!
	2	0.0043732399	2.8876811324	0.4975194676	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!
	3	0.0176132473	9.6608661562	3.3449550479	2.3027247666	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!
	4	0.0886718112	4.8769496163	5.2848399479	2.7461796235	1.8985350902	ERROR:#DIV/0!	ERROR:#DIV/0!
	5	0.0892815499	2.3808413319	1.9284814788	2.6784464984	1.6906836412	1.2673700284	ERROR:#DIV/0!
	6	2.3629307482	0.2696864444	1.0787457776	0.9349130072	1.2944949331	0.9588851356	1.1236935183
Plan2
Plan3