Basic Excel Homework

We're the ideal place for homework help. If you are looking for affordable, custom-written, high-quality and non-plagiarized papers, your student life just became easier with us. Click either of the buttons below to place your order.

Order a Similar Paper Order a Different Paper

merge the two excel datasets then

  • Go to the GINI coefficient dataset and delete all irrelevant columns as well as all data preceding the year 1990
  • Use the V-Look up or Match-Index combination to merge each country with its appropriate geographic region. There may be countries/country codes that are misspelled and some entries that are not countries that need to be removed. You need to take care of both issues.Feel free to remove any entries that give you a lot of trouble, but try to avoid that as much as possible.
  • Once you have every country matched with its corresponding region, create a list of GINI coefficients averaged out for each year for a given region. You can do that using filters and sorting functions. Feel free to use any other method. Ignore the missing values in the average.
  • Finally, you will end-up with a list of the world regions and a GINI coefficient average for each year. Graph that on one graph.


  • A sheet showing the following after the merge:(4 – 6 pages maximum) (5 pts for organization)
    • A column numbering the rows. 1,2,3,….,etc.(2 pts)
    • The country Code(2 pts)
    • The country name (abbreviated if necessary) (1 pts)
    • Region (5 pts)
    • The country data for the following years: 1990, 2000, 2010, and 2014(10 pts)
  • One sheet showing the aggregated averages over all years between 1990 – 2014 for the different World Regions. For submission, you will need to transpose this so that the Years are on the rows and the regions are the columns. (Less than 4 pages). (20 pts)
  • One sheet displaying the graph of all the trends from 1990 – 2014 for all world regions(10 pts)

Do you need academic writing help? Our quality writers are here 24/7, every day of the year, ready to support you! Instantly chat with a customer support representative in the chat on the bottom right corner, send us a WhatsApp message or click either of the buttons below to submit your paper instructions to the writing team.

Order a Similar Paper Order a Different Paper