Q.1 Which of the following restaurants do you visit on a regular (at least once a week) basis? Total Male Female Home- Live with Renters owners Family Base 200 100 100 123 45 32 Percent of Base % 100% 100% 100% 100% 100% 100% Mcdonalds 135 75 50 85 22 28 Percent of Base % Wendy's 110 30 30 65 15 30 Percent of Base % Taco Bell 89 50 39 45 25 19 Percent of Base % Rally's 55 34 21 23 20 12 Percent of Base % Burger King 74 40 34 50 16 8 Percent of Base % Chick-fil-a 62 45 17 45 10 7 Percent of Base % Kentucky Fried Chicken 55 35 20 40 8 7 Percent of Base % Mean (average) Median Mode 1. Fill in numbers missing from all the yellow squares 2. Provide commentary for each data table ()minimum of 5 observations for each table) 3. Create at least one chart or graph to illustrate the data resultsQ.2 How many times a week would you say you eat at any of these fast-food restaurants? (Mcdonalds, Wendy's, Taco-Bell, Burger King, Rally's) [check all that apply] Home- Live with Total Male Female Renters owners Family Base 200 100 100 123 45 32 Percent of Base % 100% 100% 100% 100% 100% 100% More than 10-times weekly 0 0 4 1 Percent of Base % Between 8 and 10 times 10 8 2 3 6 1 Percent of Base % Between 5 and 7 times 50 27 23 10 35 5 Percent of Base % Between 2 and 4 times 74 54 20 15 47 12 Percent of Base % Once or twice a week 50 40 20 19 36 5 Percent of Base % Never eat fast food 1 0 1 0 1 0 Percent of Base % Total Mean (average) Median 1. Fill in numbers missing from all the yellow squares 2. Provide commentary for each data table ()minimum of 5 observations for each table) 3. Create a chart or graph to illustrate theQ.3 What is the most important part of the service you receive at a fast food restaurant? Total Home- Live with Male Female Renters owners Family Base 200 100 100 123 45 32 Percent of Base % 100% 100% 100% 100% 100% 100% Large selection of food 15 10 5 8 3 Percent of Base % Large selection of drinks 10 8 2 4 5 1 Percent of Base % Hours of operation 40 23 17 25 12 3 Percent of Base % Quality of food 74 39 35 47 8 19 Percent of Base % Cleanliness of facility 60 20 40 43 10 6 Percent of Base % Friendliness of staff 1 0 1 0 2 0 Percent of Base % Total Mean (average) Median Mode 1. Fill in numbers missing from all the yellow squares 2. Provide commentary for each data table (minimum of 5 observations for each table) 3. Create a chart or graph to illustrate theThis spreadsheet contains data from a Customer Satisfaction Survey about fast food restaurants commissioned by Taco Bell. The spreadsheet the three tabs each containing a survey question and the responses. 1. Complete the 3 data tabulations by providing all the missing elements highlighted in yellow and listed below (Tip: Complete measures of central tendency rst). 1. Totals 2. Percentages 3. Mean 4. Median 5. Mode 2. Next create at least 1 chart to display the data for each question (3 charts total) 3. Finally, provide written commentary explaining what can be inferred from the data in each chart. In other words, what observations can be made about the results that will help Taco Bell develop strategies to be more successful in the future? You will need to make at least 5 observation statements for each data table. 4. Copy each table as a picture into a Word document and add your observations and graphs as appropriate. Pay attention to layout and structure so that your nished document looks professional. Marks will be awarded for aesthetics and presentation. Example Observation Although McDonald's is the most frequently visited restaurant overall, with 68% of the respondents saying they visited it at least once a week, male respondents said they visited Wendy's more often than McDonald's on a weekly basis