Use Excel to nd Lorenz Curve for MLB and NHL for the 2016 season. This assignment requires familiarity in using EXCEL. If you have trouble completing this question you should see me for assistance. For this problem you can nd historical data using the following links: http://wwwbaseball reference.com and http://www hockeyreference.com. (a) What is the total number of wins in a season for MLB? What is the total number of wins in a season for NHL? [2 Points] (b) Using Excel plot the \"ideal\" Lorenz curve. Label the axes. [2 Points] (c) Find the number of wins for each team in MLB for the 2016 season. Rank the teams based on the number of wins. Use this data to complete the last two columns of the table. Note: In the 2016 season, 3 games were cancelled due to weather, thus your % of total wins will not equal 100% for 100% of teams. [5 Points] Total % of Teams Number of Wins % of Total Wins 0 0 Bottom 10% 0.10 0.30 0.50 0.60 0 .70 0.90 To u 10% 1.00 (d) Find the number of wins for each team in NHL. for the 201617 season. Rank the teams based on the number of wins. Use this data to complete another table similar to the table for baseball. [5 Points] (e) Use EXCEL to plot the Lorenz curve for both MLB and NHL. in the 2016 season, using the same figure used in Part (b). [8 Points] (f) Based on your Figure in Part (e), which league has more competitive balance, MLB or NHL? Briey explain your answer. [2 Points]