Question

21: The director of graduate studies at a large college of business would like to be able to predict the grade point average (GPA) of students in an MBA program based on the Graduate Management Aptitude Test (GMAT) score. A sample of 20 students who have completed 2 years in the program is selected; the results are listed in Excel worksheet “Score”. What is the correlation coefficient between the dependent and independent variable?

GMAT	GPA
688	3.72
647	3.44
652	3.21
608	3.29
680	3.91
617	3.28
557	3.02
599	3.13
616	3.45
594	3.33
567	3.07
542	2.86
551	2.91
573	2.79
536	3.00
639	3.55
619	3.47
694	3.60
718	3.88
759	3.76

A. 0.89

B. 0.80

C. 0.79

D. -0.89

E. None of the choices

Answer 1

We can directly calculate correlation coefficient by using Excel.

Step 1)  Enter data in Excel.

Step 2 )  Then use =CORREL command and select two separate column data  >> ok

A. 0.89