Please try to attempt and help on all these problems. I would greatly appreciate it! Thank you!

C.) without using the AVERAGE function, what would you use in cell H16 to render the same result?

D.) what formula would you use in cell H17 to obtain the correct result?

E.) What formula would you use in cell H18 to obtain the correct result?

F.) what formula would you use to find the most frequently occurring asking price for these homes?

uie spieausleet fihage difctly below and then answer the following questions based on the information provided. Judson Ford Realty-October Sales % of Asking Price Per Commision Square Foot Net to Home feetlAsking Price Sales Price 122 West 75 Street 4567 S.W. 95 Street 123 Alamo Road 9000 Brickell Avenue 5596 Powertine Road 8900 N.w 89 Street 75 Maynada Avenue 4,000 S40,000 350,000 5,750 S 750,000 $648,000 3,000 S 350,000 $ 275,000 2.500 275,000 | $ 250,000 2,250 $ 189,000 $ 189,000 4,200 S 456,000$ 290,000 2.475 300.000 S 265,000 77.8%| S 86.4%| $ 78.6%| s 90.9% 100.0%| s 63.6%) $ 88.3%l s 87.50 $ 12,250.00 $ 337,750.00 112.70 $ 22,680.00 S 625,320.00 91.67 S 9,625.00 s 265,375.00 100.00 S 8.750.00 S 241.250.00 84.00 S6,615.00 S 182,385.00 69.05 S 10,150.00 S 279850.00 10707|$ 9275.00 255725.00 24,175 2,770,000 2,267,000 79,345$ 2187,655 Averages: Commission 83.7%) $ 93.14 Realtor: Your Name Goes Here 3.50% S Notes: 6 1. The commission is paid on the actual sales price, not the asking price ) 2 The price per square foot is based on the sales price, not the asking price Average sales price S 323,857 Maximum nles price S 648,000 Minimum sales price $ 189,000 3. The net to the home owner is the actual sales price minus the commission. (a) Compute the total commission for all homes sold by writing the formula that belongs in cell G11. (b) Using a sirgle function, what formula would you use in cell H16 to obtain the correct result