The provided Excel file contains a single sheet named STF302BCH23, which appears to include data related to YABA COLLEGE OF TECHNOLOGY, specifically for the course STF302 LABORATORY MGT/GLASS BLOWING. The initial rows contain header and title information, with the following columns identified:

To analyze the correlation between grades and attendance, we need to identify which columns represent grades and if any column explicitly represents attendance. The provided preview does not show an attendance column, so further inspection of the dataset is needed to locate this information, if available.

We've successfully cleaned and prepared the dataset from the STF302BCH23 sheet, which contains student scores for a course at YABA COLLEGE OF TECHNOLOGY. The data includes:

Next, we will visualize the relationships between the continuous assessment scores, exam scores, and total scores to explore potential correlations.

We've successfully cleaned and analyzed the dataset from the STF302BCH23 sheet, containing student scores for a course at YABA COLLEGE OF TECHNOLOGY. Here's what was done:

Findings:

This analysis helps in understanding how different components of students' grades relate to each other, though it does not directly address the correlation between grades and attendance due to the absence of attendance data.

We tested the null hypothesis that every student with a CA score less than 20 had a total score of less than 50. The results from the one-sample t-test are:

Interpretation:

Given the p-value is less than 0.05, we reject the null hypothesis. This suggests that not all students with a CA score less than 20 have a total score of less than 50. There is statistically significant evidence that some students with CA scores less than 20 have total scores greater than 50.