Use a pivot table to see if a relationship exists between GPA and year a. On average, do students in their rst year do better than those in year 2, who do better than those in year 3, who do better than those in year 4? Or does progress run in the other direction? Dr is there no real difference by year? To answer these questions, make a pivot table on a separate sheet that relates academic year with average GPA. i. Year should be the Rows eld ii. GPA should be the Values field iii. Change the summary type using the 1y'alue field settings to make sure you have Average For GPA iv. Rename the sheet containing the pivot table BY YEAR b. The Dean tells you that if each year-toyear difference increases (or decreases]: and if each change is at least .03, you can conclude that there is a relationship between 3