Lying in weights

You just calculated weighted averages based on period 1 and period 2 grades. Are you ready to conclude whether period 1 or period 2 grades are more predictive of students' final grades?

Play around with the weights used in the weighted averages and compare the result to the actual final grades in column A. Does it look like period 1 or period 2 grades are better predictors of final grades?