please show the formula

Consider the following data set which shows the annual excess revenue for the 36 flms listed: 1. Find the average, maximum, minimum, median, average of the top four firms, average of the bottom four firms for each year 2 Construct a graph which has the capability of comparing anyone of these metrics (caiculated in 1.)to LighthouseCredit Foundation's excess revenues. Make sure that your graph is interactive and displays the correct legends automatically using a combination box tool. 3 Use the appropriate Ranking order( L.e., descending lacsending) to RANK the bottom 10 values in 2017 , the top ten values in 2019 and the top ten values in 2021. 4 For each of these years, create a list of the firm' names. 2017 bottom ten firms, 2019 top ten firms and 2021 top ten firms This list will state the firms by name. (Use the INDEX/MATCH combination). Place in the yellow box to the right. Consider the following data set which shows the annual excess revenue for the 36 flms listed: 1. Find the average, maximum, minimum, median, average of the top four firms, average of the bottom four firms for each year 2 Construct a graph which has the capability of comparing anyone of these metrics (caiculated in 1.)to LighthouseCredit Foundation's excess revenues. Make sure that your graph is interactive and displays the correct legends automatically using a combination box tool. 3 Use the appropriate Ranking order( L.e., descending lacsending) to RANK the bottom 10 values in 2017 , the top ten values in 2019 and the top ten values in 2021. 4 For each of these years, create a list of the firm' names. 2017 bottom ten firms, 2019 top ten firms and 2021 top ten firms This list will state the firms by name. (Use the INDEX/MATCH combination). Place in the yellow box to the right