Econometric Methods Problem Set 3<\/p>\n
Directions: Instructions: <\/p>\n
\tFor all parts of this problem use the Wage2 BCUSE dataset.
\n\tRun a simple regression of IQ (as dependent) on educ. Call the coefficient on educ (\u03b4_1 ) \u0303. What is: (\u03b4_1 ) \u0303?
\n\tRun a simple regression of log(wage) (as dependent) on educ. Call the coefficient on educ (\u03b2_1 ) \u0303. What is:(\u03b2_1 ) \u0303?.
\n\tRun a multiple regression of log(wage) on educ and IQ. Call the coefficient on educ (\u03b2_1 ) \u030c and on IQ (\u03b2_2 ) \u030c. What are the two coefficients (\u03b2_1 ) \u030c and (\u03b2_2 ) \u030c?
\n\tDoes the equation we discussed in class on omitted variable bias actually hold in this example? (Hint: Lecture 9 has the equation.)
\n\tDoes what you found imply the coefficient you found in part b is biased? If so explain why (i.e., what assumption is violated and why)?<\/p>\n
\tConsider the equation below:<\/p>\n
log\u2061(salary)=\u03b2_0+\u03b2_1 log\u2061(sales)+\u03b2_2 roe+\u03b2_3 ros+u<\/p>\n
Where roe is returns on equity and ros is return on the firm\u2019s stock.<\/p>\n
\tIn terms of the models parameters, state the null hypothesis that after controlling for sales and roe the variable ros has no impact on salary.
\n\tUse the BCUSE dataset ceosal1. Estimate the regression above. By what percent is salary predicted to increase if ros increases by 50? (Express as a decimal rounded to three places (i.e., 50 percent is 0.500).
\n\tDerive (or report from STATA) the t-statistic for a test that ros has no effect on log(salary) vs. the alternative that it is greater than 0.
\n\tWould you reject the null at the 10 percent level of significance?
\n\tAfter doing this test, would you continue to include ros in your regression of firm performance on CEO salary? Explain.<\/p>\n
\tUse the BCUSE dataset mlb1 to estimate the equation in STATA discussed in lecture:<\/p>\n
log(salary)=\u03b2_0+\u03b2_1 years+\u03b2_2 gamesyr+\u03b2_3 bavg+\u03b2_4 hrunsyr+\u03b2_5 rbisyr+u_i <\/p>\n
\tUse STATA to find the correlation between hrunsyr and rbisyr.
\n\tGiven this, why is it not particularly surprising neither result is statistically different than 0 when you run this regression?
\n\tDrop the variable rbisyr. What happens to the p-value of hrunsyr?
\n\tWhy does dropping rbisyr make this kind of difference?
\n\tWhile still leaving out rbisyr, wow run the regression adding the variables runsyr, fldperc, sbasesyr Are any of the variables statistically significant at the five percent level?
\n\tUse an F-test to see if those three variables are jointly significant.
\n\tWhat is the F-stat?
\n\tWhat is the critical value for 1-percent significance for this test (table in book):
\n\tAre the variables jointly significant?<\/p>\n
\tThe following model allows the return to education to depend on the total amount of parent\u2019s education, called pareduc:<\/p>\n
log\u2061(wage)=\u03b2_0+\u03b2_1 educ+\u03b2_2 educ*pareduc+\u03b2_3 exper+\u03b2_4 tenure+u<\/p>\n
\tWhat is the percent increase in the wage of a one year change in educ (expressed in terms of model parameters, i.e., in symbols)?
\n\tDo you have an expectation on the sign of \u03b2_2? Explain your intuition:
\n\tUse the data in the BCUSE dataset WAGE2 to estimate the equation. You will need to generate the variable parent\u2019s education as the sum of meduc and feduc (mother\u2019s and father\u2019s education respectively). Whenever you run a regression, you should know if any observations are left out of the regression (e.g., if you have 500 observations but only 440 show up in the regression). Are any of the observations present in the dataset dropped out of the regression? Can you find out why? (Hint: the tab command and the \u201cmissing\u201d option can be useful).
\n\tGiven this regression, what is the return to an extra year of education when parent\u2019s education is 24?<\/p>\n
\tReal World Problem \u2013 Gender Representation and Pay in Large Companies. You will be using the Wharton Research Data Services, which contains a host of financial data. For this exercise, we will be focusing on the issue of representation in executive positions within companies by gender. Follow the steps below to get the data you will need.
\n\tGo to the Wharton Research Data Services website at https:\/\/wrds-www.wharton.upenn.edu\/ and login using our class\u2019s login, with username \u201cecon331701sprg\u201d and password \u201colsregression.\u201d [It should not ask for Duo Two-factor authentication, but let me know if it does]. Click on the \u201cCompustat \u2013 Capital IQ\u201d subscription. Then click on \u201cExecucomp\u201d and then \u201cAnnual Compensation.\u201d
\n\tFor Step 1, select the date range 2010 to 2020 (make sure you stop in 2020 so you get the same answers I have\u2026do not download 2021 or 2022 data, which may still be updating with late submissions). For Step 2, select \u201cSearch the Entire Database.\u201d In Step 3, pick the following variables: Company Name, Industry (NAICS), Gender, Age (it says Director Age, I\u2019m not sure why), CEOANN (variable describing if CEO), CFOANN (variable describing if CEO), TDC1 (total compensation), and Year (year observation is from). In Step 4, make sure to select STATA and uncompressed (date format shouldn\u2019t matter). The dataset should be about 13MB. Save it to your L:.<\/p>\n
\tIt is always a good idea to know what data you are working with. In 3-4 sentences, describe the Executive Compensation Dataset. Who collects it? Which companies are included? Which executives at those companies?
\n\tYou are interested in female representation in high-level executives at large companies. What fraction of the executives in the dataset are female? Input your answer as a decimal rounded to two digits (e.g., 12.4 percent is input as 0.12).
\n\tYou are also interested in how this percent has changed over time. Make a line graph of the share of all executives in the dataset that were women, with year on the x-axis. Do not make the graph in STATA. Instead, make it in excel following the format provided on the assignment page by using a block of code within a do file similar to this:
\n\tpreserve (preserve tells STATA to save the data temporarily)
\n\tcollapse (mean) female, by(YEAR) (collapse tells STATA to do some operation like taking the means within each year and collapse the data to the (in this case) yearly level. Your dataset is now very small.)
\n\texport excel using \u201cYour L:\u201d, replace firstrow(var)
\n\trestore (now your data is back)
\nNow, you should have data in excel with the average share of females in the dataset each year. Make the graph according to the format and label the first and last points to illustrate the change over the period. Upload your graph as a Microsoft Word Document, with an appropriate title and sourcing. (3 points)
\n\tThe CEO and CFO annual flags indicate whether this particular executive is the CEO or CFO at that time. Generate indicators for the executive being a CEO or a CFO. What share of executives in the data are CEOs? Input your answer as a decimal rounded to two digits (e.g., 12.4 percent is input as 0.12).
\n\tGenerate a variable for log TDC1 (total executive compensation), and age squared. Run a regression of this logged variable on female, ceo, cfo, age, age squared, and indicators for each year (you can do this simply by typing i.year). According to the regression what is the percent reduction in salary for females in the same position as a man, of the same age, and in the same year? Input your answer as a decimal rounded to two digits (e.g., 12.4 percent is input as 0.12).
\n\tAt what age does the regression suggest each year of age is associated with a decrease in salary? Round to nearest year.
\n\tYou wonder if women executives are in different lower paying industries, and that might account for the salary difference. Run a regression controlling for industry (hint: using xi: regress and then i.NAICS would be wise). Write 1-2 sentences on whether you think industry accounted for the difference (i.e., does the coefficient on gender move much closer to zero)?
\n\tDo you think we should interpret this coefficient causally? Any variables we might be missing? Write 3-4 sentences.<\/p>\n","protected":false},"excerpt":{"rendered":"
Econometric Methods Problem Set 3 Directions: Instructions: For all parts of this problem use the Wage2 BCUSE dataset. Run a simple regression of IQ (as dependent) on educ. Call the coefficient on educ (\u03b4_1 ) \u0303. What is: (\u03b4_1 ) \u0303? Run a simple regression of log(wage) (as dependent) on educ. Call the coefficient on […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9023,8258,8671],"tags":[],"class_list":["post-138275","post","type-post","status-publish","format-standard","hentry","category-homework-help","category-economics-assignment-help","category-statistics-assignment-help"],"_links":{"self":[{"href":"https:\/\/www.colapapers.com\/assessments\/wp-json\/wp\/v2\/posts\/138275","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.colapapers.com\/assessments\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.colapapers.com\/assessments\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.colapapers.com\/assessments\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.colapapers.com\/assessments\/wp-json\/wp\/v2\/comments?post=138275"}],"version-history":[{"count":1,"href":"https:\/\/www.colapapers.com\/assessments\/wp-json\/wp\/v2\/posts\/138275\/revisions"}],"predecessor-version":[{"id":138276,"href":"https:\/\/www.colapapers.com\/assessments\/wp-json\/wp\/v2\/posts\/138275\/revisions\/138276"}],"wp:attachment":[{"href":"https:\/\/www.colapapers.com\/assessments\/wp-json\/wp\/v2\/media?parent=138275"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.colapapers.com\/assessments\/wp-json\/wp\/v2\/categories?post=138275"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.colapapers.com\/assessments\/wp-json\/wp\/v2\/tags?post=138275"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}