Search this

hapter $3$ Assignment

$1.$

$2.$

$3.$

$4.$

$5.$

$5.$

$\backslash$table$[[$Franchise$,\backslash$table$[[$Number of U$.$S$.],[$Locations$]],$Franchise,$\backslash$table$[[$Number of 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]]$

These data can be found in the file Franchises. Create a PivotTable in Excel 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. $($Hint: Use Number of U$.$S$.$ Locations as the COLUMNS, and use Count of Number of U$.$S$.$ Locations as the VALUES in the PivotTable.$)$

$($a$)$ How many franchises have between $0$ and $9,999$ locations?