1. The Excel file University Grant Proposals provides data on the dollar amount of proposals, gender of the researcher, and whether the proposal was funded or not. Construct a PivotTable to find the average amount of proposals by gender and outcome. 2. A national homebuilder builds single‐family homes and condominium‐style townhouses. The Excel file House Sales provides information on the selling price, lot cost, type of home, and region of the country (M = Midwest, S = South) for closings one month. Use PivotTables to find the average selling price and lot cost for each type of home in each region of the market. What conclusions might you reach from this information?