• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Population Growth

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.
 

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?
 

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.
 

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!
 

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
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
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 ...
would You be pleased?
 

vletm

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

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

i
dieselkhan
As written:
If You cannot give needed data then ...
If I use totally random value to prediction ...
would You be pleased?

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 ??
 
Top