Question

ng.cengage.com Blackboard Learn MindTap - Cengage Learning SE MINDTAP Q Search thi - 3.2 eBook 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. Click on the datafile logo to reference the data. DATA file # U.S. # U.S. Franchise Locations Franchise Locations Hampton Inns 1,864 Jan-Pro Franchising Intl. Inc. 12,394 Ampm 3,183 Hardee's 1,901 McDonald's 32,805 Pizza Hut Inc. 13,281 7-Eleven Inc. 37,496 Kumon Math & Reading Centers 25,199 Supercuts 2,130 Dunkin' Donuts 9,947 Days Inn 1,877 KFC Corp. 16,224 Vanguard Cleaning Systems 2,155 Jazzercise Inc. 7,683 Servpro 1,572 Anytime Fitness 1,618 Subway 34,871 Matco Tools 1,431 Denny's Inc. 1,668 Stratus Building Solutions 5,018 Create a Pivot Table 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 as the COLUMNS and use Count of U.S. Locations as the Valles in the Pivot Table. (a) How many franchises have between 0 and 9,999 locations? (b) How many franchises have more than 30,000 locations? Leader

Answer 1

If you like my explanation, please give a "thumbs up"

Final answers are marked in yellow.

А B C D 11 G H 1 2 3 4 5 6 Locations 1864 3183 32805 37496 2130 1877 2155 1572 E F (a) Franchise having O- 9999 locations Yes 1 Yes 1 No 0 No 0 Yes 1 Yes 1 Yes 1 (b) Franchise having more than 30,000 No 0 No 0 Yes 1 Yes 1 No 0 No 0 No 0 No 0 Yes 1 7 8 9 10 Yes 1 11 34871 No 0 12 Franchise Hampton Inns Ampm MCDonald 7-Eleven Inc Supercuts Days Inn Vanguard Cleaning Systems Servpro Subway Denny's Inc Jan-Pro Franchising Inti Inc Hardee's Pizaa Hut Inc Kumon Math Reading Centers Dunkin Donuts KFC Corp Jazzercise Inc Anytime Fitness Matco Tools Stratus Building Solutions 1668 Yes 1 No 0 13 No 0 No 0 12394 1901 14 Yes 1 No 0 15 No 0 No 0 16 No 0 No 0 13281 25199 9947 16224 17 Yes 1 No 0 18 0 No 0 No Yes 19 1 No 0 Yes 1 No 0 20 21 22 7683 1618 1431 5018 1 0 Yes Yes Total 1 No No Total 0 23 13 3 24 25 26

For calculation ref:

A B с D E F G H 1 (a) (b) 2 3 4 5 6 7 8 9 10 11 12 Franchise Locations Hampton Inns 1864 Ampm 3183 MCDonald 32805 7-Eleven Inc 37496 |Supercuts 2130 Days Inn 1877 Vanguard Cleaning Systems 2155 Servpro 1572 Subway 34871 Denny's Inc Jan-Pro Franchising Inti Inc 12394 Hardee's Pizaa Hut Inc 13281 Kumon Math Reading Centers 25199 Dunkin Donuts 9947 KFC Corp 16224 Jazzercise Inc 7683 Anytime Fitness Matco Tools 1431 Stratus Building Solutions 5018 1668 Franchise having 0-9999 locations =IF(C3<9999, "Yes","No") =IF(E3="Yes",1,0) =IF(C4<9999, "Yes","No") =IF(E4="Yes",1,0) =IF(C5<9999, "Yes","No") =IF(E5="Yes",1,0) =IF(C6<9999, "Yes","No") =IF(E6="Yes",1,0) =IF(C7<9999, "Yes","No") =IF(E7="Yes",1,0) =IF(C8<9999, "Yes","No") =IF(E8="Yes",1,0) =IF(C9<9999, "Yes","No") =IF(E9="Yes",1,0) =IF(C10<9999, "Yes","No") =IF(E10="Yes",1,0) =IF(C11<9999, "Yes","No") =IF(E11="Yes",1,0) =IF(C12<9999, "Yes","No") =IF(E12="Yes",1,0) =IF(C13<9999, "Yes","No") =IF(E13="Yes",1,0) =IF(C14<9999, "Yes","No") =IF(E14="Yes",1,0) =IF(C15<9999, "Yes","No") =IF(E15="Yes",1,0) =IF(C16<9999, "Yes","No") =IF(E16="Yes",1,0) =IF(C17<9999, "Yes","No") =IF(E17="Yes",1,0) =IF(C18<9999, "Yes","No") =IF(E18="Yes",1,0) =IF(C19<9999, "Yes","No") =IF(E19="Yes",1,0) =IF(C20<9999, "Yes","No") =IF(E20="Yes",1,0) =IF(C21<9999, "Yes","No") =IF(E21="Yes",1,0) =IF(C22<9999, "Yes","No") =IF(E22="Yes",1,0) Total =SUM(F3:F22) Franchise having more than 30,000 locations =IF(C3>30000, "Yes","No") =1F(13="Yes",1,0) =IF(C4>30000, "Yes","No") =IF(14="Yes",1,0) =IF(C5>30000, "Yes","No") =IF(15="Yes",1,0) =IF(C6>30000, "Yes","No") =IF(16="Yes",1,0) =IF(C7>30000, "Yes","No") =IF(17="Yes",1,0) =IF(C8>30000, "Yes","No") =IF(18="Yes",1,0) =IF(C9>30000, "Yes","No") =IF(19="Yes",1,0) =IF(C10>30000, "Yes","No") =IF(110="Yes",1,0) =IF(C11>30000, "Yes","No") =IF(111="Yes",1,0) =IF(C12>30000, "Yes","No") =IF(112="Yes",1,0) =IF(C13>30000, "Yes","No") =IF(113="Yes",1,0) =IF(C14>30000, "Yes","No") =IF(114="Yes",1,0) =IF(C15>30000, "Yes","No") =IF(115="Yes",1,0) =IF(C16>30000, "Yes","No") =IF(116="Yes",1,0) =IF(C17>30000, "Yes","No") =IF(117="Yes",1,0) =IF(C18>30000, "Yes","No") =IF(118="Yes",1,0) =IF(C19>30000, "Yes","No") =IF(119="Yes",1,0) =IF(C20>30000, "Yes","No") =IF(120="Yes",1,0) =IF(C21>30000, "Yes","No") =IF(121="Yes",1,0) =IF(C22>30000, "Yes","No") =IF(122="Yes",1,0) Total =SUM(J3:J22) 13 1901 14 15 16 17 18 19 20 1618 21 22 23 24