Juniors at New City High School were offered the opportunity to participate in a free after-school tutoring
Question:
Juniors at New City High School were offered the opportunity to participate in a free after-school tutoring program to help them prepare for the SAT exam. A total of 40 one-hour tutoring sessions were offered, and all students were invited drop in to any number of sessions. Students who did participate were asked to sign in, and the school kept track of who participated and for how many hours.
Principal Parker is trying to decide whether to keep investing resources in the free program and wants to know if it is having a positive impact on students. After the SAT exams were completed, she took a random sample of 25 New City HS juniors. She put together a data set (in the "Tutoring" tab) including observations of the following for each sampled student: (1) combined SAT score in critical reading and math, (2) grade point average (GPA), and (3) number of hours spent in the free SAT prep tutoring program. She has asked you to investigate whether participation in the tutoring program is associated with higher SAT scores, while accounting for the potential impact of a student's GPA on SAT score.
4. In a multiple regression analysis of association, which would be the primary independent (x) variable of interest and which would be the dependent (y) variable? What is the other independent (x) variable in the model?
5. (a) In your Excel file, show an example of a scatterplot to show the relationship between the dependent variable and the primary independent variable of interest. (b) Based on a visual assessment, is the association roughly linear? (c) Use Excel to find measures of association (specifically, sample slope, r2, and correlation) for the association between the dependent variable and primary independent variable of interest. Interpret these measures of association in context.
6. (a) In your Excel file show an example of a scatterplot to show the relationship between the dependent variable and the other independent variable. (b) Based on a visual assessment, is the association roughly linear? (c) Use Excel to find measures of association (specifically, sample slope, r2, and correlation) for the association between the dependent variable and other independent variable. Interpret these measures of association in context.
7. Use Excel to generate a multiple regression output for all three variables.
8. (a) What are the null and alternative hypotheses for the relationship between the dependent variable and the primary independent variable of interest? State them using notation, and in words. (b) Interpret the slope coefficient for the primary independent variable, in context. (c) What are the t statistic and p value for this hypothesis test? Interpret the p-value. (d) Do you have evidence to reject the null hypothesis? If so, at what level? State your conclusion.
9. (a) What are the null and alternative hypotheses for the relationship between the dependent variable and the other independent variable? State them using notation, and in words. (b) Interpret the slope coefficient for the other independent variable, in context. (c) What are the t statistic and p value for this hypothesis test? Interpret the p-value. (d) Do you have evidence to reject the null hypothesis? If so, at what level? State your conclusion.
10. Interpret the R and Adjusted R2 for the multiple regression model.
11. draft a letter to Principal Parker explaining the results of your analysis and giving your informed opinion as to whether the free SAT tutoring program is having a positive impact on student SAT scores.
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/6679c58c065b9_4596679c58bde2c8.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/6679c58c99a8e_4606679c58c70507.jpg)