Click on the datafile logo to reference the data.

DATA file

$\backslash$table$[[$Franchise$,\backslash$table$[[$# U$.$S$.],[$Locations$]],$Franchise,$\backslash$table$[[$# U$.$S$.],[$Locations$]]],[$Hampton Inns,$1,864,$Jan$-$Pro Franchising Intl. Inc.,$12,394],[$Ampm$,3,183,$Hardee's,$1,901],[$McDonald$\text{'}$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$\text{'}$s Inc.,$1,668,$Stratus Building Solutions,$5,018]]$

Create a PivotTable in Excel 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.

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 $9,999$ locations?

$($b$)$ How many franchises have more than $30,000$ locations?