Overview
When deciding whether to admit an applicant, colleges take lots of factors, such as grades, sports, activities, leadership positions, awards, teacher recommendations, and test scores, into consideration. Using SAT scores as a basis of whether to admit a student or not has created some controversy. Among other things, people question whether the SATs are fair and whether they predict college performance.
This study examines the SAT and GPA information of 105 students who graduated from a state university with a B.S. in computer science. Using the grades and test scores from high school, can you predict a student's college grades?
Note this study investigates computer science majors only. Conclusions from this study should not be generalized to students of other majors.
Data Analysis
Draw a scatterplot comparing the students' high school GPAs to their overall university GPAs. Does there appear to be a relationship? What type?
What is the correlation between high school GPA and overall university GPA? How would you describe the strength?
Find the regression line for predicting the overall university GPA from the high school GPA.
What is the slope of the equation and what does it tell us?
What is the r-square value and what does it tell us?
If someone had a 4.0 GPA in high school, what is the best estimate of his or her college GPA?
What is the correlation between the students' TOTAL SAT scores and their overall university GPA? What is the strength of the relationship?
Find the regression line for predicting overall university GPA from TOTAL SAT scores.
What is the regression equation? What is the r-square?
If someone scored a 1200 combined score on the SAT, what would their predicted GPA be?
Based on your analysis of the data, which is a better predictor of college GPA: High school GPA or SAT scores? Support your answer specifically using the outcomes of your data analyses.
high_GPA
3.45
2.78
2.52
3.67
3.24
2.1
2.82
2.36
2.42
3.51
3.48
2.14
2.59
3.46
3.51
3.68
3.91
3.72
2.15
2.48
3.09
2.71
2.46
3.32
3.61
3.82
2.64
2.19
3.34
3.48
3.56
3.81
3.92
4
2.52
2.71
3.15
3.22
2.29
2.03
3.14
3.52
2.91
2.83
2.65
2.41
2.54
2.66
3.21
3.34
3.68
2.84
2.74
2.71
2.24
2.48
3.14
2.83
3.44
2.89
2.67
3.24
3.29
3.87
3.94
3.42
3.52
2.24
3.29
3.41
3.56
3.61
3.28
3.21
3.48
3.62
2.92
2.81
3.11
3.28
2.7
2.62
3.72
3.42
3.51
3.28
3.42
3.9
3.12
2.83
2.09
3.17
3.28
3.02
3.42
3.06
2.76
3.19
2.23
2.48
3.76
3.49
3.07
2.19
3.46
math_SAT
643
558
583
685
592
562
573
559
552
617
684
568
604
619
642
683
703
712
564
557
591
599
607
619
700
718
580
562
683
717
701
691
714
689
554
564
668
691
573
568
607
651
604
560
604
574
564
607
619
647
651
571
583
554
568
574
605
591
642
608
574
643
608
709
691
667
656
554
692
684
717
712
641
675
692
684
564
554
685
671
571
582
621
651
673
651
672
591
582
609
554
612
628
567
619
691
564
650
551
568
605
692
680
617
516
verb_SAT
589
512
503
602
538
486
548
536
583
591
649
592
582
624
619
642
684
652
501
549
584
562
619
558
721
732
538
507
648
724
714
684
706
673
507
543
604
662
591
517
624
683
583
542
617
548
500
528
573
608
683
543
510
538
519
602
619
584
608
573
538
607
649
688
645
583
609
542
563
672
649
708
608
632
698
609
591
509
694
609
503
591
589
642
681
640
607
587
612
555
480
590
580
602
623
683
549
684
554
541
590
683
692
503
528
comp_GPA
3.76
2.87
2.54
3.83
3.29
2.64
2.86
2.03
2.81
3.41
3.61
2.48
3.21
3.52
3.41
3.52
3.84
3.64
2.14
2.21
3.17
3.01
3.17
3.01
3.72
3.78
2.51
2.1
3.21
3.68
3.48
3.71
3.81
3.84
2.09
2.17
2.98
3.28
2.74
2.19
3.28
3.68
3.17
3.17
3.31
3.07
2.38
2.94
2.84
3.17
3.72
2.17
2.42
2.49
3.38
2.07
3.22
2.71
3.31
3.28
3.19
3.24
3.53
3.72
3.98
3.09
3.42
2.07
3.17
3.51
3.49
3.51
3.4
3.38
3.54
3.48
3.09
3.14
3.28
3.41
3.02
2.97
4
3.34
3.28
3.32
3.51
3.68
3.07
2.78
3.68
3.3
3.34
3.17
3.07
3.19
2.15
3.11
2.17
2.14
3.74
3.27
3.19
2.98
3.28
univ_GPA
3.52
2.91
2.4
3.47
3.47
2.37
2.4
2.24
3.02
3.32
3.59
2.54
3.19
3.71
3.58
3.4
3.73
3.49
2.25
2.37
3.29
3.19
3.28
3.37
3.61
3.81
2.4
2.21
3.58
3.51
3.62
3.6
3.65
3.76
2.27
2.35
3.17
3.47
3
2.74
3.37
3.54
3.28
3.39
3.28
3.19
2.52
3.08
3.01
3.42
3.6
2.4
2.83
2.38
3.21
2.24
3.4
3.07
3.52
3.47
3.08
3.38
3.41
3.64
3.71
3.01
3.37
2.34
3.29
3.4
3.38
3.28
3.31
3.42
3.39
3.51
3.17
3.2
3.41
3.29
3.17
3.12
3.71
3.5
3.34
3.48
3.44
3.59
3.28
3
3.42
3.41
3.49
3.28
3.17
3.24
2.34
3.28
2.29
2.08
3.64
3.42
3.25
2.76
3.41
high_GPA univ_GPA 3.45 3.52 2.78 2.91 2.52 2.4 3.67 3.47 3.24 3.47 2.1 2.37 2.82 2.4 2.36 2.24 2.42 3.02 3.51 3.32 3.48 3.59 2.14 2.54 2.59 3.19 3.46 3.71 3.51 3.58 3.68 3.4 3.91 3.73 3.72 3.49 2.15 2.25 2.48 2.37 3.09 3.29 2.71 3.19 2.46 3.28 3.32 3.37 3.61 3.61 3.82 3.81 2.64 2.4
.
High-Univ Relationship
y=0.6748x+1.0968
high_GPA univ_GPA high_GPA 1 univ GPA0.7795631 1
3.5 Univ GPA 2.5
R=0.607
Series1 Linear (Series1)
2
2.5
3 3.5 High GPA
4
4.5
0.779563
r=0.78 Slope= 0.67483 Intercept=1.096823
