Below is a sample of the data in the file NFLAttendance which contains the 32 teams in

Question:

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.

Conference AFC AFC Division West West North North Average Home Attendance 54,584 57,024 60,368 Team Oakland Los Angeles


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?

Fantastic news! We've located the answer you've been seeking!

Step by Step Answer:

Related Book For  answer-question

Essentials Of Business Analytics

ISBN: 9781337406420

3rd Edition

Authors: Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson, Dennis J. Sweeney, Thomas A. Williams

Question Posted: