Question: table [ [ Franchise , Locations,Franchise,Locations ] , [ Hampton Inns, 1 , 8 6 4 , Jan - Pro Franchising Intl. Inc., 1
tableFranchiseLocations,Franchise,LocationsHampton Inns,JanPro Franchising Intl. Inc.,AmpmHardee's,McDonaldsPizza Hut Inc.,Eleven Inc.,Kumon Math & Reading Centers,SupercutsDunkin' Donuts,Days Inn,KFC Corp.,Vanguard Cleaning Systems,Jazzercise Inc.,ServproAnytime Fitness,SubwayMatco Tools,Dennys Inc.,Stratus Building Solutions,
These data can be found in the file Franchises. Create a PivotTable in Excel to summarize these data using classes and to answer the following questions. Hint: Use Number of US Locations as the COLUMNS, and use Count of Number of US Le the VALUES in the PivotTable.
a How many franchises have between and locations?
b How many franchises have more than locations?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
