Question

An analyst believes that incoming GPA, the number of hours spent on Facebook per week, and upperclassman status can predict scores. Data is collected for 260 students. Students’ incoming GPA and the average number of hours spent on Facebook each week is recorded. For Academic Standing, data was included based on the number of years of college already completed  (3 = senior, 2 = junior, 1 = sophomore , 0 = freshmen). A regression is performed, and the results of the regression are in Table 1.
TABLE 1

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.68
R Square	0.86
Observations	260
	Coefficients	Standard Error	p-Value
Intercept	74.569	0.029	0.00000
GPA	4.801	1.275	0.03956
Facebook (hours per week)	-2.704	0.635	0.02598
Academic Standing	0.75	0.40	0.11903

1.What is the dependent variable?

Intercept

GPA

academic standing

Facebook

The Score

2. From Table 1, what is the t-stat for the Academic Standing coefficient ?

Enter your answer with two decimals.

3.According to Table 1, the coefficients are:

Not statistically significant.

All statistically significant

All statistically significant except for Academic Standing.

All statistically significant except for GPA.

All statistically significant except for Facebook.

4.According to the sign on the Academic Standing coefficient from Table 1,

If the Academic Standing coefficient is bigger than the Facebook coefficient, students grades will increase.

If students been at college longer, then the score is lower.

If students been at college longer, then the score is higher.

If students been at college longer, then the Facebook use is higher.

Answer 1

Answer :

1.What is the dependent variable?

The Score

As per the first line of the description the analyst plans to predict the scores. Hence it is the dependent variable.

2. From Table 1, what is the t-stat for the Academic Standing coefficient ?

t statistic is the coefficient divided by its standard error.

So, t statistic = 0.75/0.40 = 1.88

So, t-stat value is 1.88

3.According to Table 1, the coefficients are:

All statistically significant except for Academic Standing.

A coefficient is statistically significant if its p value is less than 0.05 ( we normally assume our level of significance to be 0.05).

As we can see that p value of all coefficient except academic standing is less than 0.05. Therefore, all coefficients are statistically significant except academic standing.

4.According to the sign on the Academic Standing coefficient from Table 1 :

If students been at college longer, then the score is higher.

This is because there is a positive coefficient on Academic Standing reflecting an direct relationship between the scores and Academic Standing.