Story Inferred in the Data:
The story inferred within this data, while broad, condenses the average GPA of each major department and ultimately discerns what majors are possibly most intensive.
Here is the Link to my Spreadsheet
Process of Working with the Data:
Truth be told, I was honestly quite confused. For my pivot table I selected the rows to be the department’s, and the values to be the average gpa. However I am not entirely sure if this is an accurate reflection of true-to-life data, as I removed the “total” aspect due to the fact that it did not inherently make sense to include. I converted the pivot table into a clustered column.
