Question: table [ [ Franchise , Locations,Franchise,Locations ] , [ Hampton Inns, 1 , 8 6 4 , Jan - Pro Franchising Intl. Inc., 1

\table[[Franchise,Locations,Franchise,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,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,],[Denny's Inc.,1,668,Stratus Building Solutions,1,431]]
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,00 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. Le 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,Locations,Franchise,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

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!