Essentials of Business Analytics 1st Edition by Jeffrey Camm,James Cochran,Michael Fry,Jeffrey Ohlmann ,David Anderson

Exercise 5

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:

These data can be found in the file Franchises. Create a PivotTable to summarize these data using classes 0-9,999, 10,000-19,999, 20,000-29,999, 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