The questions are below. Thank you!
\fStep 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) a) Draw frequency distribution tables and (simple) bar diagrams for: i. Question 1 (Radio Station vs. Count). ii. Question 2 (Food Quality Rating vs. Count). iii. 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) a) Draw the following for \"Ratings vs. count\": i. Frequency distribution table. ii. Relative frequency. iii. Cumulative frequency. iv. Cumulative relative frequency. v. Histogram. vi. Is the histogram positive skewed, symmetric or negatively skewed? Question 3: Data Set 3: Homeownership_ (Refer attached MS Excel File)_. The data already provides frequency distribution from 2001 - 2015. a) Calculate and draw the following: i. Relative frequency. ii. Cumulative frequency. iii. Cumulative relative frequency. iv. Histogram. v. Polygon. vi. Ogive. vii. Is the histogram positive skewed, symmetric or negatively skewed? Data 1_Tween_Survey Data 2_DOW_Characteristics Da Question 3 (Main Question 4 (Own Question 1 (Radio Question 2 (Quality Tween Dining Area close money Spent at Station) of Food) time) lodge $) JAMN94.5 4 5:00pm 20 MIX104.1 5:00pm 10 KISS108 W N N 4:30pm 10 JAMN94.5 4:00pm 0 KISS108 3:30pm 0 JAMN94.5 5:00pm 25 KISS108 6:00pm 15 KISS108 5:00pm 10 KISS108 4:30pm 10 10 KISS108 4:30pm 20 11 JAMN94.5 IN WW N N A W W N W N - - 3:00pm 0 12 JAMN94.5 4:00pm 13 KISS108 4:30pm 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 2 4:30pm 10Data 1_Tween_Survey Data 2_DOW_Characteristics Company Year Rating Price 3M (MMM) 1976 92.36 American Express (AXP) 1982 19.25 Apple (AAPL) 2015 139.99 Boeing (BA) 1987 80.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) 928 82.00 General Electric (GE) 1907 29.28 Goldman Sachs (GS) 2013 243.94 Home Depot (HD) 1990 49.60 IBM (IBM) 1979 175.65 Intel (INTC) 1999 35.27 Johnson & Johnson (JNJ) 1997 128.06 JPMorgan Chase (JPM) 1991 20.68 McDonald's (MCD) 1985 128.64 Merck (MRK) 979 $3.90 Microsoft (MSFT) 1990 64.87 Nike (NKE) 2013 57.80 Pfizer (PFE) 2004 34.32 Proctor & Gamble (PG) 193 91.00 Travelers (TRV) 2009 123.14 United Technologies (UTX) 1939 113.45 UnitedHealth (UNH 2012 169.70 Verizon Comm. (VZ) 2004 50.39 fisa (V) 2013 90.24 Wal-Mart (WMT) 1991 69.89
