| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Po | 175,291 | Year 2000 | ||||||||
2 | Pn | 223,069 | Year 2007 | ||||||||
3 | t | 7 | |||||||||
4 | |||||||||||
5 | Geometric Method | Exponential Method | |||||||||
6 | |||||||||||
7 | Population Growth Rate = POWER(10,log(Pn/Po)/t)-1) | Population Growth Rate = 1/t * LN (Pn/Po) | |||||||||
8 | |||||||||||
9 | PGR | 0.0350330767 | PGR | 0.03443338437 | |||||||
10 | |||||||||||
11 | YEAR | POPULATION | YEAR | POPULATION | |||||||
12 | 2000 | 175,291 | 1.035033077 | 2000 | 175,291 | 1.034433384 | |||||
13 | 2001 | 181,432 | 1.035033077 | 2001 | 181,327 | 1.034433384 | |||||
14 | 2002 | 187,788 | 1.035033077 | 2002 | 187,571 | 1.034433384 | |||||
15 | 2003 | 194,367 | 1.035033077 | 2003 | 194,029 | 1.034433384 | |||||
16 | 2004 | 201,176 | 1.035033077 | 2004 | 200,710 | 1.034433384 | |||||
17 | 2005 | 208,224 | 1.035033077 | 2005 | 207,621 | 1.034433384 | |||||
18 | 2006 | 215,519 | 1.035033077 | 2006 | 214,771 | 1.034433384 | |||||
19 | 2007 | 223,069 | 1.035033077 | 2007 | 222,166 | 1.034433384 | |||||
20 | 2008 | 230,884 | 1.035033077 | 2008 | 229,816 | 1.034433384 | |||||
21 | 2009 | 238,972 | 1.035033077 | 2009 | 237,729 | 1.034433384 | |||||
22 | 2010 | 247,344 | 1.035033077 | 2010 | 245,915 | 1.034433384 | |||||