Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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?
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Project Management A Managerial Approach

Authors: Jack R. Meredith, Samuel J. Mantel,

7th Edition

470226218, 978-0470226216

More Books

Students also viewed these General Management questions