The file S02_10.xlsx contains midterm and final exam scores for 96 students in a corporate finance course.
a. Create a histogram for each of the two sets of exam scores.
b. What are the mean and median scores on each of these exams?
c. Explain why the mean and median values are different for these data.
d. Based on your previous answers, how would you characterize this group’s performance on the midterm and on the final exam?
e. Create a new column of differences. A positive value means the student improved, and a negative value means the student did the opposite. What are the mean and median of the differences? What does a histogram of the differences indicate?