Vizly: AI-powered data analysis

Try for yourself

Exploring Student Academic Records in 100 LEVEL Excel File

What is the distribution of data in the file?

The data in the 100 LEVEL.xlsx file, specifically from the first sheet after skipping initial metadata rows, includes the following columns:
  • S/N: Serial number (some missing values)
  • Matric No: Matriculation number of the student
  • Name: The first and last name of the student
  • An unnamed column that likely represents the middle name or additional names
  • CA: Continuous Assessment score
  • Exam: Exam score
  • Total: Total score (CA + Exam)
  • Grade: The grade obtained
The data seems to be student academic records, including their scores and grades for a particular course or semester.

Test the hypothesis that there is no statistically significant correlation between CA scores and Total scores for the students

Hypothesis Test Summary

  • Pearson correlation coefficient: -0.678
  • p-value: 0.002756
Conclusion: We reject the null hypothesis, indicating there is a statistically significant correlation between CA scores and Total scores for the students. The negative correlation coefficient suggests that as CA scores increase, Total scores tend to decrease, which is an unexpected trend.

Vizly

AI-powered data analysis

Try for yourself