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, 30,000€“39,999 to answer the following questions.
a. How many franchises have between 0 and 9,999 locations?
b. How many franchises have more than 30,000 locations?

Transcribed Image Text:

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