Analyzing Average Scores by Department in the Student Data

Apr 3, 2024, 9:38 PM

What is the average score by Department?

The data appears to contain a lot of unnamed columns and rows with missing values at the beginning, which suggests that the relevant data might start further down in the sheet. We'll need to identify the correct starting row and the relevant columns to calculate the average score by department.

Summary of Findings

  • The average scores by department are as follows:
    • Linguistics: 34.25
    • Modern European Languages: 51.30

Test the null hypothesis which states that there will be no statistically significant difference in the posttest scores of students in the two departments

Hypothesis Testing Summary

  • T-statistic: -6.77
  • P-value: 4.22e-09
Given the very low p-value (4.22e-09), we reject the null hypothesis. This indicates that there is a statistically significant difference in the posttest scores of students between the Linguistics and Modern European Languages departments.

Explore the distribution of posttest scores in each department

Distribution of Posttest Scores Summary

  • The histogram shows the distribution of posttest scores for each department.
  • Linguistics scores are generally lower, clustering around the 30-40 range.
  • Modern European Languages scores are higher, with a broader distribution, peaking around the 50-60 range.
  • This visual representation supports the statistical test findings, indicating a significant difference in scores between departments.

Visualize this for me

Get started with Vizly