Requirements space Part 1 Create a new Microsoft Excel spreadsheet and conduct a benchmarking study comparing the performance of the three mens' basketball teams side-by-side: Indiana Hoosiers, Kentucky Wildcats, and Louisville Cardinals, during the 2017-2018 season. Please use data from the websites listed above. (58 points) 1. Include the following performance indicators for each team (21 points) Number of games won (for the 2017-2018 season) o nter Number of games lost (for the 2017-2018 season) o PTS -Total Points G -Games (i.e., number of game played during the 2017-2018 season) o o o FG%--Field Goal Percentage hift 2P%-2-Point Field Goal Percentage TOV-Total Turnovers (for the 2017-2018 season) 2. Write an Excel formula to calculate the following statistics for each team (9 points) Win-lose percentage (WAL%) Number of games won / Total number of games played Average points per game Total Points /Total number of games played o 3. Structure the spreadsheet so that it's easy to read and understand the information 4. Include the first worksheet called "Documentation" showing your name, date, and 5. Provide TWO additional performance indicators as you think are appropriate. (8 6. Use clear titles, labels, sheet name, file name, and other appropriate spreadsheet o Average Turnovers per Game = Total Turnovers / Total number of games played presented. (5 points) the purpose of this spreadsheet. (5 points) points) formats (e.g., font type, size, colors, borders, etc.) so users can easily locate the information. (5 points) 7. Apply appropriate settings so that all information will be printed on one page. Include appropriate information on the Page Header and Page Footer to make it as clear as possible (5 points) Requirements space Part 1 Create a new Microsoft Excel spreadsheet and conduct a benchmarking study comparing the performance of the three mens' basketball teams side-by-side: Indiana Hoosiers, Kentucky Wildcats, and Louisville Cardinals, during the 2017-2018 season. Please use data from the websites listed above. (58 points) 1. Include the following performance indicators for each team (21 points) Number of games won (for the 2017-2018 season) o nter Number of games lost (for the 2017-2018 season) o PTS -Total Points G -Games (i.e., number of game played during the 2017-2018 season) o o o FG%--Field Goal Percentage hift 2P%-2-Point Field Goal Percentage TOV-Total Turnovers (for the 2017-2018 season) 2. Write an Excel formula to calculate the following statistics for each team (9 points) Win-lose percentage (WAL%) Number of games won / Total number of games played Average points per game Total Points /Total number of games played o 3. Structure the spreadsheet so that it's easy to read and understand the information 4. Include the first worksheet called "Documentation" showing your name, date, and 5. Provide TWO additional performance indicators as you think are appropriate. (8 6. Use clear titles, labels, sheet name, file name, and other appropriate spreadsheet o Average Turnovers per Game = Total Turnovers / Total number of games played presented. (5 points) the purpose of this spreadsheet. (5 points) points) formats (e.g., font type, size, colors, borders, etc.) so users can easily locate the information. (5 points) 7. Apply appropriate settings so that all information will be printed on one page. Include appropriate information on the Page Header and Page Footer to make it as clear as possible (5 points)
