Assignment #1: Using the example tables in the "PIVOT TABLES" tab as a template, provide summary data in pivot table form for the additional fields provided (pool, location, FICO bucket, LTV

bucket) on a weighted average (WA) basis (weighting should be based on UPB_MONTHEND). FICO should use a non-zero weighted average (nzWA). Data is on the "DATA" tab.