Statistical Analysis of Academic Performance: Correlation, Prediction, and Data Comparison
Analyzes statistical correlations and predictions in academic performance.
Andrew Taylor
Contributor
4.3
40
30 days ago
Preview (3 of 8)
Sign in to access the full document!
Statistical Analysis of Academic Performance: Correlation, Prediction, and Data
Comparison
1. Correlation, Scatterplots, and Prediction
a) Which relationship is stronger, the relationship between GPA and AGE or the
relationship between GPA and SAT score? Be sure to include all appropriate measures
and explain and defend your answer. Is this result what you would expect, why or why
not?
Correlation between GPA and AGE 0.233751
Correlation between GPA and SAT score 0.320311
Looking at the correlation values we see that the correlation between GPA and SAT is more than
GPA and AGE. Hence the relationship between GPA and SAT score is stronger than the
relationship between GPA and AGE. The result is as expected as GPA and SAT both being related
to scores are more correlated to each other than AGE.
b) Create and paste in a scatterplot that compares Final Exam Score and Project Score.
What is the correlation (r-value)? How would you describe the correlation (positive,
negative, strong, weak, medium, none)? Include the “trendline” and “equation of the
trendine” as part of your scatterplot.
The correlation (r-value) = sqrt(.1429) = .378
y = 0.2836x + 54.747
R² = 0.1429
0
20
40
60
80
100
120
0 20 40 60 80 100 120
Project score
Final exam score
Comparison
1. Correlation, Scatterplots, and Prediction
a) Which relationship is stronger, the relationship between GPA and AGE or the
relationship between GPA and SAT score? Be sure to include all appropriate measures
and explain and defend your answer. Is this result what you would expect, why or why
not?
Correlation between GPA and AGE 0.233751
Correlation between GPA and SAT score 0.320311
Looking at the correlation values we see that the correlation between GPA and SAT is more than
GPA and AGE. Hence the relationship between GPA and SAT score is stronger than the
relationship between GPA and AGE. The result is as expected as GPA and SAT both being related
to scores are more correlated to each other than AGE.
b) Create and paste in a scatterplot that compares Final Exam Score and Project Score.
What is the correlation (r-value)? How would you describe the correlation (positive,
negative, strong, weak, medium, none)? Include the “trendline” and “equation of the
trendine” as part of your scatterplot.
The correlation (r-value) = sqrt(.1429) = .378
y = 0.2836x + 54.747
R² = 0.1429
0
20
40
60
80
100
120
0 20 40 60 80 100 120
Project score
Final exam score
Preview Mode
Sign in to access the full document!
100%
Study Now!
XY-Copilot AI
Unlimited Access
Secure Payment
Instant Access
24/7 Support
Document Chat
Document Details
Subject
Statistics