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

Answered step by step
Verified Expert Solution
Question
87 users unlocked this solution today!
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?

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

Step by Step Solution

3.45 Rating (161 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Link Copied!

Step: 1

a b c The treemap chart makes it very easy to identify the conference affiliati... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

100% Satisfaction Guaranteed-or Get a Refund!

Step: 2Unlock detailed examples and clear explanations to master concepts

blur-text-image_2

Step: 3Unlock to practice, ask and learn with real-world examples

blur-text-image_3

Document Format ( 1 attachment)

Excel file Icon

1695_605dc4e4d967e_697795.xlsx

300 KBs Excel File

See step-by-step solutions with expert insights and AI powered tools for academic success

  • tick Icon Access 30 Million+ textbook solutions.
  • tick Icon Ask unlimited questions from AI Tutors.
  • tick Icon Order free textbooks.
  • tick Icon 100% Satisfaction Guaranteed-or Get a Refund!

Claim Your Hoodie Now!

Recommended Textbook for

Essentials Of Business Analytics

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

3rd Edition

1337406422, 9781337406420

More Books
flashcard-anime

Study Smart with AI Flashcards

Access a vast library of flashcards, create your own, and experience a game-changing transformation in how you learn and retain knowledge

Explore Flashcards

Students Have Also Explored These Related Applied Statistics and Probability Questions!