Revenue Forecasting
The following information is a summary of population and revenue data for a hypothetical city during the years 2012-2021. Refer to the requirements below:
				Revenue per
Population	Revenues			Capita ($)		Year
325,476	368,944,715			1,134		2012
331,718	355,602,912			1,072		2013
339,217	381,910,223			1,126		2014
343,980	396,901,834			1,154		2015
352,171	399,473,605			1,134		2016
357,669	374,671,935			1,048		2017
363,199	394,637,622			1,087		2018
367,244	409,733,642			1,116		2019
371,929	416,732,011			1,120		2020
372,783	412,541,871			1,107		2021
Average				1,110
Requirement One:
Run a correlation analysis on this data set and determine the correlation coefficient between the city's population and revenues.
Requirement Two:
Calculate the revenue per capita for each year and the average revenue per capita over the ten year period for the the city.
Requirement Three:
If the city desires to have 445,000,000 in the next year what is the estimated number of new residents needed to achieve this goal?
Residents
If the city desires to have 430,000,000 in the next year what is the estimated number of new residents needed to achieve this goal?
Residents
If the city desires to have 420,000,000 in the next year what is the estimated number of new residents needed to achieve this goal?
Residents