Gravity Model of Trade Economics Worksheet Solution

Gravity Model of Trade Economics Worksheet Solution

Table of Contents

Order ID# 45178248544XXTG457	Plagiarism Level: 0-0.5%	Writer Classification: PhD competent
Style: APA/MLA/Harvard/Chicago	Delivery: Minimum 3 Hours	Revision: Permitted
Sources: 4-6	Course Level: Masters/University College	Guarantee Status: 96-99%

Instructions

Gravity Model of Trade Economics Worksheet

The Gravity Model of Trade (see Feenstra, page 192-196) predicts that trade increases with the partner country’s GDP: the bigger your partner country’s GDP, the more you trade with that country. The model also predicts that trade decreases with trade costs, which can be proxied by the distance to the partner country, along with other variables. Specifically, the further away your partner, the less you trade with that country. In this assignment you will test these hypotheses.

Step 1: Collect your data. You will need data on trade flows, GDP, and distance between your country and its 20 largest trading partners. Note that this data is helpfully collected for all trading partners for the years 1948-2019 at CEPII (http://www.cepii.fr/cepii/en/bdd_modele/presentation.asp?id=8 However, the dataset too large to open in excel, thus I would only recommend it for students more comfortable with other statistical tools. All the documentation for the dataset can be found at the CEPII link above. You can also collect your own data from the following sources:

Trade Flows. Use the United Nations Comtrade database to download total imports and exports between your country and all of its trading partners in 2019. Once you have this data, calculate total trade as the sum of exports plus imports associated with each partner. Note that this data is in nominal U.S. dollars (See helpful comtrade hints).

Nominal GDP Data. Use the World Bank’s World Development Indicators (https://databank.worldbank.org/source/world-development-indicators ) to download nominal GDP in US dollars for each partner country in your dataset.

Distance data can be found from CEPII at the website:

Gravity Model of Trade Economics Worksheet

http://www.cepii.fr/anglaisgraph/bdd/distances.htm . The file dist_cepii.xls is a spreadsheet file in Microsoft Excel format which contains distances between countries in kilometers.

The country codes are three-letter ISO codes. You can find a list of ISO codes here: https://www.iso.org/obp/ui/#search

Step 2: Choose a sample country to Visualize your data. Make a scatter plot of your data that allows you to visualize the size of the country (GDP) as a determinant of trade. It should have GDP (as a percentage of the GDP of all the partner countries in your dataset) on the horizontal axis and total trade (as a percentage of total trade of all the partner countries in your dataset) on the vertical axis.

Gravity Model of Trade Economics Worksheet

Step 3: Estimate the coefficients of the gravity equation: (see attached file)

You should estimate coefficients b and c using multiple regression analysis, which can be done in a spreadsheet package or in a statistical software package. The following website has a nice summary of doing regression analysis in excel for those of you who aren’t familiar with this tool:

https://www.excel-easy.com/examples/regression.html

Write your report. Start with a general discussion of the gravity model, how you will test it, and what data you are using. Carefully report the results from your scatter plot and interpret the coefficients you estimate. Include your scatterplot and a Table of your coefficient estimates. Conclude your report by analyzing whether the gravity model seems to fit the trade data from your country. You should also turn in the statistical package output or spreadsheet that you used to analyze your results.

1 attachments

Gravity Model of Trade Economics Worksheet

RUBRIC
Excellent Quality 95-100%	Introduction 45-41 points The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.		Literature Support 91-84  points The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.			Methodology 58-53 points Content is well-organized with headings for each slide and bulleted lists to group related material as needed. Use of font, color, graphics, effects, etc. to enhance readability and presentation content is excellent. Length requirements of 10 slides/pages or less is met.
Average Score 50-85%	40-38 points More depth/detail for the background and significance is needed, or the research detail is not clear. No search history information is provided.		83-76  points Review of relevant theoretical literature is evident, but there is little integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are included. Summary of information presented is included. Conclusion may not contain a biblical integration.			52-49  points Content is somewhat organized, but no structure is apparent. The use of font, color, graphics, effects, etc. is occasionally detracting to the presentation content. Length requirements may not be met.
Poor Quality 0-45%	37-1 points The background and/or significance are missing. No search history information is provided.		75-1 points Review of relevant theoretical literature is evident, but there is no integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are not included in the summary of information presented. Conclusion does not contain a biblical integration.			48-1 points There is no clear or logical organizational structure. No logical sequence is apparent. The use of font, color, graphics, effects etc. is often detracting to the presentation content. Length requirements may not be met
You Can Also Place the Order at www.perfectacademic.com/orders/ordernow or www.crucialessay.com/orders/ordernow Gravity Model of Trade Economics Worksheet

Gravity Model of Trade Economics Worksheet

PLACE THE ORDER WITH US TODAY AND GET A PERFECT SCORE!!!