1. The new Country Competitiveness Index (CCI) for the future is not just about traditional economic indicators, but is also about social indicators as well as renewal resource and green cover competitiveness.

This new CCI uses GDP and GDP Growth rate from the previous indexes. However, adds Infant Mortality Rate (IMR), Renewable Energy Share and the Overall Green Cover Percentage within the country.

Hint: Kindly check for meaning of variables and meaning of their high or low values

1. Develop an excel based model where the CCI provides 15% weight to each of the old parameters and 20% to the new parameters and rank the countries. Which is the top ranked country among the seven countries?

b. What is the new ranking if 35% weightage is given to IMR, 35% to renewable energy source and then 10% each to the rest of the parameters?