PLEASE POST THE FORMULAS

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: These data can be found in the file Franchises. Create a Pivot Table to summarize these data using classes 09,999,10,00019,999,20,00029,999, and 30,00039,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