The administrator of a new paralegal program at Seagate Technical College wants to estimate the grade point average in the new program. He thought that high school GPA, the verbal score on the Scholastic Aptitude Test (SAT), and the mathematics score on the SAT would be good predictors of paralegal GPA. The data on nine students are:
| Student |
High School GPA |
SAT verbal |
SAT math |
Paralegal GPA |
| 1 |
3.25 |
480 |
410 |
3.21 |
| 2 |
1.80 |
290 |
270 |
1.68 |
| 3 |
2.89 |
420 |
410 |
3.58 |
| 4 |
3.81 |
500 |
600 |
3.92 |
| 5 |
3.13 |
500 |
490 |
3.00 |
| 6 |
2.81 |
430 |
460 |
2.82 |
| 7 |
2.20 |
320 |
490 |
1.65 |
| 8 |
2.14 |
530 |
480 |
3.30 |
| 9 |
2.63 |
469 |
440 |
2.33 |
QUES: What is the predicted Paralegal GPA for a high School GPA of 3.53, a Verbal SAT of 560, and a Math SAT of 450?
Hint: On your worksheet, list Paralegal GPA last and the independent variables beginning with the math SAT. Be sure to highlight 3 rows and 4 columns before you type your LINEST function.