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.

Provide the steps

Transcribed Image Text:

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