Notebook

Jul 16, 2024, 7:40 PM

BIO Lab Class Data for Analysis vizly more detailed.xlsx

Missing file

How do grades correlate with TEAS scores?

To analyze the correlation between grades and TEAS scores, we need to focus on the columns representing grades and the TEAS Score. The relevant columns are:
  • BIO201 Grade
  • BIO201A Grade
  • BIO202 Grade
  • BIO202A Grade
  • BIO203 Grade
  • BIO203A Grade
  • BST322 Grade
  • TEAS Score
Let's clean the data and calculate the correlation between these grades and the TEAS scores.
The correlation matrix shows the relationship between the grades in various courses and the TEAS scores. Here are some key observations:
  • The highest correlation with TEAS scores is with BIO202 Grade (0.371), followed by BIO201 Grade (0.326) and BIO202A Grade (0.323).
  • The lowest correlation with TEAS scores is with BIO203A Grade (0.183).
  • All correlations are positive, indicating that higher grades in these courses are associated with higher TEAS scores.
Let's visualize these correlations to get a better understanding.
The analysis reveals that grades in various courses have a positive correlation with TEAS scores. The highest correlations are with BIO202 Grade (0.371), BIO201 Grade (0.326), and BIO202A Grade (0.323). The lowest correlation is with BIO203A Grade (0.183). This suggests that better performance in these courses is associated with higher TEAS scores. A bar plot was created to visualize these correlations.
Feel free to ask any further questions or request additional analyses!
Get started with Vizly