21. NFL Attendance. Below is a sample of the data in the file NFLAttendance which contains the 32 teams in the National Football League, their conference affiliation, their division, and their average home attendance.

a. Create a treemap using these data that separates the teams into their conference affiliations (NFC and AFC) and uses size to represent each team’s average home attendance. Note that you will need to sort the data in Excel by Conference to properly create a treemap.

b. Create a sorted bar chart that compares the average home attendance for each team.

c. Comment on the advantages and disadvantages of each type of chart for these data.
Which chart best displays these data and why?

Conference Division Team Average Home Attendance AFC West Oakland 54,584 AFC West Los Angeles Chargers 57,024 NFC North Chicago 60,368 AFC North Cincinnati 60,511 NFC South Tampa Bay 60,624 NFC North Detroit 60,792 AFC South Jacksonville 61,915