5. Top U.S. Franchises. 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: Franchise Hampton Inns ampm McDonald's 7-Eleven Inc. Supercuts Days Inn Vanguard Cleaning Systems Servpro Subway Denny's Inc. DATA file Franchises Number of U.S. Locations 1,864 3,183 32,805 37,496 2,130 1,877 2,155 1,572 34,871 1,668 Franchise Jan-Pro Franchising Intl. Inc. Hardee's Pizza Hut Inc. Kumon Math & Reading Centers Dunkin' Donuts KFC Corp. Jazzercise Inc. Anytime Fitness Matco Tools Stratus Building Solutions Number of U.S. Locations 12,394 1,901 13,281 25,199 9,947 16,224 7,683 1,618 1,431 5,018 These data can be found in the file Franchises. Create a Pivot Table 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 Pivot Table.) a. How many franchises have between 0 and 9.999 locations?

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
Franchise
Hampton Inns
ampm
McDonald's
5. Top U.S. Franchises. 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:
7-Eleven Inc.
Supercuts
Days Inn
Vanguard Cleaning Systems
Servpro
Subway
Denny's Inc.
DATA file
Franchises
Number of
U.S. Locations
1,864
3,183
32,805
37,496
2,130
1,877
2,155
1,572
34,871
1,668
Franchise
Jan-Pro Franchising Intl. Inc.
Hardee's
Pizza Hut Inc.
Kumon Math & Reading Centers
Dunkin' Donuts
KFC Corp.
Jazzercise Inc.
Anytime Fitness
Matco Tools
Stratus Building Solutions
Number of
U.S. Locations
12,394
1,901
13,281
25,199
9,947
16,224
7,683
1,618
1,431
5,018
These data can be found in the file Franchises. Create a Pivot Table 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 Pivot Table.)
a. How many franchises have between 0 and 9,999 locations?
Transcribed Image Text:Franchise Hampton Inns ampm McDonald's 5. Top U.S. Franchises. 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: 7-Eleven Inc. Supercuts Days Inn Vanguard Cleaning Systems Servpro Subway Denny's Inc. DATA file Franchises Number of U.S. Locations 1,864 3,183 32,805 37,496 2,130 1,877 2,155 1,572 34,871 1,668 Franchise Jan-Pro Franchising Intl. Inc. Hardee's Pizza Hut Inc. Kumon Math & Reading Centers Dunkin' Donuts KFC Corp. Jazzercise Inc. Anytime Fitness Matco Tools Stratus Building Solutions Number of U.S. Locations 12,394 1,901 13,281 25,199 9,947 16,224 7,683 1,618 1,431 5,018 These data can be found in the file Franchises. Create a Pivot Table 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 Pivot Table.) a. How many franchises have between 0 and 9,999 locations?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman