DAIF V case Study. NFL Data, Pivot Tables, and Visualization Our first case study was adapted from the INFORMS Transactions on Education article "Case-Converting Point Spreads into Probabilities: A Case Study for Teaching Business Analytics" by Eric Huggins, Matt Bailey and Ivan Guardiola. I will post their case study for you to review, but your requirements are listed here. Please submit your Excel spreadsheet with the answers to each of the questions. Suspense: Thursday, 17 September at the beginning of class (5 pm). 1. Using the spreadsheet (NFL_Scores.xlsx) provided with data from the NFL 2013-16 seasons: a. Determine for each point spread what proportion of games are won by the favorite and what proportion are won by the underdog. This will be most easily by using a Pivot Table