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:

These data can be found in the file franchises. Create a PivotTable to summarize these data using classes 0–9,999, 10,000–19,999, 20,000–29,999, and 30,000–39,999 to answer the following questions.

Count of Number of U.S. Locations as the Values in the PivotTable.) LO 2

a. How many franchises have between 0 and 9,999 locations?

b. How many franchises have more than 30,000 locations?

Transcribed Image Text:

1,864 3,183 Franchise Hampton Inns ampm Number of U.S. Locations Franchise Jan-Pro Franchising Intl. Inc. Hardee's Number of U.S. Locations 12,394 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