Please answer the following questions. Attached is the data needed. Thanks!

Step 1: Formulate a Frequency Distribution Table Step 2: Use MS Excel to draw the respective charts Question 1: Data Set 1: Tween Survey (Refer attached MS Excel File] aj Draw frequency distribution tables and (simple) bar diagrams for: I. Question 1 (Radio Station vs. Count). il. Question 2 (Food Quality Rating vs. Count). lil. Question 3 (Closing Time vs. Count). iv. Question 4 (Own money spent vs. Count). Question 2: Data Set 2: DOW Characteristics (Refer attached MS Excel File) aj Draw the following for "Ratings vs. count": I. Frequency distribution table. il. Relative frequency. lil. Cumulative frequency. iv. Cumulative relative frequency. V. Histogram. vi. Is the histogram positive skewed, symmetric or negatively skewed?Question 1 (Radio Question 3 (Main | Question 4 (Own Question 2 (Quality Tween Dining Area close Station) money Spent at of Food) time) lodge $) JAMN94.5 5:00pm 20 W N K MIX104.1 5:00pm 10 NN KISS108 4:30pm 10 JAMN94.5 4:00pm 0 KISS108 3:30pm 0 JAMN94.5 6:00pm 25 KISS108 6:00pm 15 KISS108 5:00pm 10 9 KISS108 4:30pm 10 10 KISS108 4:30pm 20 11 JAMN94.5 3:00pm 0 12 JAMN94.5 NHANWWNNAWWNWNERW 4:00pm 5 13 KISS108 4:30pm 5 14 KISS108 5:00pm 10 15 KISS108 4:00pm 5 16 JAMN94.5 6:00pm 20 17 KISS108 5:00pm 15 18 MIX104.1 6:00pm 15 19 KISS108 5:00pm 25 20 KISS108 4:30pm 10Company Year Rating Price 3M (MMM) 1976 192.36 American Express (AXP) 1982 79.25 Apple (AAPL) 2015 139.99 Boeing (BA) 1987 180.10 Caterpillar (CAT) 1991 92.91 Chevron Corp. (CVX) 2008 107.68 Cisco Systems (CSCO) 2009 34.23 Coca-Cola (KO) 1987 42.03 Disney (DIS) 1991 111.76 DuPont (DD) 1935 81.25 ExxonMobil (XOM) 1928 82.00 General Electric (GE) 1907 29.28 Goldman Sachs (GS) 2013 243.94 Home Depot (HD) 1999 149.60 IBM (IBM) 1979 175.65 Intel (INTC) 1999 35.27 Johnson & Johnson (JNJ) 1997 128.06 JPMorgan Chase (JPM) 1991 90.68 Mcdonald's (MCD) 1985 128.64 Merck (MRK) 1979 63.90 Microsoft (MSFT) 1999 64.87 Nike (NKE) 2013 57.80 Pfizer (PFE) 2004 34.32 Proctor & Gamble (PG) 1932 91.00 Travelers (TRV) 2009 123.14 United Technologies (UTX] 1939 113.45 UnitedHealth (UNH) 2012 169.70 Verizon Comm. (VZ] 2004 50.39 Visa (V) 2013 90.24 Wal-Mart (WMT) 1991 69.89Year Houses Owned (Thousands) 2001 634 2002 844 2003 981 2004 1080 2005 1125 2006 1288 2007 1305 2008 909 2009 621 2010 468 2011 324 2012 558 2013 696 2014 774 2015 890