Entrepreneur magazine ranks franchises. Among the factors that the magazine uses in its rankings are growth rate, number of locations, start-up costs and financial stability. A recent ranking listed the top 20 U. S. franchises and the number of locations as follows.
Click on the webfile logo to reference the data.
# U. S. # U. S.
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 1,431
Denny's Inc. 1,668 Stratus Building Solutions 5,018
Create a PivotTable in Excel to summarize these data using classes 0-9999, 1000-19999, 20000-29999, 30000-39999 to answer the following questions.
Hint: Use # U. S. Locations as the COLUMNS and use Count of # U. S. Locations as the VALUES in the PivotTable.
(a) How many franchises have between 0 and 9999 locations?
(b) How many franchises have more than 30,000 locations?
Answers: 3
Other questions on the subject: Business
Business, 21.06.2019 15:30, slonekaitlyn01
Kayla and jada are roommates in new york city. both kayla and jada recently received pay raises. kayla now buys more movie tickets than before, but jada buys fewer. kayla behaves as if movie tickets are goods and jada's income elasticity of demand for movie tickets is
Answers: 2
Business, 22.06.2019 07:30, QueenNerdy889
1 2 3 4 5 6 7 8 9 10time remaining59: 30in the dark game, how does the author develop the central idea that elizabeth van lew was a spymaster during the civil war? 1 2 3 4 5 6 7 8 9 10time remaining59: 30in the dark game, how does the author develop the central idea that elizabeth van lew was a spymaster during the civil war?
Answers: 1
Business, 22.06.2019 07:30, kennaklein2
When selecting a savings account, you should look at the following factors except annual percentage yield (apy) fees minimum balance interest thresholds taxes paid on the interest variable interest rates
Answers: 1
Business, 22.06.2019 09:30, Yvette538
The 39 percent and 38 percent tax rates both represent what is called a tax "bubble." suppose the government wanted to lower the upper threshold of the 39 percent marginal tax bracket from $335,000 to $208,000. what would the new 39 percent bubble rate have to be? (do not round intermediate calculations. enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)
Answers: 3
Do you know the correct answer?
Entrepreneur magazine ranks franchises. Among the factors that the magazine uses in its rankings are...
Questions in other subjects:
