Classifying USA Country & Capital Names

    Code   Region      
    1   north America  
    2   central America
    3   south America  
    4   northern Europe
    5   eastern Europe 
    6   western Europe 
    7   southern Europe
    8   north Africa   
    9   west Africa    
    10  central Africa 
    11  south Africa   
    12  east Africa    
    13  west Asia      
    14  south Asia     
    15  se Asia        
    16  east Asia      
    17  Oceania        
Use these numbers to classify countries into their respective world region.

 Use this map to classify the countries into their respective world regions.
Can you find an error?!

Procedure:
1) After you have collected the numbers for all the XXs in the
USA country and capital data, you must classify each countries into its respective world regions.
2) Add the numeric code, see above, next to each country in your table.
3) Sort the whole table by the Region column and then add the totals for each region in a column to the right of your data.
4) Now calculate the percentages for each region in another columns. Look at the examples of tables provided elsewhere on this web assignment.
Use this classified information to construct
the two tables.