Question: table [ [ Franchise , , table [ [ Locations ] , [ Locer . S . ] ] , Franchise, table
tableFranchisetableLocationsLocerSFranchise,tableNumber of USLocationsHampton 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 Locations as 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
