Please complete the excel sheet and in your own words no plagiarism please. Answer within 30 minutes thanks

A B C D E F G Households Households (Current Memo 13 Service (2015) Survey) To: Strategic Analyst, Metropolitan Area 2 Time Warner Cable 75,625 74,520 3 At&T U-Verse 56,815 58, 140 From: Vice President, Strategy 4 Dish Network 14,940 14,650 Re: Competition 5 Direct TV 19,650 19,850 6 Google Fiber 1, 150 A recent survey of the Metro area provides us with some market share data for the region. 8 Households with Service 167,030 168,310 Use the attached data to provide some concrete measures of the concentration of our 9 industry. 10 No Service* 16,650 17,520 11 1. According to Department of Justice guidelines, is the industry heavily concentrated? 12 Total Households 183,680 185,830 2. How has that changed since the 2015 survey? 13 14 3. Would a strategic partnership (or merger) with Dish Network create a significant 15 change in concentration in the Metro area? 16 17 Your response will help us in developing our strategy. 18 *No service indicates that the household does not currently Attachment: Market share.xIs 19 subscribe to a mult-channel video provider. Of these 20 21 households, 68.4% indicated that they did subscribe to one Aa 491 . . . 22 or more Internet-based services such as Netflix or Hulu. In 23 the 2015 survey, the same response was 63.2%