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 webfile logo to reference the data.
# 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
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.
(a) How many franchises have between 0 and 9999 locations?
(b) How many franchises have more than 30,000 locations?