Below is a sample of the data in the file NFLAttendance which contains the 32 teams in
a. Create a treemap using these data that separates the teams into their conference affiliations (NFC and AFC) and uses size to represent each teams 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?
Step by Step Answer: