SOLUTION AND EXPLANATION SHOULD BE IN EXCELL

QB. Although millions of elephants once roamed across Africa, by the mid-1980s elephant populations in African nations had been devastated by poaching. Elephants are important to African ecosystems. In tropical forests, elephants create clearings in the canopy that encourage new tree growth. In savannas, elephants reduce bush cover to create an environment that is favorable to browsing and grazing animals. In addition, the seeds of many plant species depend on passing through an elephant's digestive tract before germination.

1. Use the geometric mean calculation to find the mean annual change in elephant population for each country in the 10-year period from 1979 to 1989, 18-year period from 1989 to 2007, and 5-year period from 2007 to 2012. High light those countries that have drop in the population based on the mean annual change. For each of these 3 intervals, list the largest average and smallest average changes among countries in elephant population.

2. Make a multiple boxplot graph that includes boxplots of the elephant population observations in each year (1979, 1989, 2007, 2012). Use these boxplots and the results of your analyses in part 1 above to comment on how the populations of elephants have changed during these time periods. Below is the sheet for QB

Country	1979 Elephant Population	1989 Elephant Population	2007 Elephant Population	2012 Elephant Population
Angola	12,400	12,400	2,530	2,530
Botswana	20,000	51,000	175,487	175,454
Cameroon	16,200	21,200	15,387	14,049
Cen African Rep	63,000	19,000	3,334	2,285
Chad	15,000	3,100	6,435	3,004
Congo	10,800	70,000	22,102	49,248
Dem Rep of Congo	377,700	85,000	23,714	13,674
Gabon	13,400	76,000	70,637	77,252
Kenya	65,000	19,000	31,636	36,260
Mozambique	54,800	18,600	26,088	26,513
Somalia	24,300	6,000	70	70
Tanzania	316,300	80,000	167,003	117,456
Zambia	150,000	41,000	29,231	21,589
Zimbabwe	30,000	43,000	99,107	100,291