Assignment #6 For this assignment, you will be using the Tips Dataset file in Excel. The file contains both qualitative and quantitative variables. Choose two qualitative variables. You will be using a hypothesis test to determine if the two variables are associated. 1. Which two variables did you choose? Create a table to summarize the data from the data file. Example below: Example: Listed below are data from a survey conducted recently where Males and Females responded to their happiness with their supervisor (this is fictitious data). Male Female Total Response Not at all 23 25 48 Somewhat 13 22 35 Very 26 16 42 Total 62 63 125 2. Which hypothesis test is appropriate for this type of data? Explain. What is your null hypothesis? What is your alternative hypothesis? 3. Conduct the hypothesis test. Include any output from Excel. What is your test statistic? Using alpha=0.05 determine the results of your hypothesis test. Explain. 4. Interpret your results into a conclusion based on your hypothesis (are the variables associated or not?). What are the practical implications of your conclusion? Explain.