Solve Parts a-e for Question 1 Using excel (show working)
a. How many more critical care days will Capital City Hospital need to provide in 2039/40?
b. How many more inpatient days will the population of Springfield County need in 2039/40? (hint: measure the current and forecast inpatient days, using patient county as rows in your pivot table)
c. What is the 20-year forecast percent increase in inpatient days required by the Springfield County population 80+?
d. What is the 20-year forecast percent increase in ALC days for Alliance Hospital?
e. What is the 20-year growth rate for NICU days at Healthy Children's Hospital?

Patient Neighbourhood	Age Group	Population 2019/20	Population 2039/40
1. Central Capital City	<01	16,205	22,956
1. Central Capital City	01-17	345,981	464,002
1. Central Capital City	18-59	861,965	1,147,163
1. Central Capital City	60-79	234,220	420,036
1. Central Capital City	80+	42,262	163,889
2. Eastern Capital City	<01	7,327	9,343
2. Eastern Capital City	01-17	153,096	196,682
2. Eastern Capital City	18-59	381,944	455,889
2. Eastern Capital City	60-79	116,386	190,987
2. Eastern Capital City	80+	23,625	81,286
3. Western Capital City	<01	29,349	37,021
3. Western Capital City	01-17	533,364	688,522
3. Western Capital City	18-59	1,752,651	2,157,203
3. Western Capital City	60-79	477,340	718,354
3. Western Capital City	80+	137,182	311,648
4. East Rural Springfield	<01	10,481	13,059
4. East Rural Springfield	01-17	204,612	263,130
4. East Rural Springfield	18-59	569,361	688,019
4. East Rural Springfield	60-79	172,126	252,508
4. East Rural Springfield	80+	38,257	117,452
5. West Rural Springfield	<01	1,175	1,120
5. West Rural Springfield	01-17	20,730	21,457
5. West Rural Springfield	18-59	53,624	50,533
5. West Rural Springfield	60-79	24,007	26,755
5. West Rural Springfield	80+	5,846	14,480
6. Out of County	<01	71,008	95,856
6. Out of County	01-17	1,430,651	1,905,944
6. Out of County	18-59	3,961,633	5,034,377
6. Out of County	60-79	1,128,861	1,841,684
6. Out of County	80+	266,317	779,063