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 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?
Students succeed in their courses by connecting and communicating with an expert until they receive help on their questions
Consult our trusted tutors.
Login | Sign Up
