India China Population Analysis

	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	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN
1		Crude death rate (deaths per 1,000 population)				https://population.un.org/wpp/Download/Standard/Population/
2		1950-1955	1955-1960	1960-1965	1965-1970	1970-1975	1975-1980	1980-1985	1985-1990
3	India	26.8	23.8	21.1	18.5	16.1	14	12.7	11.6
4	China	22.5	21.2	20.7	12.8	9.2	7.2	6.6	6.7
5	India - China	4.3	2.6	0.4	5.7	6.9	6.8	6.1	4.9
6
7		Population (thousands)
8		Sum	1950	1951	1952	1953	1954	1955	1956	1957	1958	1959	1960	1961	1962	1963	1964	1965	1966	1967	1968	1969	1970	1971	1972	1973	1974	1975	1976	1977	1978	1979	1980	1981	1982	1983	1984	1985	1986	1987
9	China		554,419.28	569,611.08	582,029.30	592,567.86	601,971.22	610,834.40	619,597.55	628,551.41	637,853.61	647,555.96	657,686.14	668,334.90	679,732.32	692,280.49	706,460.95	722,562.18	740,745.64	760,771.06	782,008.73	803,577.22	824,788.46	845,481.58	865,686.53	885,145.93	903,613.54	920,945.08	937,018.25	951,927.44	966,039.82	979,880.62	993,877.31	1,008,000.15	1,022,253.40	1,037,123.83	1,053,210.74	1,070,863.39	1,090,348.06	1,111,341.73
10	India		376,325.20	382,245.30	388,538.62	395,160.09	402,077.03	409,269.06	416,728.77	424,461.11	432,481.66	440,813.90	449,480.61	458,494.96	467,852.54	477,527.97	487,484.54	497,702.37	508,161.94	518,889.78	529,967.32	541,505.08	553,578.51	566,224.81	579,411.51	593,058.93	607,050.26	621,301.72	635,771.73	650,485.03	665,502.28	680,915.80	696,783.52	713,118.03	729,868.01	746,949.07	764,245.20	781,666.67	799,181.44	816,792.74
11	Extra Deaths (millions)	153.1386903	2384002.904	2449327.644	2502725.99	2548041.798	2588476.246	1588169.44	1610953.63	1634233.666	1658419.386	1683645.496	263074.456	267333.96	271892.928	276912.196	282584.38	4118604.426	4222250.148	4336395.042	4457449.761	4580390.154	5691040.374	5833822.902	5973237.057	6107506.917	6234933.426	6262426.544	6371724.1	6473106.592	6569070.776	6663188.216	6062651.591	6148800.915	6235745.74	6326455.363	6424585.514	5247230.611	5342705.494	5445574.477
12	Potentially saved (millions)	105.7689736	1618198.36	1643654.79	1670716.066	1699188.387	1728931.229	1064099.556	1083494.802	1103598.886	1124452.316	1146116.14	179792.244	183397.984	187141.016	191011.188	194993.816	2836903.509	2896523.058	2957671.746	3020813.724	3086578.956	3819691.719	3906951.189	3997939.419	4092106.617	4188646.794	4224851.696	4323247.764	4423298.204	4525415.504	4630227.44	4250379.472	4350019.983	4452194.861	4556389.327	4661895.72	3830166.683	3915989.056	4002284.426
13
14		To check our estimation method, we pull up UN's statistics for total deaths. We find the percent difference, sum up all the deaths over these years, multiply by the percentage to see how far off our estimate might be
15		Number of deaths, both sexes combined (thousands)
16	China	1950-1955	1955-1960	1960-1965	1965-1970	1970-1975	1975-1980	1980-1985	Max Error (millions)
17		65597.2	67346.14	71538.92	49519.49	39977.03	34295.31	34314.09	7.2517636
18	5 years population x death rate	65263.47165	66661.13012	70473.04236	48763.70982	39787.38757	34241.84071	33755.47184
19	% difference	0.51%	1.02%	1.49%	1.53%	0.47%	0.16%	1.63%
20
21	India	1950-1955	1955-1960	1960-1965	1965-1970	1970-1975	1975-1980	1980-1985
22		52567.9	51127.99	49919.11	48497.97	47263.45	46274.35	46851.05	6.8500364
23	5 years population x death rate	52108.47923	50545.3571	49391.73708	48030.19007	46679.11672	45555.67184	46367.24064
24	% difference	0.87%	1.14%	1.06%	0.96%	1.24%	1.55%	1.03%
25
26		We sum up all the deaths over the years, multiply by 2% to see how far off our estimate might be
27		At most, the estimate is 7 million off
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