# Population Growth

#### dieselkhan

##### Member
is there anyone how do the growth from persious year to coming next year by city name please chek th sample excel file

#### Attachments

• 80.1 KB Views: 5

#### AliGW

##### Active Member
There are no expected results that I can see in the sample file. Please explain in more detail what you are trying to do.

#### vletm

##### Excel Ninja
dieselkhan
If Your 'data' has values from one year then challenge.

#### dieselkhan

##### Member
dieselkhan
If Your 'data' has values from one year then challenge.
what the the next year poplution so at the momnet we have polution for 2015 so i need to know wht will be growth of poplution in 2016 till 2022

#### AliGW

##### Active Member
How would you calculate it manually? With one year's data, there is no trend pattern, so how is Excel meant to work it out?

#### dieselkhan

##### Member
How would you calculate it manually? With one year's data, there is no trend pattern, so how is Excel meant to work it out?

calculation with growth and every city polpution

#### bosco_yip

##### Excel Ninja
Guessing....................

In G199, enter formula and copied down :

=IF(A199="","",VLOOKUP(A199,A\$2:G\$198,7,0)*(1+VLOOKUP(A199,A\$2:G\$198,6,0)%)^(H199-H\$2))

Regards
Bosco

#### Attachments

• 108.1 KB Views: 5

#### vletm

##### Excel Ninja
dieselkhan
what the the next year poplution so at the momnet we have polution for 2015 so i need to know wht will be growth of poplution in 2016 till 2022
Yes. After You've given every towns populations from 1900 to 2014
or from 2016 to 2018.

#### dieselkhan

##### Member
growth population prediction

#### vletm

##### Excel Ninja
dieselkhan
growth population prediction ... yes!
If You know that some town has eg 10 people in 2015.
... how many people would be there next year ... ten years later?
... ... I would guess that none!

#### dieselkhan

##### Member
dieselkhan
growth population prediction ... yes!
If You know that some town has eg 10 people in 2015.
... how many people would be there next year ... ten years later?
... ... I would guess that none!
yes

Last edited:

#### vletm

##### Excel Ninja
dieselkhan
okay ... You answered ... yes!
Then all Your sent towns would have none in 2016.
All of those would have negative growth population prediction,
from Your sent values to zero ... better?
... YES ...
Video was pure white area!
As I wrote above .. seems that I was correct ... none.

#### dieselkhan

##### Member
dieselkhan
okay ... You answered ... yes!
Then all Your sent towns would have none in 2016.
All of those would have negative growth population prediction,
from Your sent values to zero ... better?
... YES ...
Video was pure white area!
As I wrote above .. seems that I was correct ... none.
My english is not good

#### AliGW

##### Active Member
Then provide a sample showing your EXPECTED RESULTS.

#### vletm

##### Excel Ninja
dieselkhan
... no comment of that,
but at least Your given data should be better.

#### dieselkhan

##### Member
this is ythe master excel file

#### Attachments

• 53.5 KB Views: 3

#### AliGW

##### Active Member
check this video might b you get the answer wht i m looking for
We know what you are looking for, however your data sample does not include enough historical data to be able to establish trends. Do you have more than one year's data? If not, it can't be done.

#### vletm

##### Excel Ninja
dieselkhan
As written:
If You know that some town has eg 10 people in 2015.
... how many people would be there next year ... ten years later?

If You cannot give needed data then ...
If I use totally random value to prediction ...

#### dieselkhan

##### Member
We know what you are looking for, however your data sample does not include enough historical data to be able to establish trends. Do you have more than one year's data? If not, it can't be done.
no i dont have more than one year data

#### vletm

##### Excel Ninja
dieselkhan
As written:
If You cannot give needed data then ...
If I use totally random value to prediction ...

Here are the best possible Your wanted results from 2015 data.
I did same time those until 2022.

Note: no guarantee of the correctness of the figures

#### Attachments

• 74.6 KB Views: 2

#### dieselkhan

##### Member
i
dieselkhan
As written:
If You cannot give needed data then ...
If I use totally random value to prediction ...

Here are the best possible Your wanted results from 2015 data.
I did same time those until 2022.

Note: no guarantee of the correctness of the figures
f formula u used ??

#### vletm

##### Excel Ninja
dieselkhan
As written with random values.
= 2015orprevyear.value * randbetween(-15,15)/100+1
And one more time: read that note too!