high_GPA Can the math and verbal SAT scores be used to predict college GPA? Are
ID: 3237225 • Letter: H
Question
high_GPA
Can the math and verbal SAT scores be used to predict college GPA? Are the high school and college GPAs related?
In Question 1: Math SAT Score and verbal SAT score are your independent variables; and your dependent variable is college GPA. All of these are quantitative variables. Therefore you will do two separate simple linear regression. One regression will be with Math SAT score as the independent variable and college GPA as the dependent variable; and the second regression will be with verbal SAT score as the independent variable and college GPA as the dependent variable.
2) you would do a correlation between high school and college GPA as both are quantitative variables.
3) Analysis plan: your hypothesis and the relevant statistical technique
4) Results of your hypothesis test
5) Interpretation of your hypothesis test
6) Overall conclusions
7) Suggestions for improvement of the study.
Please use the simple linear regression (THIS IS MY FINAL PROJECT) Thank You
math_SAT verb_SAT comp_GPA univ_GPA 3.46 516 528 3.28 3.41 2.23 551 554 2.17 2.29 2.42 552 583 2.81 3.02 2.52 554 507 2.09 2.27 2.71 554 538 2.49 2.38 2.24 554 542 2.07 2.34 2.81 554 509 3.14 3.2 2.09 554 480 3.68 3.42 2.48 557 549 2.21 2.37 2.78 558 512 2.87 2.91 2.36 559 536 2.03 2.24 2.83 560 542 3.17 3.39 2.1 562 486 2.64 2.37 2.19 562 507 2.1 2.21 2.15 564 501 2.14 2.25 2.71 564 543 2.17 2.35 2.54 564 500 2.38 2.52 2.92 564 591 3.09 3.17 2.76 564 549 2.15 2.34 3.02 567 602 3.17 3.28 2.14 568 592 2.48 2.54 2.03 568 517 2.19 2.74 2.24 568 519 3.38 3.21 2.48 568 541 2.14 2.08 2.84 571 543 2.17 2.4 2.7 571 503 3.02 3.17 2.82 573 548 2.86 2.4 2.29 573 591 2.74 3 2.41 574 548 3.07 3.19 2.48 574 602 2.07 2.24 2.67 574 538 3.19 3.08 2.64 580 538 2.51 2.4 2.62 582 591 2.97 3.12 3.12 582 612 3.07 3.28 2.52 583 503 2.54 2.4 2.74 583 510 2.42 2.83 3.09 591 584 3.17 3.29 2.83 591 584 2.71 3.07 3.9 591 587 3.68 3.59 3.24 592 538 3.29 3.47 2.71 599 562 3.01 3.19 2.59 604 582 3.21 3.19 2.91 604 583 3.17 3.28 2.65 604 617 3.31 3.28 3.14 605 619 3.22 3.4 3.76 605 590 3.74 3.64 2.46 607 619 3.17 3.28 3.14 607 624 3.28 3.37 2.66 607 528 2.94 3.08 2.89 608 573 3.28 3.47 3.29 608 649 3.53 3.41 2.83 609 555 2.78 3 3.17 612 590 3.3 3.41 3.51 617 591 3.41 3.32 2.19 617 503 2.98 2.76 3.46 619 624 3.52 3.71 3.32 619 558 3.01 3.37 3.21 619 573 2.84 3.01 3.42 619 623 3.07 3.17 3.72 621 589 4 3.71 3.28 628 580 3.34 3.49 3.28 641 608 3.4 3.31 3.51 642 619 3.41 3.58 3.44 642 608 3.31 3.52 3.45 643 589 3.76 3.52 3.24 643 607 3.24 3.38 3.34 647 608 3.17 3.42 3.19 650 684 3.11 3.28 3.52 651 683 3.68 3.54 3.68 651 683 3.72 3.6 3.42 651 642 3.34 3.5 3.28 651 640 3.32 3.48 3.52 656 609 3.42 3.37 3.42 667 583 3.09 3.01 3.15 668 604 2.98 3.17 3.28 671 609 3.41 3.29 3.42 672 607 3.51 3.44 3.51 673 681 3.28 3.34 3.21 675 632 3.38 3.42 3.07 680 692 3.19 3.25 3.68 683 642 3.52 3.4 3.34 683 648 3.21 3.58 3.48 684 649 3.61 3.59 3.41 684 672 3.51 3.4 3.62 684 609 3.48 3.51 3.67 685 602 3.83 3.47 3.11 685 694 3.28 3.41 4 689 673 3.84 3.76 3.81 691 684 3.71 3.6 3.22 691 662 3.28 3.47 3.94 691 645 3.98 3.71 3.06 691 683 3.19 3.24 3.29 692 563 3.17 3.29 3.48 692 698 3.54 3.39 3.49 692 683 3.27 3.42 3.61 700 721 3.72 3.61 3.56 701 714 3.48 3.62 3.91 703 684 3.84 3.73 3.87 709 688 3.72 3.64 3.72 712 652 3.64 3.49 3.61 712 708 3.51 3.28 3.92 714 706 3.81 3.65 3.48 717 724 3.68 3.51 3.56 717 649 3.49 3.38 3.82 718 732 3.78 3.81Explanation / Answer
q1.
next steps is to use anova a test to compare the three models.first model will be having math_GPA as independent variable.second model will have verbal_GPA .and third model will have both variables
the less value of p-value for the third model( having both variables ) is less than significant level 0.05 concludes to reject the null hyothesis and conclude finally that the math and verbal SAT scores acn be used to predict college GPA.
Analysis of Variance Table H0:null hypothesis : all models are equal Ha: alternate hypothesis : all models are different Model 1: univ_GPA ~ math_SAT Model 2: univ_GPA ~ verb_SAT Model 3: univ_GPA ~ verb_SAT + math_SAT Res.Df RSS Df Sum of Sq F Pr(>F) 1 103 11.662 2 103 12.003 0 -0.34089 3 102 11.018 1 0.98438 9.1126 0.003207 ** --- Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1
the less value of p-value for the third model( having both variables ) is less than significant level 0.05 concludes to reject the null hyothesis and conclude finally that the math and verbal SAT scores acn be used to predict college GPA.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.