Instructions: Next, you will be presented with a situation that you will have to analyze in a descriptive way to present recommendations to a restaurant owner. The criteria to be evaluated are focused on the competencies that must be developed in the course. These skills are found in the course syllabus. The table below shows how each part will be evaluated. The total score is 70. Situation: A business owner wants to make decisions about her restaurant. He does not have much knowledge of how to build data collection instruments or do statistical analysis. However, he ordered one of his employees to collect data on the following variables: (1) drink sold in a jug: (2) waiter who served the table; (3) amount of the table's invoice; (4) tip for the waiter; (5) number of people at the table and (6) level of customer satisfaction at the table. These data were collected in a time of one hour and the number of tables attended was 24. In the excel document that is shared, the collected data is presented. 1. What type of data is each variable? 2. Present a way to organize data in table form. 3. Present graphs to summarize the data provided. 4. Calculate statistics for qualitative data that allow a decision-making process. 5. Calculate statistics for quantitative data that allow a decision-making process. 6. Interpret the statistics performed and present recommendations. c D G H Waiter (by number) Tip Punctuation 3 Satisfaction levels Satisfecho Regular Insatisfecho 3 1 2 3 4 4 5 5 6 7 7 8 9 10 11 12 13 1 Jur drink Coca Cola Coca Cola Sprite Pepsi Coca Cola Coca Cola Sprite Sprite Coca Cola Pepsi Jugo Sprite Coca Cola Coca Cola Coca Cola Pepsi Coca Cola Pepsi Sprite Sprite Coca Cola Sprite Coca Cola Sprite Table bill 2 87.25 1 63.78 2 26.82 3 34.98 3 43.21 3 22.22 2 37.45 3 120.25 1 99.34 2 46.87 3 80.01 1 69.07 2 48.49 3 84 3 2 74.1 2 112.35 1 104,21 3 73.25 1 78.24 3 56.38 2 60.23 3 100.21 1 60.11 2 85.62 Number of people at level of satisfaction in the the table restaurant 13.0875 5 9.567 4.023 1 5.247 2 7.7778 2. 3.9996 1 0 2 21.645 6 14.901 4 7.0305 2 12.0015 3 6.907 2 7.2735 2. 12.645 3 11.115 3 16.8925 5 15.6315 3 7-325 3 11.736 2 8.457 2 9.0345 2 20.042 4 12.022 2 17.124 3 14 15 16 17 18 19 20 21 22 23 24 25 26 3 1 3 Sheet1 Instructions: Next, you will be presented with a situation that you will have to analyze in a descriptive way to present recommendations to a restaurant owner. The criteria to be evaluated are focused on the competencies that must be developed in the course. These skills are found in the course syllabus. The table below shows how each part will be evaluated. The total score is 70. Situation: A business owner wants to make decisions about her restaurant. He does not have much knowledge of how to build data collection instruments or do statistical analysis. However, he ordered one of his employees to collect data on the following variables: (1) drink sold in a jug: (2) waiter who served the table; (3) amount of the table's invoice; (4) tip for the waiter; (5) number of people at the table and (6) level of customer satisfaction at the table. These data were collected in a time of one hour and the number of tables attended was 24. In the excel document that is shared, the collected data is presented. 1. What type of data is each variable? 2. Present a way to organize data in table form. 3. Present graphs to summarize the data provided. 4. Calculate statistics for qualitative data that allow a decision-making process. 5. Calculate statistics for quantitative data that allow a decision-making process. 6. Interpret the statistics performed and present recommendations. c D G H Waiter (by number) Tip Punctuation 3 Satisfaction levels Satisfecho Regular Insatisfecho 3 1 2 3 4 4 5 5 6 7 7 8 9 10 11 12 13 1 Jur drink Coca Cola Coca Cola Sprite Pepsi Coca Cola Coca Cola Sprite Sprite Coca Cola Pepsi Jugo Sprite Coca Cola Coca Cola Coca Cola Pepsi Coca Cola Pepsi Sprite Sprite Coca Cola Sprite Coca Cola Sprite Table bill 2 87.25 1 63.78 2 26.82 3 34.98 3 43.21 3 22.22 2 37.45 3 120.25 1 99.34 2 46.87 3 80.01 1 69.07 2 48.49 3 84 3 2 74.1 2 112.35 1 104,21 3 73.25 1 78.24 3 56.38 2 60.23 3 100.21 1 60.11 2 85.62 Number of people at level of satisfaction in the the table restaurant 13.0875 5 9.567 4.023 1 5.247 2 7.7778 2. 3.9996 1 0 2 21.645 6 14.901 4 7.0305 2 12.0015 3 6.907 2 7.2735 2. 12.645 3 11.115 3 16.8925 5 15.6315 3 7-325 3 11.736 2 8.457 2 9.0345 2 20.042 4 12.022 2 17.124 3 14 15 16 17 18 19 20 21 22 23 24 25 26 3 1 3 Sheet1