Question

U.S_ Franchise Locations Franchise Locations Hampton Inns 1,854 Jan-Pro Franchising Intl: Inc_ Hardee's 12,394 1,901 Ampm 3,183 McDonald'$ 32,805 37,496 Pizza Hut Inc. 13,281 Kumon Math Reading Centers 25,199 7-Eleven Inc. Supercuts 2,130 Dunkin Donuts 9,947 16,224 Days Inn 1,877 KFC Corp_ Vanguard Cleaning Systems Servpro 2,155 1,572 Jazzercise Inc, Anytime Fitness 7,683 1,618 Subway 34,871 Matco Tools 1,431 5,018 Denny's Inc, ,668 Stratus Building Solutions Create PivotTable in Excel 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 U.S Locations a5 the COLUMNS and use Count of U.S Locations as the VALUES in the PivotTable
(a) How many franchises have between and 9,999 locations? (b) How many franchises have more than 30,000 locations?

Answer 1

(a) In the PivotTable, look for the class "0-9,999" in the "U.S Locations" column. The corresponding value in the "Count of U.S Locations" column is the number of franchises that have between 0 and 9,999 locations.

(b) In the PivotTable, look for the class "30,000-39,999" in the "U.S Locations" column. The corresponding value in the "Count of U.S Locations" column is the number of franchises that have more than 30,000 locations.

To create a PivotTable in Excel to summarize the data using the classes 0-9,999, 10,000-19,999, 20,000-29,999, and 30,000-39,999, follow these steps:

1. Open the Excel spreadsheet containing the data.
2. Select the data that you want to include in the PivotTable.
3. Click on the Insert tab in the ribbon, then click on the PivotTable button.
4. In the Create PivotTable dialog box, choose where you want to place the PivotTable. You can either create a new worksheet for the PivotTable or place it in an existing worksheet.
5. Click on the OK button.
6. In the PivotTable Fields pane, drag the "U.S Locations" field to the Columns area.
7. Drag the "Count of U.S Locations" field to the Values area.
8. In the PivotTable, right-click on the "U.S Locations" column and select "Group" from the context menu.
9. In the Grouping dialog box, select the "By number" option, then enter the start and end values for each class (0-9,999, 10,000-19,999, 20,000-29,999, 30,000-39,999).
10. Click on the OK button.

To learn more about Excel spreadsheet, visit:

brainly.com/question/12339940

#SPJ4