4. The following data are a subset of details of deaths from General Register Office (1854, p. 309). Summarize the data, grouping records into rows according to the street on which each death occurred, columns according to the gender of the deceased, and counting the number of deaths for each of these category combinations. You will end up with: . a row for each unique value in the street column, . a column for each unique gender shown, and . a set of counts for occurrences of each combination of street and gender in the list. Draw and complete the resulting pivot table and fill in the FILTERS, COLUMNS, ROWS, and VAL- UES configuration sections appropriately below. Date Street Street No. Age Gender Aug. 22 Poland Street Workhouse 69 male Aug. 25 Eagle Street 3 27 male Drag fields between areas below: Aug. 25 Poland Street Workhouse 17 female Aug. 28 College Street 13 50 female Y FILTERS IIII COLUMNS Aug. 31 Noble Mews 16 34 male Sep. 1 Fitzroy Street 13 37 female Sep. 1 Husband Street 8 20 male ROWS E VALUES Sep. 1 Husband Street 10 18 male Sep. 1 Norton Street 6 20 male Sep. 1 Poland Street Workhouse 36 male