Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started