I’m working on a Excel question and need guidance to help me study.
In this exercise, you will be asked to create a measure of Competitive Balance for each of our Fantasy Baseball Leagues. Due to circumstances, we have used a simulation software to simulate the season. Your task is to explore the data for each League and complete the tables below to create a Lorenz Curve. Remember: to run a proper Lorenz curve, the league must be ranked in ascending order by points (The team with the least amount of points should be listed 1st, the team with the most points should be listed 10th). To find the League data for each league, click on the A, B, C, or D worksheet tabs below. Click A for League A, B for League B, C for League C, and D for League D. In the League data, you will see simulation results for each player subset into individual teams. In the far right, you will see the League Standings. This is the data you will need to finish this assignment. A picture of the table is shown to the right. **Remember to invert the standings for this exercise