Can someone help with answer the questions below with the output data below ? Everything needed is here.

It is generally assumed that spending more money on education will lead to better prepared students. Gruber tested that assumption by collecting data for each of the 50 U.S. States. She recorded the average amount spent per pupil (Expend), the pupil/teacher ratio (PTratio), the average teacher's salary (Salary), the percentage of students in that state taking the SAT exam (PctSAT) and the combined SAT score (SATcombined). A simultaneous multiple regression was computed on the variables with SAT combined was the dependent variable and the average amount spent per pupil (Expend), the pupil/teacher ratio (PTratio), the average teacher's salary (Salary) and the percentage of students in that state taking the SAT exam (PctSAT) as the predictor variables. Use the output to answer the following questions.

Coefficients

Model Unstandardized Coefficients Standardized Coefficients t Sig. Correlations

B Std. Error Beta Zero-order Partial Part

1 (Constant) 1045.972 52.870 19.784 .000

expend 4.463 10.547 .081 .423 .674 -.381 .063 .026

PTratio -3.624 3.215 -.110 -1.127 .266 . 081 -.166 -.070

salary 1.638 2.387 .130 .686 .496 -.440 .102 .043

PCTsat -2.904 .231 -1.039 -12.559 .000 -.887 -.882 -.784

a. Dependent Variable: satcombined

Model Summary

Model R R Square Adjusted R Square Std. Error of the Estimate

1 .908a .825 .809 32.702

1. With all four variables in th model what percent of the variance is accounted for after adjusting for inflation?

2..what is the standard error of estimate?

3.From the printout what numbers make the t ratio for testing the significance of PTratio?

4.With all 4 variables in the model, for each unit increase in Expend what happens to Y and by how much.

5.With all 4 variables in the model, for each standard deviation change in Salary how much of a standard deviation change in Y occurs and in what direction.

6.Disregarding whether any of the predictor variables are significant, examine the results and tell me which predictor variable has the strongest relationship with Y and how do you know that.

7.Which of the 4 predictors accounts for a significant amount of the variance in Y?

8.What percent of the variance in Y is uniquely accounted for by PctSAT?

9.The null hypothesis that is tested when using regression coefficients is what?

10.Write the regression equation.

11.What number from the analysis indicates the error in prediction.

12.What is the difference between R Square and Adjusted R Square in multiple regression and why do we need to calculate both of these statistic. Be very specific and complete.