Pick a country of your choice and download data on all the relevant variables for the estimation of the gravity model of international trade.

Task:Pick a country of your choice and download data on all the relevant variables for the estimation of the gravity model of international trade. The report should follow the following format. The model should be estimated ONLY for the 20 largest trading partners and only for the year 2019.IN MY CASE IT SHOULD BE a Gravity model of international trade between Qatar and the 20 largest partners ONLY for the year 2019. OVERALL I NEED 2 FILES- eXCEL with proper calculations and WORD with proper descriptions of your calculation made, and following instructions)THIS PART SHOULD BE DONE IN EXCEL WITH PROPER CALCULATIONS BY USING A DATA ANALYSIS TOOL. !!!!! (send it to me as well)Download data on the following variables• Exports (of your chosen country) to the 20 biggest partners• GDP of the partner country• Distance between the capital of your chosen country and the partner country’s capital.• FTA-Free trade agreemento FTA=1, if there is a free trade agreement between the countrieso FTA=0, if there is no free trade agreement between the countries• Bordero Border=1 if the countries share a bordero Border=0 if the countries don’t share a borderThen THIS DOWN PART MUST BE DONE IN WORD-Introduction, Literature Review, Describe the Model, Analysis of Results, Conclusion, References (send it to me as well) NOT BRIEF REPORT, PLEASE FOLLOW THE INSTRUCTIONS.1. Introduction: (min 1 page)Introduce the gravity model of trade and introduce the work of your report (a description of the different chapters of the report)2. Literature Review: (Minimum 1 page)This chapter should explain the gravity model in detail, and the purpose and importance of the gravity model in explaining bilateral international trade.3. Describe the Model: (One page would be enough)This chapter just describes the econometric model and explains each variable in the model. HERE USE YOUR SCREENSHOTS FROM EXCEL AND DESCRIBE THE CALCULATIONS!!!!!4. Analysis of Results (One Page)Estimate the model using any program of your choice and Interpret the results in this chapter. Use graphs or charts for explanation (x and y variables)5. Conclusion (Max One Page)Write a summary of all the work you did in this research paper with a focus on the results of the paper.TOTAL 5 PAGES without references6. References ( another 6th page)Write all the references you used in writing this paper. Use Harvard style of referencing.Sources:http://www.piie.com/publications/chapters_preview/72/4iie2024.pdfData Source: World Integrated Trade Solution (YOU CAN USE THIS FOR YOUR DATA) http://wits.worldbank.org/CountryProfile/en/Country/CZE/Year/2014/TradeFlow/Import

Last Completed Projects