I've been stuck on the following questions for weeks:
Following is a multiple regression output with Y = % Passing as the dependent variable, =:% Attendance, = Salaries and = Spending:
Table(3)
1.4 Referring to Table (3), what is the value of the test statistics when testing whether instructional spending per pupil has any effect on percentage of students passing the proficiency test? Using this test statistics to complete your hypothesis test and describe the test steps and your conclusion.
1.5 Referring to Table (3), what is the p-values of the test statistics when testing whether instructional spending per pupil, has any effect on percentage of students passing the proficiency test?
1.6 Referring to Table (3) perform a null hypothesis to test whether daily average of the percentage of students attending class has any effect on percentage of students passing the proficiency test?WH AT IS YOUR CONCLUSION? Specify and explain your reasons.
1.7 After the two hypothesis tests for
, restate to improve the regression model.
Please conduct a F-test for this regression model for the significance of all coefficients
of the independent variables using the F-test information from table (2). What is your result? Is it consistent with the results from T-tests?
1.8. What can you expect in terms of fitness that the model is improved after you modify the regression model?
Following is a multiple regression output with Y = % Passing as the dependent variable, =:% Attendance, = Salaries and = Spending:
Table(3)
Regression Statistics | ||||||
Multiple R | 0.7930 | |||||
R Square | 0.6288 | |||||
Adjusted R Square | 0.6029 | |||||
Standard Error | 10.4570 | |||||
Observations | 47 | |||||
ANOVA | ||||||
Df | SS | MS | F | Significance F | ||
Regression | 3 | 7965.08 | 2655.03 | 24.2802 | 2.3853E-09 | |
Residual | 43 | 4702.02 | 109.35 | |||
Total | 46 | 12667.11 | ||||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | |
Intercept | -753.4225 | 101.1149 | -7.4511 | 2.88E-09 | -957.3401 | -549.5050 |
% Attendance | 8.5014 | 1.0771 | 7.8929 | 6.73E-10 | 6.3292 | 10.6735 |
Salary | 6.85E-07 | 0.0006 | 0.0011 | 0.9991 | -0.0013 | 0.0013 |
Spending | 0.0060 | 0.0046 | 1.2879 | 0.2047 | -0.0034 | 0.0153 |
1.5 Referring to Table (3), what is the p-values of the test statistics when testing whether instructional spending per pupil, has any effect on percentage of students passing the proficiency test?
1.6 Referring to Table (3) perform a null hypothesis to test whether daily average of the percentage of students attending class has any effect on percentage of students passing the proficiency test?WH AT IS YOUR CONCLUSION? Specify and explain your reasons.
1.7 After the two hypothesis tests for
Please conduct a F-test for this regression model for the significance of all coefficients
1.8. What can you expect in terms of fitness that the model is improved after you modify the regression model?
Last edited: