Download the African Elephants Data Set
Download the African Elephants Data Set
Add a column after 2012 elephant population with the header “Average Population,” and use the AVERAGE formula to calculate the average elephant population for each country between 1979 and 2012.
Add a column with the header “Total Change” after the new “Average Population” column to calculate the total change in elephant population from 1979 to 2012.
In your new “Total Change” column, use Color Scales conditional formatting to display the largest changes in elephant populations, from red (largest decrease) to green (largest increase).
Add a column to the right of your “Total Change” column titled “Percent Change.” Use a formula to calculate the percent change since 1979 (this is equal to total change, divided by population in 1979).
Sort your entire sheet by percent change in decreasing order.
Add a line at the bottom for totals, and add a SUM formula to calculate the total elephant population in Africa for each of the columns.
Add three lines below your totals, and use formulas to calculate the (1) min, (2) max, and (3) range for each of the columns.
Create a new sheet (new tab) and name it “Summary.”
In cell A1, type the name of the country that had the biggest increase in elephants.
In cell A2, type the country with the largest percent decrease in elephants, and in cell B2, type the percent decrease amount.
In cell A3, type the range you calculated in the last step.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
