Population Projection Using Newman Formula

This video tutorial guides viewers through a GIS practical interview question on population projection using Excel. It explains how to project the population of localities from 2015 to 2025 using a 3% growth rate and the Newman formula. The tutorial provides a step-by-step demonstration of implementing the formula in Excel, verifying the calculations, and ensuring accuracy. The video concludes with a summary of the process and encourages viewers to subscribe for more content.

What is the main topic of the GIS practical question discussed in the tutorial?

• Land use analysis

• Population projection

• Climate change impact

• Urban planning

What year is the base population census data from?

• 2025

• 2020

• 2015

• 2010

What is the growth rate used for the population projection?

• 4%

• 3%

• 2%

• 5%

Which formula is used for the population projection in the tutorial?

• Newton's formula

• Newman formula

• Euler's formula

• Lagrange formula

In the Newman formula, what does 'Po' represent?

• Growth rate

• Future population

• Base population

• Intermediary year

What is the intermediary year between the base year and the future year?

• 20 years

• 10 years

• 5 years

• 15 years

What is the first step in applying the Newman formula in Excel?

• Find the base population

• Calculate the growth rate

• Copy the formula into Excel

• Determine the future year

How do you calculate the future population for all localities in Excel?

• Manually enter each value

• Use the drag or double-click method

• Use a separate formula for each locality

• Recalculate each time

What is the purpose of using the 'sum' function in Excel during the tutorial?

• To find the average population

• To calculate the total population

• To determine the growth rate

• To project future population

What is the percentage change in population from 2015 to 2025?

• 35%

• 30%

• 25%

• 20%