Projeta alfa 2015

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

LOGISTIC
	Tabela 2 - Projeção da Esperança de Vida ao Nascer (Modelo Logístico)
	Alagoas- 2000 - 2035 (Feminina)
	Interpolation and Extrapolation of	 Index
	Using a Logistic Function.
	-	-	-	-	-	-	-	-
	Item or	Index	 |	 |
	year	value	 |	Year	Index	 |	Year	Index
	-	-	 |	-	-	 |	-	-
	Asymptotes:	 |	1995.00	-0.05	 |	1995.00	-0.05
	 |	1996.00	-0.04	 |	2000.00	0.03
	Lower	-0.110	 |	1997.00	-0.02	 |	2005.00	0.17
	Upper	0.438	 |	1998.00	-0.01	 |	2010.00	0.31
		 |	1999.00	0.01	 |	2015.00	0.38
	Input values	 |	2000.00	0.03	 |	2020.00	0.42
		 |	2001.00	0.06	 |	2025.00	0.431
	1995.00	-0.030	 |	2002.00	0.08	 |	2030.00	0.436
	2001.00	0.000	 |	2003.00	0.11	 |	2035.00	0.437
	2011.00	0.344	 |	2004.00	0.14	 |	2040.00	0.438
	 |	2005.00	0.17	 |	2045.00	0.438
		 |	2006.00	0.20	 |	2050.00	0.438
		 |	2007.00	0.23	 |	2055.00	0.438
		 |	2008.00	0.26	 |	2060.00	0.438
		 |	2009.00	0.28	 |	2065.00	0.438
		 |	2010.00	0.31	 |	2070.00	0.438
		 |	2011.00	0.33	 |	2075.00	0.44
		 |	2012.00	0.34	 |	2080.00	0.44
	 |	2013.00	0.36	 |	2085.00	0.44
	 |	2014.00	0.37	 |	2090.00	0.44
	 |	2015.00	0.38	 |	2095.00	0.44
	 |	2016.00	0.39	 |	2100.00	0.44
	 |	2017.00	0.40	 |	2105.00	0.44
	 |	2018.00	0.41	 |	2110.00	0.44
	-	-	 |	2019.00	0.41	 |	2115.00	0.44
	 |	2020.00	0.42	 |	2120.00	0.44
	 |	2021.00	0.42	 |	2125.00	0.44
	 |	2022.00	0.43	 |	2130.00	0.44
	Beginning date for	 |	2023.00	0.43	 |	2135.00	0.44
	results:	1995.00	 |	2024.00	0.43	 |	2140.00	0.44
	-	-	-	-	-	-	-	-
	Source:
	[FILE NAME] [DISKNAME] [DATE] [INITIALS]
	U.S. BUREAU OF THE CENSUS INTERNATIONAL PROGRAMS CENTER
	POPULATION ANALYSIS SPREADSHEETS (PAS)
	DOCUMENTATION: LOGISTIC
	**** D E S C R I P T I O N ****
	This spreadsheet interpolates and extrapolates any desired index. It 
	fits a logistic function to 2 to 17 index values, given the values of 
	upper and lower asymptotes. 
	PRESS PgDn FOR FURTHER INSTRUCTIONS
	**** I N P U T ****
	CELL	ITEM
	-----------	-	-	-	-	-	-
	A1	Table number. Type both "Table" and the number.
	A2	Country name and year (e.g. Burundi: 1975). 
	 Type over "COUNTRY: YEAR".
	E3	Index name.
	B11	Lower asymptote.
	B12	Upper asymptote.
	A16-A32	Dates of index.
	B16-B32	Index values.
	C38	Beginning date for displaying the results (e.g. 1960.50).
	A40-I46	Sources of the input data.
	A47	Filename, disk name, date, and initials. Type all of these 
	 into the same cell.
	PRESS PgDn FOR FURTHER INSTRUCTIONS
	**** R E S U L T S ****
	 
	CELL	ITEM
	-----------	-	-	-	-	-	-
	A1-I48	Interpolation and extrapolation of index using 
	 a logistic function.
	**** G R A P H S ****
	NAME	ITEM
	-----------	-	-	-	-	-	-
	GRAPH1	Index.
	GRAPH2	Input/output values.
	PRESS PgDn FOR HELP SCREEN
	DATA USED FOR CALCULATION AND ESTIMATION PURPOSES:
	-	-	-	-	-	-	-	-
	Difference between the upper and lower asymptotes:	0.548
	-	-	-	-	-	-	-	-
	Logit(Index)	
	Year	x
	Year	squared	Logit(Index)	year
	-	-	-	-	-	-	-	-
	1995.0	3.98E+06	-1.7664	-3524.05
	2001.0	4.00E+06	-1.3817	-2764.86
	2011.0	4.04E+06	1.5748	3166.93
	0.0	0.00E+00	0.0000	0.00
	0.0	0.00E+00	0.0000	0.00
	0.0	0.00E+00	0.0000	0.00
	0.0	0.00E+00	0.0000	0.00
	0.0	0.00E+00	0.0000	0.00
	0.0	0.00E+00	0.0000	0.00
	0.0	0.00E+00	0.0000	0.00
	0.0	0.00E+00	0.0000	0.00
	0.0	0.00E+00	0.0000	0.00
	0.0	0.00E+00	0.0000	0.00
	0.0	0.00E+00	0.0000	0.00
	0.0	0.00E+00	0.0000	0.00
	0.0	0.00E+00	0.0000	0.00
	0.0	0.00E+00	0.0000	0.00
	-	-	-	-	-	-	-	-
	6007.0	1.20E+07	-1.5734	-3121.98	Total
	-	-	-	-	-	-	-	-
	Number of input values	3.0
	-	-	-	-	
	Item	Value
	-	-	-	-	
	Slope	0.2177		
	Intercept	-436.408		
	-	-	-	-	
	Interpolated/Extrapolated Values of Logit(Index)
	-	-	-	-	-
	Year	Logit(Index)	Year	Logit(Index)
	-	-	-	-	-
	1995.00	-2.1208	1995.00	-2.1208
	1996.00	-1.9031	2000.00	-1.0324
	1997.00	-1.6855	2005.00	0.0560
	1998.00	-1.4678	2010.00	1.1445
	1999.00	-1.2501	2015.00	2.2329
	2000.00	-1.0324	2020.00	3.3214
	2001.00	-0.8147	2025.00	4.4098
	2002.00	-0.5970	2030.00	5.4982
	2003.00	-0.3793	2035.00	6.5867
	2004.00	-0.1616	2040.00	7.6751
	2005.00	0.0560	2045.00	8.7635
	2006.00	0.2737	2050.00	9.8520
	2007.00	0.4914	2055.00	10.9404
	2008.00	0.7091	2060.00	12.0289
	2009.00	0.9268	2065.00	13.1173
	2010.00	1.1445	2070.00	14.2057
	2011.00	1.3622	2075.00	15.2942
	2012.00	1.5799	2080.00	16.3826
	2013.00	1.7975	2085.00	17.4710
	2014.00	2.0152	2090.00	18.5595
	2015.00	2.2329	2095.00	19.6479
	2016.00	2.4506	2100.00	20.7364
	2017.00	2.6683	2105.00	21.8248
	2018.00	2.8860	2110.00	22.9132
	2019.00	3.1037	2115.00	24.0017
	2020.00	3.3214	2120.00	25.0901
	2021.00	3.5390	2125.00	26.1786
	2022.00	3.7567	2130.00	27.2670
	2023.00	3.9744	2135.00	28.3554
	2024.00	4.1921	2140.00	29.4439
	-	-	-	-	-
	Titles for graphs:
	Input and Output Indexes for Graph (View 3)
	-	-	-	-
	Year	Input		Output
	-	-	-	-
	1995.0	-0.03
	2001.0	0.00
	2011.0	0.34
	1995.0	ERROR:#N/A
	1995.0	ERROR:#N/A
	1995.0	ERROR:#N/A
	1995.0	ERROR:#N/A
	1995.0	ERROR:#N/A
	1995.0	ERROR:#N/A
	1995.0	ERROR:#N/A
	1995.0	ERROR:#N/A
	1995.0	ERROR:#N/A
	1995.0	ERROR:#N/A
	1995.0	ERROR:#N/A
	1995.0	ERROR:#N/A
	1995.0	ERROR:#N/A
	1995.0	ERROR:#N/A
	1995.0	-0.05
	1996.0	-0.04
	1997.0	-0.02
	1998.0	-0.01
	1999.0	0.01
	2000.0	0.03
	2001.0	0.06
	2002.0	0.08
	2003.0	0.11
	2004.0	0.14
	2005.0	0.17
	2006.0	0.20
	2007.0	0.23
	2008.0	0.26
	2009.0	0.28
	2010.0	0.31
	2011.0	0.33
	2012.0	0.34
	2013.0	0.36
	2014.0	0.37
	2015.0	0.38
	2016.0	0.39
	2017.0	0.40
	2018.0	0.41
	2019.0	0.41
	2020.0	0.42
	2021.0	0.42
	2022.0	0.43
	2023.0	0.43
	2024.0	0.43
	-	-	-	-
	1. Index
	2. Index
	3. Input/Output Values of Index
&"Courier New,Regular"&F
&"Courier New,Regular"U.S. BUREAU OF THE CENSUS PAS: LOGISTIC.XLS VER 4.00 &D PAGE &P		
GRAPH2
GRAPH1
Plan1