Entrepreneur magazine ranks franchises. Among the factors that the magazine uses

Question

Entrepreneur magazine ranks franchises. Among the factors that the magazine uses in its rankings are growth rate, number of locations, start-up costs and financial stability. A recent ranking listed the top 20 U.S. franchises and the number of locations as follows.

Click on the datafile logo to reference the data.

Create a PivotTable in Excel to summarize these data using classes 0-9999, 1000-19999, 20000-29999, 30000-39999 to answer the following questions.

Hint: Use # U.S. Locations as the COLUMNS and use Count of # U.S. Locations as the VALUES in the PivotTable.

# U.S. # U.S.   Franchise Locations Franchise Locations   Hampton Inns 1,864   Jan-Pro Franchising Intl. Inc. 12,394     Ampm 3,183   Hardee's 1,901     McDonald's 32,805   Pizza Hut Inc. 13,281     7-Eleven Inc. 37,496   Kumon Math & Reading Centers 25,199     Supercuts 2,130   Dunkin' Donuts 9,947     Days Inn 1,877   KFC Corp. 16,224     Vanguard Cleaning Systems 2,155   Jazzercise Inc. 7,683     Servpro 1,572   Anytime Fitness 1,618     Subway 34,871   Matco Tools 1,431     Denny's Inc. 1,668   Stratus Building Solutions 5,018   DATA file

Explanation / Answer

a) Number of data points lie between 0 and 9999 = 13

Hence,

13 franchises have between 0 and 9999 locations.

b) Number of data points more than 30000 = 3

Hence,

3 franchises have more than 30000 locations.

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.