ECON 3110H. Trade Report-El Salvador vs. Mexico and Spain

Please write all the contents according to the requirements in the document. / Please write all the contents according to the requirements in the file.
Note that the content of this report contains charts and references. /This report contains tables and references.
Must not plagiarism! ! ! ! / Never plagiarism.

DEPARTMENT OF ECONOMICS ECON 3110H – INTERNATIONAL TRADE Trade Report Due date: November 14 Instructions: Your report is not to exceed ten (10) typed, double-spaced pages, 12pt font, including tables and references. You must submit using SafeAssign via Blackboard by the due date. Trade Patterns: You are to characterize the trading patterns of an assigned country and identify the nature of its comparative advantage. You will present trade data for your country in tables, and describe the patterns of trade by item that your tables show. You will then use the theories we studied and apply them to a particular country’s bilateral trade patterns. You must use a primary source for your trade data (two are listed below) and you must present your data in appropriately formatted and properly labeled tables. Tables showing the distribution of trade by good category are most informative when exports and imports and lined up by good category in separate columns. To select your country, follow the instructions on the next page “How to Generate Country Key”, then use this key to match the key in the file “countries.xlsx” posted to Blackboard. Your report will address the following questions: 1. Show the composition of trade by good in a table for your country with the world. Show values and the distribution by percentage of the total for each good category. What are the major import and export commodities? How important is service trade? In describing these trade patterns, you should attempt to aggregate commodity groupings in a reasonable way while still showing sufficient detail – see discussion on trade data categories below. 2. Show the distribution of trade by countries of the world in a table for your chosen country. Report values and the distribution by percentage of the total for each country. Which countries are your country’s major trading partners? In your discussion, you will indicate what you consider to be ‘major.’ Usually we consider those countries whose trade makes up more than a minimum percentage of trade. 3. In well-formatted tables, show the bilateral import and export patterns between your country and two of its trading partners. Line up categories so that exports and imports of the same goods category are shown in a row. Show values and the distribution by percentage of the total with each country. Choose one of the two trading partners as one distant from your country. Do bilateral trade patterns differ for these two trading partners? Make sure to highlight differences in these trade patterns for the two countries. 4. Provide reasonable explanations for these trade patterns (in parts b. and c. above) based on the theories we have studied (factor endowments, technology, etc)? Contrast trading patterns by discussing at least two examples (i.e. Canada <-> U.S vs. Canada <-> Japan). Support your conclusions with facts and evidence from other studies where appropriate. Any information you can get on endowment differences might help. Simple data might be population density as an indicator of land abundance. Trade data are available from the UN Comtrade Database. See note on trade data at end of assignment for details on usage. An alternate source for the same data is here: Trade Map. Switch selection box between“Product” and “Service”. Other sources of data to measure endowments: • World Bank’s World Development Indicators Database. Population, geographic measures of land area, arable land, resources, national accounts, and much much more. • Penn World Table. Capital Stock (ck), labour force (emp), population (pop). ECON 3110H - TRADE REPORT How to Generate Country Key • using your sid, drop the leading “0”, then add up the next five digits. example sid “0234567”, so add up 2+3+4+5+6 = 20. • multiply the sum from above by (1 + the last digit of sid on the right). 20×(1+7) = 20×8 = 160. • divide this result by 3, and drop all digits to the right of the decimal. 160/3 = 53.33, so key = 53. • use this key to match the country key column in file “countries.xlsx” key 53 matches Kazakhstan. Notes on Using Comtrade Trade Database • Go to UN Comtrade data webpage: http://comtrade(dot)un(dot)org/data. 1. Type of product: choose “goods” or “services”. You will use both for assignment. 2. Frequency: leave as “Annual” 3. Classification: leave as “HS: As reported” 4. Select desired data – For all entry boxes, you may either click in box and type your entry, or choose from selections. Entry box has auto-complete so start typing and see what happens. – Periods: Try 2017, could use earlier year if you like. If query comes up blank, it may be that data are not yet available for 2017 for your country, so back up a year until you get results. – Reporters: * first click on the “x” in “All” to remove that box. * type in name of country. As you type the input cell will autocomplete. Click on the one you want when it comes up. * type in name of trade partner, same things happens. You may enter up to 5 reporters, but we need 3. Put selected country and two trading partners in this cell. – Partners: same process as Reporters above. Again, you want both countries listed here. – Trade Flows: Set as appropriate to “Export” and/or “Import”. For bilateral flows, with three countries entered in both Reporters and Partners entry boxes, choose “Import” as import data are more precise. – HS (as reported) commodity codes: keep totals, and add “AG2”. 5. See the results: click on “Download CSV” • Each line of the data is one bilateral trade flow by HS2 commodity code. You can delete columns that are unnecessary. The columns that are necessary are: reporter, partner, commodity code, commodity, and trade value. You will want to sort your data by reporter, partner, and commodity code. • Commodity Code: numbers from 1-99. These are the Harmonized System (HS) commodity codes. To see code definitions, go to http://www(dot)foreign-trade(dot)com/reference/hscode.htm. These 99 categories can be further aggregated into 16 as shown in the foreign-trade reference webpage. 2