Using the data below, create a pivot table with Gender in the rows and averages of Chicago, Los Angeles, and Philadelphia as values. Gender Houston Chicago Los Angeles Philadelphia New York Boston Male 4 4 Male n w A Male AAA Male Male Male Male A UI Male JAAN AUAAUINNNOAVIWA Male Male N - . Male NO Male Male Female Female W- N W A U W - - W - WOW A A WA UI A N N NA NA WN Female Female Female Female OI OI A W-N-NO-GUAN-NNA Female Female AA Female Female Female Female N-ANOUA Female OWNAN -A Female Female UI A Female For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac)