Please show the steps, thank you so much!!

The table below shows the sales data for all the salespeople at Oscorp Industries last year, including the region they work in their name, the number of new customers they acquired last year, and their total sales volume. Sort the data by sales volume and use a formula to assign each salesperson a rank, so that the salesperson with the highest sales volume in the company is ranked 1 and the salesperson with the second highest sales volume in the company is ranked 2, etc. Salespeople that have the same sales volume should get the same rank, and the salesperson with the next highest sales volume should get assigned the next highest rank. For instance, if you have four salespeople with sales volume of $500,000, $400,000, $400,000, and $250,000, they should be ranked 1, 2, 2, 3, not 1, 2, 2, 4. (4 points total) Next, calculate what each salesperson's total bonus should be. Salespeople that have a rank of 48 or better in the company will receive a bonus of $16,000 and salespeople with at least 11 new customers will receive a bonus of $13,000. Salespeople can earn both bonuses, and salespeople who don't meet either criteria should be assigned a bonus of $0. (4 points total) Finally, calculate the total number of new customers and the average sales volume for each region. (4 points total) Region Name New Customers Sales Volume Rank Bonus Region Total New Customers Average Sales Volume Midwest Northeast South West Midwest Amanda Nelson Northeast Marguerite Luna Midwest Aaron Jackson Northeast Clara Delgado Northeast Jason Johnson Midwest Michelle Miller South Tina Green South Angelica Craig South Joan Lopez South Kristine Mccormick South Morgan Binder Midwest Marty Wong 10 Y 490,000 15 Y 880,000 12 Y 550,000 9 Y 460,000 12 X 630,000 9 Y 650,000 8 X 690,000 9 Y 460,000 1 Y 100,000 12 Y 730,000 18 1,110,000 8 Y 420,000