We learned the functions COUNTIF, AVERAGEIF, and SUMIF. Using the data and solutions in the Q6 tab of this workbook, determine the following: 10 points How many houses sold have the following commision rates? Commission rate # of houses 6.00% 5.75% 5.50% 5.25% 5.00% 4.75% 4.50% 4.25% What was the average selling price for the homes in each commission rate category? Commission rate average Sale Price 6.00% 5.75% 5.50% 5.25% 5.00% 4.75% 4.50% 4.25% What were the total commission $ for each agent. Commission rate Total Commission $ Agent 1 Agent 2 Agent 3 Agent 4 Agent 5 Agent 6 Agent 7