Background: About Eagleball Eagleball is an extremely popular sport in the Kogod community, with each match attended by hundreds of thousands of fans, and streamed at home by millions more. It brings in billions of dollars in revenue per year, and the more successful a team is, the greater its share of revenue. Therefore, teams are constantly striving to exploit every possible advantage. Your challenge will be to select the players who will help your team finish at the top of the league! Eagleball is a very complicated sport. The rulebook is over 2000 pages long, and is updated every month. (It is estimated that fewer than ten fans worldwide have read the entire thing.) Luckily for you, it is not necessary to know all of the details of how the game is played. You will be relying on two datasets, and this short summary: An Eagleball team consists of three strikers, three defenders, one goalie, and one trainer. The strikers are the offensive players who take shots on the opponents' goal. Each successful shot gives the team a point. The defenders try both to steal the ball from the strikers and to prevent them from taking shots, and the goalie's job is to block shots. The trainer's only job is to coax Clawed back to the team's goal. (Clawed has a short attention span, and tends to wander aimlessly around the field.) When Clawed is touching a team's goal for five seconds uninterrupted, the team receives five points, and the match ends. If the score is tied, then the next successful shot wins the game. The Data: You will need to use the Eagleball Data Excel file for this competition. The file contains macros that are necessary for doing the activity! There are many ways to control macro settings in Excel, and the details vary by version. If you do not know how to enable macros in a workbook, see the following links for explanation: https://support.office.com/en-us/article/enable-or-disable-macros-in-office-files-12b036fd-d140-4e74- b45e-16fed1a7e5c6 https://support.microsoft.com/en-us/office/enable-or-disable-macros-in-office-for-mac-c2494c99-a637- 4ce6-9b82-e02cbb85cb96?ui=en-us&rs=en-us&ad=us The "GameMetrics" sheet contains eight variables describing a team's performance in a given match. The first six columns are rates or percentages describing how well the team performed. Column G indicates whether the team scored the five points from Clawed or not, and Column H indicates whether the team won or not. A brief description of each variable is given in the "MetricDescriptions" sheet. The "Players" sheet contains information on all of the players available for you to select. Note that the variables describing the players are different for each position. They are all related to the variables in the GameMetrics sheet. However, for the strikers and defenders, the variables refer only to that individual player, not the entire team. (For instance, if a defender's Shots Against/Hr = 10, that means that, on average, opposing teams take 10 shots per hour for which this player is the nearest defender.) Each player also has a salary, indicating the cost of selecting that player. Your Task: