Question

1 Approved Answer

Posted on Sep 03, 2024

Variable Obs Mean Std. Dev. Min Max 141 19 30 1.271064 1448194 0 1 age soph junior senior senior5 141 141 141 20.88652 .0212766 .3829787

image text in transcribed

Variable Obs Mean Std. Dev. Min Max 141 19 30 1.271064 1448194 0 1 age soph junior senior senior5 141 141 141 20.88652 .0212766 .3829787 .5035461 0921986 0 1 .4878462 .5017699 2903375 1 141 0 1 141 0 1 0 1 male campus business engineer colGPA 141 141 .5248227 .1702128 7943262 .035461 3.056738 .5011638 . 3771594 4056341 . 1856012 3723103 0 1 141 0 1 141 2.2 4 hsGPA 141 2.4 4 141 16 33 3.402128 24.15603 .4113475 .1702128 .2056738 .3199259 2.844252 .4938323 .3771594 ACT job19 job20 drive 0 1 141 141 0 1 141 .4056341 0 1 bike 141 3617021 0 1 141 4822062 497206 4156269 0 1 141 4326241 2198582 3971631 0 1 walk voluntr PC greek 1 141 4910547 0 1 141 .3191489 .4678087 0 1 car 0 1 141 141 0 1 141 .7730496 .9361702 .4751773 .6028369 1.076241 .4203535 .245321 .5011638 .4910547 1.088882 siblings bgfriend clubs skipped 0 1 141 0 1 141 0 5 141 0 7 141 0 1 alcohol gradMI fathcoll mothcoll 1.901064 .8723404 .5886525 .5390071 1.374701 .3349001 .4938323 .5002532 141 0 1 141 0 1 storage variable name type display format value label variable label age soph junior senior senior5 male campus business engineer colGPA hsGPA ACT job19 job20 drive bike walk voluntr PC greek car siblings bgfriend clubs skipped alcohol gradMI fathcoll mothcoll byte byte byte byte byte byte byte byte byte float float byte byte byte byte byte byte byte byte byte byte byte byte byte float float byte byte $9.0g %9.09 $9.09 $9.0g $9.0g $9.0g $9.0g $9.0g $9.0g $9.09 %9.0g $9.0g $9.0g $9.0g $9.0g $9.@g $9.0g $9.0g $9.0g %9.09 $9.0g $9.0g %9.0g $9.0g $9.0g $9.0g 49. Og %9.0g 89.0g in years =1 if sophomore =1 if junior =1 if senior =1 if fifth year senior =1 if male =1 if live on campus =1 if business major =1 if engineering major MSU GPA high school GPA 'achievement' score =1 if job = 20 hours =1 if drive to campus =1 if bicycle to campus =1 if walk to campus =1 if do volunteer work =1 of pers computer at sch =1 if fraternity or sorority =1 if own car =1 if have siblings =1 if boy- or girlfriend =1 if belong to MSU club avg lectures missed per week avg # days per week drink alc. =1 if Michigan high school =1 if father college grad =1 if mother college grad byte Use the dataset file GPA1.dta to do the following questions. We are interested in what factors will affect student's college GPA. Use the command "describe in STATA first to make sure you understand the meanings of all variables. Please write down all the answers below each question on this paper. Use log(colGPA) (we name it as lcolGPA) as the dependent variable, and use log(age) (we name it as lage), hsGPA, ACT, male and skipped as the independent variables. log(colGPA) = Bo+Bilog(age)+B2 bsGPA +B3 ACT +34 male+B5 skipped+ u 1) Generate those two log variables and name them as lcolGPA and lage (write down the command). (2 points) 2) What is the average value of high school GPA in the sample? What is the maximum of age? Write down the command you use. (2 points) 3) Run the regression in STATA. Write down the command that runs the regression and copy paste the regression table here: (4 points) 4) What are the standard errors of the coefficients on skipped and male respectively? (2 points) 5) What is the R-squared of this regression? And the observation number? (2 points) 6) What is the 95% confidence interval of the coefficient on male? (2 points) 7) Which variables are significant at 1% significance level? Why? (2 points) 8) Which variables are insignificant at 20% significance level? Why? (2 points) 9) Is the regression model significant overall (all explanatory variables jointly significant)at 5% level? Why? (2 points) 10) Perform a test for the hypothesis that male and skipped, these two variables jointly have no effect on college GPA at 5% significant level. Can you reject the null hypothesis? Why? Make sure to write down the null hypothesis, the alternative hypothesis, the command and the test output from stata, 11) Perform a test with the null hypothesis that one more point of ACT and bs GPA have the same effect on college GPA at 1% level. Can you reject the null hypothesis? Why? Make sure to write down the null hypothesis, the alternative hypothesis, the command and the test output from stata, and answer the questions. (4 points) 12) Perform a test for the joint hypothesis that the coefficient on lage is 0.1 and at the same time the coefficient on sikpped is 0 at 5% level. Can you reject the null hypothesis? Why? Make sure to write down the command and the test output, and answer the questions. (2 points) Variable Obs Mean Std. Dev. Min Max 141 19 30 1.271064 1448194 0 1 age soph junior senior senior5 141 141 141 20.88652 .0212766 .3829787 .5035461 0921986 0 1 .4878462 .5017699 2903375 1 141 0 1 141 0 1 0 1 male campus business engineer colGPA 141 141 .5248227 .1702128 7943262 .035461 3.056738 .5011638 . 3771594 4056341 . 1856012 3723103 0 1 141 0 1 141 2.2 4 hsGPA 141 2.4 4 141 16 33 3.402128 24.15603 .4113475 .1702128 .2056738 .3199259 2.844252 .4938323 .3771594 ACT job19 job20 drive 0 1 141 141 0 1 141 .4056341 0 1 bike 141 3617021 0 1 141 4822062 497206 4156269 0 1 141 4326241 2198582 3971631 0 1 walk voluntr PC greek 1 141 4910547 0 1 141 .3191489 .4678087 0 1 car 0 1 141 141 0 1 141 .7730496 .9361702 .4751773 .6028369 1.076241 .4203535 .245321 .5011638 .4910547 1.088882 siblings bgfriend clubs skipped 0 1 141 0 1 141 0 5 141 0 7 141 0 1 alcohol gradMI fathcoll mothcoll 1.901064 .8723404 .5886525 .5390071 1.374701 .3349001 .4938323 .5002532 141 0 1 141 0 1 storage variable name type display format value label variable label age soph junior senior senior5 male campus business engineer colGPA hsGPA ACT job19 job20 drive bike walk voluntr PC greek car siblings bgfriend clubs skipped alcohol gradMI fathcoll mothcoll byte byte byte byte byte byte byte byte byte float float byte byte byte byte byte byte byte byte byte byte byte byte byte float float byte byte $9.0g %9.09 $9.09 $9.0g $9.0g $9.0g $9.0g $9.0g $9.0g $9.09 %9.0g $9.0g $9.0g $9.0g $9.0g $9.@g $9.0g $9.0g $9.0g %9.09 $9.0g $9.0g %9.0g $9.0g $9.0g $9.0g 49. Og %9.0g 89.0g in years =1 if sophomore =1 if junior =1 if senior =1 if fifth year senior =1 if male =1 if live on campus =1 if business major =1 if engineering major MSU GPA high school GPA 'achievement' score =1 if job = 20 hours =1 if drive to campus =1 if bicycle to campus =1 if walk to campus =1 if do volunteer work =1 of pers computer at sch =1 if fraternity or sorority =1 if own car =1 if have siblings =1 if boy- or girlfriend =1 if belong to MSU club avg lectures missed per week avg # days per week drink alc. =1 if Michigan high school =1 if father college grad =1 if mother college grad byte Use the dataset file GPA1.dta to do the following questions. We are interested in what factors will affect student's college GPA. Use the command "describe in STATA first to make sure you understand the meanings of all variables. Please write down all the answers below each question on this paper. Use log(colGPA) (we name it as lcolGPA) as the dependent variable, and use log(age) (we name it as lage), hsGPA, ACT, male and skipped as the independent variables. log(colGPA) = Bo+Bilog(age)+B2 bsGPA +B3 ACT +34 male+B5 skipped+ u 1) Generate those two log variables and name them as lcolGPA and lage (write down the command). (2 points) 2) What is the average value of high school GPA in the sample? What is the maximum of age? Write down the command you use. (2 points) 3) Run the regression in STATA. Write down the command that runs the regression and copy paste the regression table here: (4 points) 4) What are the standard errors of the coefficients on skipped and male respectively? (2 points) 5) What is the R-squared of this regression? And the observation number? (2 points) 6) What is the 95% confidence interval of the coefficient on male? (2 points) 7) Which variables are significant at 1% significance level? Why? (2 points) 8) Which variables are insignificant at 20% significance level? Why? (2 points) 9) Is the regression model significant overall (all explanatory variables jointly significant)at 5% level? Why? (2 points) 10) Perform a test for the hypothesis that male and skipped, these two variables jointly have no effect on college GPA at 5% significant level. Can you reject the null hypothesis? Why? Make sure to write down the null hypothesis, the alternative hypothesis, the command and the test output from stata, 11) Perform a test with the null hypothesis that one more point of ACT and bs GPA have the same effect on college GPA at 1% level. Can you reject the null hypothesis? Why? Make sure to write down the null hypothesis, the alternative hypothesis, the command and the test output from stata, and answer the questions. (4 points) 12) Perform a test for the joint hypothesis that the coefficient on lage is 0.1 and at the same time the coefficient on sikpped is 0 at 5% level. Can you reject the null hypothesis? Why? Make sure to write down the command and the test output, and answer the questions. (2 points)