Regression Table Question....File included

rcalvill

New member
Joined
Jun 11, 2013
Messages
1
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)
Regression Statistics
Multiple R0.7930
R Square0.6288
Adjusted R Square0.6029
Standard Error10.4570
Observations47
ANOVA
DfSSMSFSignificance F
Regression37965.082655.0324.28022.3853E-09
Residual434702.02109.35
Total4612667.11
CoefficientsStandard Errort StatP-valueLower 95%Upper 95%
Intercept-753.4225101.1149-7.45112.88E-09-957.3401-549.5050
% Attendance8.50141.07717.89296.73E-106.329210.6735
Salary6.85E-070.00060.00110.9991-0.00130.0013
Spending0.00600.00461.28790.2047-0.00340.0153


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
clip_image002.gif
, restate to improve the regression model.
Please conduct a F-test for this regression model for the significance of all coefficients
clip_image004.gif
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?
 
Last edited:
I've been stuck on the following questions for weeks:
It's been weeks (so your class is nearly over), and you still aren't able even to get started? It sounds like you may need much more help than we can here provide! :shock:

1.7 After the two hypothesis tests for
clip_image002.gif
, restate to improve the regression model.
Please conduct a F-test for this regression model for the significance of all coefficients
clip_image004.gif
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?
We can't see the files on your hard drive. Please reply with the contents of the above-referenced images. Thank you! ;)
 
Top