last degit 4 20 + 4
Posted: Fri Dec 24, 2021 9:59 am
last degit 4
20 + 4
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+B.log(age)+B2 hsGPA +B3 ACT +34 male+Bs skipped+ u 1) Type in the stata command window “replace age=20+last digit of your cuny id in 1” then press enter, then type in the command window "save dataforfinal" then press enter. For example, if the last digit of your cuny id is 5, then type in the stata command window replace age=20+5 in 1 then press enter, then type in the command window "save dataforfinal" then press enter. Note: if you are using SPSS In Data View, double-click the first cell in the age column. (The cell value is displayed in the cell editor.) Edit the value directly in the cell or in the cell editor. Change the original 21 to the number that is equal to 20+ the last digit of your cuny id Press Enter and save the file 2) Generate the those two log variables in the model and name them as lcolGPA and lage (write down the command in your answer and be careful with the letter case, STATA is case sensitive). (2 points) 3) 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) 4) Run the regression in STATA. Write down the command that runs the regression and copy paste the regression table here: (4 points)
5) What are the standard errors of the coefficients on skipped and male respectively? (2 points) 6) What is the R-squared of this regression? And the observation number? (2 points) 7) What is the 95% confidence interval of the coefficient on male? (2 points) 8) Which variables are significant at 1% significance level? Why? (2 points) 9) Which variables are insignificant at 20% significance level? Why? (2 points) 10) Is the regression model significant overall (all explanatory variables jointly significant)at 5% level? Why? (2 points) 11) 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, and answer the questions. (4 points) 12) Perform a test with the null hypothesis that one more point of ACT and hsGPA 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) 13) 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)
20 + 4
- Last Degit 4 20 4 1 (454.57 KiB) Viewed 90 times
- Last Degit 4 20 4 2 (427.13 KiB) Viewed 90 times
5) What are the standard errors of the coefficients on skipped and male respectively? (2 points) 6) What is the R-squared of this regression? And the observation number? (2 points) 7) What is the 95% confidence interval of the coefficient on male? (2 points) 8) Which variables are significant at 1% significance level? Why? (2 points) 9) Which variables are insignificant at 20% significance level? Why? (2 points) 10) Is the regression model significant overall (all explanatory variables jointly significant)at 5% level? Why? (2 points) 11) 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, and answer the questions. (4 points) 12) Perform a test with the null hypothesis that one more point of ACT and hsGPA 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) 13) 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)