A multiple regression was ran on the salary of the faculty f

A multiple regression was ran on the salary of the faculty for multiple colleges. The dependent variable is the salary of the faculty in thousands. The independent variables are State (a dummy variable where State=1 for state sponsored colleges and universities, State=0 for all private colleges and universities), Ivy (is similar to state, where Ivy=1 for ivy league schools and ivy=0 for everyone else), finally CIC (again CIC=1 for the big 10 Universities and the University of Chicago, and CIC=0 for all non CIC members). The results for the multiple regression is as follows, fill in the blanks.

What is the value for the \"R Square\"

What should be in the \"Adjusted R Square\"

What goes in the blank \"Standard Error\" spot?

What would go in the \"df \" column next to regression?

What should be in the \"df\" column next to \"Residual\"?

What should be in the \"df \" column next to Total?

What should be in the MS column in the Regression row?

What is the F distribution?

What is the t stat for the state variable?

What is the t Stat for the IVY variable?

Which variable(s) is statistically significant (you can prove that they are not equal to zero at the .05 significance level). Mark all that apply.

Intercept

State

IVY

CIC

		Intercept
		State
		IVY
		CIC

Solution

Multiple R

0.47168

R square

0.222482

Adj R square

0.1718

SE

0.619621

Observations

50

ANOVA

DF

SS

MS

F

Regression

3

232.4622594

77.4874198

4.3875452

Res

46

812.3953486

17.66076845

Total

49

1044.857608

17.66076845

coeff

SE

t stat

p

Intercept

44.99829

1.004582883

44.79300461

<0.001

state

-4.27646

1.370068389

-3.12134575

0.0031

ivy

0.981714

1.879402482

0.522354469

0.6039

cic

1.165429

1.506874324

0.773407943

0.4432

What is the value for the \"R Square\" =0.222482

What should be in the \"Adjusted R Square\" =0.1718

What goes in the blank \"Standard Error\" spot? 0.619621

What would go in the \"df \" column next to regression? 3

What should be in the \"df\" column next to \"Residual\"? 46

What should be in the \"df \" column next to Total?   49

What should be in the MS column in the Regression row? 77.4874198

What is the F distribution? 4.3875452

What is the t stat for the state variable? -3.12134575

What is the t Stat for the IVY variable? 0.522354469

Which variable(s) is statistically significant (you can prove that they are not equal to zero at the .05 significance level). Mark all that apply.

Variable state, t=-3.12134575, P=0.0031 which is <0.05. the variable is significant.

Variable IVY, t=0.522354469, P=0.6039 which is >0.05. the variable is not significant

Variable cic, t=0.773407943, P=0.4432 which is >0.05. the variable is not significant

Multiple R	0.47168
R square	0.222482
Adj R square	0.1718
SE	0.619621
Observations	50
ANOVA
	DF	SS	MS	F
Regression	3	232.4622594	77.4874198	4.3875452
Res	46	812.3953486	17.66076845
Total	49	1044.857608	17.66076845
	coeff	SE	t stat	p
Intercept	44.99829	1.004582883	44.79300461	<0.001
state	-4.27646	1.370068389	-3.12134575	0.0031
ivy	0.981714	1.879402482	0.522354469	0.6039
cic	1.165429	1.506874324	0.773407943	0.4432