18) The director of graduate admissions as a large university is analyzing the relationship between scores on the math portion of the Graduate Record Examination (GRE) and subsequent student performance in graduate school, as measured by a student's grade point average (GPA). She uses a sample of 24 students who graduated within the past five years. The data points are listed below.

a) Find the sample regression equation for the model: GPA = 0+ 1*GRE (hint: use the regression function in EXCEL)

b) What % of the variability is explained by the model?

c) What is the predicted GPA of a student who scored 710 on the math portion of the GRE

GPA. GRE

3.0. 700

3.5 720

3.2 650

3.7 750

3.1 680

3.9 730

3.3. 740

3.5. 780

3.0 690

3.5. 730

3.2. 640

3.7 740

3.1 690

3.9 720

3.3 740

3.5 750

2.9 690

3.3. 730

3.3 640

3.6 740

3.0 690

3.8 720

3.2. 740

3.5 760