logo Use SA10RAM to get 10%* Discount.
Order Now logo

Ask This Question To Be Solved By Our ExpertsGet A+ Grade Solution Guaranteed

expert
Dr Samuel BarberaStatistics
(5/5)

673 Answers

Hire Me
expert
Elis PanaseykoEnglish
(5/5)

635 Answers

Hire Me
expert
Rech ElleMathematics
(5/5)

547 Answers

Hire Me
expert
Joseph MburuStatistics
(/5)

542 Answers

Hire Me
STATA
(5/5)

Produce a regression table using outreg2 showing the results of each FE specification

INSTRUCTIONS TO CANDIDATES
ANSWER ALL QUESTIONS

You have been provided 10 (mostly macro) variables (see below). Given the raw data (in excel or text file on Canvas), you must do the following:

1. Pick 3 series (cannot all be from IMF) and clean the raw files to Stata .dta files.

2. Make sure to accurately label each variable with source and brief definition.

3. Merge your data to one aggregate dataset. Keep if _merge == 3.

4. Using a loop, plot a line graph for each country showing the 3 variables over time (may have to put on separate y-axes). Format the chart so the title contains the country name. Also, save each chart so file name includes the country name in it.

5. Also using a loop, plot 3 separate line charts (one for each variable) showing the advanced economy medians1. Save and title the graphs to accurately reflect the variable being shown.

6. Using your 3 variables run regressions using the reghdfe stata package (y regressed on x1 x2). The regression should make some economic sense, but that is of lesser importance. You may transform variables however you’d like (logs, lags, etc.).

a. Run three regressions: (1) baseline with no fixed effects; (2) year fixed effects; (3) country and year fixed effects.

b. Produce a regression table using outreg2 showing the results of each FE specification (clearly labelling which FEs are being used)

 

What needs to be submitted?

1. One .do file. It should be self-contained in that all I have to do is change the working directory and it will run.

a. The do file should (1) import and clean each raw data file and save as .dta files; (2) merge the 3 variables together once cleaned and save as an aggregate dataset; (3) run all analysis including charts and regressions and save to the working directory.

b. Clearly comment throughout with what you are doing and why.

2. Raw data (excel or text files). If you have to do some pre-cleaning in excel (e.g. dropping “n/a”, etc.) just submit the newly saved excel/text file after doing that (I only want whatever is imported into Stata).

 

1 To get the set of advanced economies you may do one of two things:

 

1) merge in the country groups dataset from the basic files under course files which contains a dummy variable for AEs; or

2) create your own dummy variable for AEs (=1 if ae and =0 if not ae). I'm not going to grade on you definition of AEs, so you could pick like 10+ obvious ones.

3. Final aggregate dataset in Stata. Ideally your code will run everything without this and produce and save the final aggregate dataset along the way. I just want it in case there are any issues in the cleaning and merging section of the do file code.

(5/5)
Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme

Get Free Quote!

414 Experts Online