Need one who is good at Economic data analysis and using Stata(A Software) (Undergraduate)

First deliverable for final project – due Tuesday 11/21 by 5 p.m. Your first deliverable should include a word document that has the following parts. You will also separately submit a do-file and log-file that created all of the results. All deliverables will be submitted via Canvas by 5 p.m. There is a 20 percent penalty for any paper submitted after the deadline but before 11/23 at 5 p.m. No submissions will be accepted after 11/23 at 5 p.m.

1) A description of the data set you will use for your primary analysis. This should include a description of the primary data source (the American Community Survey), the year(s) of the data, and the restrictions that I described above. Note: if you are investigating a “household level variable” (e.g. homeownership, home value, rent,) you should use only the head of the household (pernum==1) for your analysis. If you are investigating an “individual level” variable (e.g. employment, marital status), use both the reference person and his/her spouse

2) A description of any sample restrictions that you are making (e.g. omitted people in certain age ranges, dropped people with missing data, etc.). Make sure that you have “cleaned” your data so that you have the same number of observations on the dependent and control variables. Also, describe any variables that you create or modify. For example, be sure to study the codebook to understand how variables might be coded if there are missing values (drop such observations). You may also want to adjust the units that certain variables are measured in (e.g. housing values might be converted to 1000s of dollars instead of dollars).

3) A description of the dependent variable and the key control variable in your analysis and a discussion of why you believe the key control variable will have either a positive or negative effect on the dependent variable. You should show the relationship between the dependent variable and the key control variable of interest with both a table and a graph. The table and graph should be professionally designed and be self-explanatory. That is, anyone who looks at the table or graph should be able to determine what statistics are presented, the meaning of the variables, and where the data came from.

4) A description of at least two other control variables that you believe will help explain variation in your dependent variable. Describe why you think the direction of the expected effect of each control variable on the dependent variable would be either positive or negative. A professional table showing for the dependent variable and each control variable the number of observations, the sample mean, standard deviation, minimum and maximum value for the dependent variable and each of the control variables in your data. Be sure to explain any modifications you made to the variables in the data set (e.g. did you have to recode variables that were missing? Did you have to convert a categorical variable to a continuous variable? Did you make dummy variables?)

5) A simple linear regression of your dependent variable on the key variable(s) of interest and other control variables that you believe are important. The results should be presented in a professional table created with the Stata routine esttab. The results

should include coefficients, t-statistics, R2 and adjusted R2 , and the number of observations.

6) The structure of your word document should include the following sections.

(a) Introduction.

(i) Describes the objective of the deliverable and a couple of the major findings. For example, this study will use data from the ACS to understand the factors that determine whether people are employed. We find several important determinants of employment. For example, …..

(b) The data

(i) Description of ACS data.

(ii) The dependent variable to be studied, the key control variable, and other controls you think are important.

(iii) Expected effect of each of the control variables and why.

(iv) Sample restrictions for your analysis.

(v) Any modifications you made to the variables that you use in your analysis.

(c) Results of data analysis.

(i) The word document should provide a brief discussion of the results in the tables and figures presented below. All the tables and figures should be numbered and added to the end of your word document.

(ii) Table 1. A professional table showing sample statistics (means, min, max, observations, etc.)

(iii) Figure 1. A professional figure showing relationship between dependent variable and key control variable.

(iv) Table 2. A professional table showing relationship between dependent variable and key control variable.

(v) Table 3. A professional table showing regression results.