## Find Online Tutors for Homework Help

Since the CPI for years 1985 to 2009 has been calculated. The next task was to calculate the inflation rate. The inflation rate for each year has been calculated and is enlisted in the following table.The annual real GDP of China has been found to be increasing successively during the period 2000-2007. However, it remained stagnant during the period 1995-1999 while declined during 1987-1989 and after 2007.The last task involving this data file was to calculate the real GDP Index for the period 1985 to 2009. The values of GDP Index provide the relative annual GDP as compared to that of year 1985.Using the excel file Population-China.xls that provided a national sample survey on Chinas population by Age and Gender in 2009, certain percentages were to be calculated. It also provides the data of national sample survey on Chinas population by Age in 1995. So in order to calculate the percentages of each group the figures for the male, female and population in each group was divided by the total population in 2009 and multiplied with 100. The percentages were thus found to be.The overall results show that during 2009, male constituted 51% of the total population of China, while female constituted 49%. Thus it can be said that most of the population reported in 2009 were male and were found to be between 40-49 years of age depicting the aging population.When the male female ratio was calculated using the total population in each group the results showed that below 19 years, the majority of population were male, while the ratio was equal for the age groups 40-49, 50-59 and 70-79. However the ratio of female was found to be greater for the age groups 30-39, 80-89 and 90+. Thus most of the aging population of China was consisting of females in 2009.The results for the proportion of population of each gender in each age group showed that majority of the males in China were found to be 0-59 years and the similar was seen for the females.