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 le 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 Franchise Franchise U.S. Locations Hampton Inns Jan-Pro Franchising Intl. Inc. Pizza Hut Inc. Kumon Math & Reading Centers Dunkin' Donuts KFC Corp. 7-Eleven Inc. Vanguard Cleaning Systems Stratus Building Solutions