SCENARIO 13-9
It is believed that, the average numbers of hours spent studying per day (HOURS) during undergraduate education should have a positive linear relationship with the starting salary (SALARY, measured in thousands of dollars per month) after graduation. Given below is the Excel output for predicting starting salary (Y) using number of hours spent studying per day (X) for a sample of 51 students. NOTE: Only partial output is shown.

Note: 2.051 E - 05 = 2.051*1 0-5 and 5.944 E -18 = 5.944 *10 -18 .
-Referring to Scenario 13-8,the value of the measured test statistic to test whether there is any linear relationship between GPA and ACT is
A)0.0356
B)0.1021
C)0.7598
D)2.8633

Question

SCENARIO 13-9
It is believed that, the average numbers of hours spent studying per day (HOURS) during undergraduate education should have a positive linear relationship with the starting salary (SALARY, measured in thousands of dollars per month) after graduation. Given below is the Excel output for predicting starting salary (Y) using number of hours spent studying per day (X) for a sample of 51 students. NOTE: Only partial output is shown.

Note: 2.051 E - 05 = 2.051*1 0-5 and 5.944 E -18 = 5.944 *10 -18 .
-Referring to Scenario 13-8,the value of the measured test statistic to test whether there is any linear relationship between GPA and ACT is
A)0.0356 
B)0.1021 
C)0.7598 
D)2.8633

Quizplus · Accepted Answer

The Excel output shows that the slope coefficient (B1) is 0.356055, and the standard error of the slope coefficient (SE(B1)) is 0.124438. To test whether there is any linear relationship between HOURS and SALARY, we need to calculate the t-test statistic as t = B1/SE(B1). Plugging in the values, we get t = 0.356055/0.124438 = 2.86328, which is rounded to 2.8633. Therefore, the value of the measured test statistic is 2.8633.

SCENARIO 13-9 It Is Believed That, the Average Numbers of Hours Spent