The following data show the results of an aptitude test (Y) and the grade point average of 10 students. Either enter the data into Excel or Minitab or use the appropriate formulas in Ch. 14 to get the answers to parts a through d below. Show on attached Excel or Minitab sheet where you got your answers, or copy and paste the answers from same. Aptitude Test Score (Y) GPA (X)
26 1.8
31 2.3
28 2.6
30 2.4
34 2.8
38 3.0
41 3.4
44 3.2
40 3.6
43 3.8
a. Show the estimated regression equation
b. Compute the coefficient of determination and comment on the strength of the regression relationship.
c. At 95% confidence, test to determine if the model is significant (i.e., perform an F test). Show calculations needed to get F-score.