Advanced Quant SP 23 Midterm 1. For questions 3(a)-3(d) use the Stata output and cite the source t ...
Advanced Quant SP 23 Midterm 1. For questions 3(a)-3(d) use the Stata output and cite the source table/statistic for each answer. The output is produced using the dataset, schooldata, which contains information from 18 randomly-selected school districts throughout the United States. For each district, the following information is available: AverageClassSize: the average number of children in a classroom in the school district CombinedSATScore: the average combined SAT score for children in the school district MoreThan_80Pct: takes on a value of 0 for districts that have 80% or fewer of children going on to 4 year colleges, and 1 for districts that have more than 80% of children going on to 4 year colleges. Progressive: takes on a value of 0 for districts that do not use a progressive educational approach, and 1 for districts that use a progressive educational approach. Correlation Matrix: Regression output table regress schooldataSCombinedSATscore schooldataSProgressive schooldata\$AverageClassSize Multiple R-squared: 0.832 , Adjusted R-squared: 0.821
Step 1. Which pair of variables in the correlation matrix has the strongest association? Why? Answer: Show Work: Step 2. How much (what \%) of the variation in Combined SAT Score is explained by Average Class Size alone? Answer: Show Work: Step 3. Look at the regression output table. Is this an example of simple linear regression or multiple regression? Explain your answer. Answer: Show Work: Step 4. Look at the regression output table. Which is the dependent variable (outcome being measured)? (Select one). A) Dollars B) Average Class Size C) Progressive D) SAT Scores
Step 5. Using the regression table, what is the magnitude of the association between Progressive and Combined SAT Score? And, is it statistically different from zero? Provide a complete sentence showing how to interpret the magnitude and provide evidence of why it is or is not significant. Answer: Step 6. How much of the variation in Combined SAT Score is unexplained after controlling for Progressive educational approach and Average Class Size? Answer: Step 7. Which items in the regression table are significant? Use a p-value of .05 (You can select more than one option). A) SAT score B) Average Class Size C) Progressive D) None Show Work: Step 8. Using the regression output table, how would you describe these results in words? Answer: Show Work: Step 9. What else should be taken into consideration when examining SAT scores? In other words, what variables or conditions are left out here? Answer: Show Work: