Question: table [ [ Franchise , , table [ [ Locations ] , [ Locer . S . ] ] , Franchise, table

\table[[Franchise,,\table[[Locations],[Locer.S.]],Franchise,\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'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,:.4,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'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?
(b) How many franchises have more than 30,000 locations?
 \table[[Franchise,,\table[[Locations],[Locer.S.]],Franchise,\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's,,32,805,Pizza Hut Inc.,13,281],[7-Eleven Inc.,,37,496,Kumon Math

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!