Question

The Regression Coefficient (b)  =
**The Y-Intercept (a) =
The Adjusted Coefficient of Determination (R^2) =
The Coeffefficient of Correlation (r ) =
F-Ratio =
Predict the Attendance Rate when
there is a Welfare Rate of 15 Cases =

Regression Statistics			NOTE: Yellow Cells (NA = Not Available) have been intentionally provided without values.
Multiple R	0.788542385		All of the information that you need to complete the questions is on this page.
R Square	NA		All answers are to be on the YOUR ANSWERS HERE worksheet..
Adjusted R Square	NA
Standard Error	0.622829992
Observations	92					Your
ANOVA
	df		SS	MS	F	Significance F
Regression	1		57.39962601	NA	NA	1.05069E-20
Residual	90		34.91254791	NA
Total	91		92.31217391
	Coefficients		Standard Error	t Stat	P-value	Lower 95%	Upper 95%
Intercept	NA		0.098517084	975.6544	6.6998E-183	95.92290199	96.31434444
Welfare	-0.1220211		0.010031131	-12.16424	1.05069E-20	-0.141949674	-0.10209252

Answer 1

The Regression Coefficient (b) =  -0.1220211

The Y-Intercept (a) = t_stat * Standard error =  975.6544 * 0.098517084 = 96.11862648

Coefficient of Determination, R² = (0.788542385)² = 0.621799093

The Adjusted Coefficient of Determination (R^2) = 1- (1-R²)*(N-1) / (N-k-1)

= (1-0.621799093)*(91) / (90) = 0.617596861

The Coeffefficient of Correlation (r ) =  0.788542385

F-Ratio = (SS_regression / df_regression ) / (SS_residual / df_residual )

= ( 57.39962601 / 1) / ( 34.91254791 / 90) =   147.9687577

Predict the Attendance Rate when there is a Welfare Rate of 15 Cases = 96.11862648 - 0.1220211*15 = 94.28830998