I need help

M40 A B C. 1 Beer Drlnker Preference Gender 2 1 Regular Male 3 2 Light Female 4 3 Regular Male 5 4 Regular Male 6 5 Regular Female 7 6 Regular Male 8 7 Dark Male 9 8 Dark Male 10 9 Dark Male 11 10 Light Female 12 11 Light Male 13 12 Dark Female 14 13 Regular Male 15 14 Regular Male 16 15 Light Male 1'? 16 Regular Male 18 17 Dark Male 19 18 Regular Male 20 19 Light Female 21 20 Regular Female 22 21 Regular Female 23 22 Light Male 24 23 Regular Male 25 24 Light Female 26 25 Light Male 2'? 26 Dark Male 28 2? Light Male 29 28 Light Male 3 0 29 Regular Male 3 1 30 Light Male 32 31 Light Male 3 3 32 Light Female 34 33 Regular Male 3 5 34 Dark Male 36 35 Regular Male 3 7 36 Regular Female 38 37 Regular Male 3 9 38 Dark Male 40 39 Regular Female 41 40 Dark Male 42 41 Light Female 43 42 Dark Female 44 43 Dark Male 45 44 Regular Female 46 45 Light Male 4'? 46 Light Male 48 4? Regular Male 49 48 Light Female 50 49 Light Male 51 50 Regular Male 52 51 Light Male 53 52 Light Male 54 53 Light Female 55 54 Regular Female 56 55 Light Male 5'? 56 Regular Male 58 5? Dark Male 59 58 Light Female 60 59 Light Male Exercise 2 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 Dark Regular Regular Light Dark Light Light Regular Light Light Regular Light Regular Regular Regular Light Dark Regular Light Regular Regular Light Light Light Regular Light Light Light Light Regular Regular Regular Light Regular Light Light Regular Regular Light Light Dark Light Regular Dark Light Dark Regular Light Light Light Regular Regular Regular Light Regular Light Dark Light Light Regular Exercise 2 Female Female Female Male Male Male Male Male Male Male Female Male Male Female Male Male Female Female Male Male Male Female Male Male Female Male Female Male Male Male Male Male Male Female Female Male Male Male Male Female Male Male Male Male Male Female Male Male Male Male Female Male Female Female Male Light Light Light Light Light Regular Regular Regular Dark Regular Dark Light Dark Dark Light Light Light Dark Regular Light Dark Dark Light Light Light Light Light Regular Light Light Dark Light Light Regular Regular Regular Regular Regular Dark Light Regular Regular Light Light Light Regular Light Dark Dark Regular Light Regular Regular Dark Dark Light Regular Light Regular Regular Exercise 2 Female Female Male Female Male Female Female Female Male Female Male Male Male Male Male Female Male Female Female Female Male Male Female Female Male Female Female Male Male Female Male Male Male Male Male Male Male Female Male Male Female Female Male Female Female Female Male Female Male Male Light Light Light Light Regular Light Light Regular Light Light Light Exercise 2 Female Female Male Male Female Male Male Male Male Male Male Male Male Male Male Objectives: At the end of this lab, you will be able to: Identify when to apply chi-square independence tests Identify the required assumptions to perform chi-square independence tests Identify appropriate Ho and Ha Perform chi-square independence tests using Excel (SPSS when appropriate) Interpret the results in the context of the problem Directions: Refer to the Excel le Lab #6 to complete the following tasks. All results and explanations need to be reported Within this Word document after each question. Your results should be formatted and edited. Make sure to use complete sentences when explaining your results. You need to submit a hard copy of your lab. Exercise 1. A research firm claims that the distribution of the days of the week that people are most likely to order food for delivery is different from the distribution shown in the pie chart. You randomly select 496 people and record which day of the week each is most likely to order food for delivery. The table to the right shows the results. At a = .10 test the research firm's claim. Food at your door Day Frequency_f Sunday 7% Sunday 44 Monday 3% Tuesday 6% Monday 14 Wednesday 12% Tuesday 29 Thursday 9% Wednesday 41 Friday 35% Thursday 46 Saturday 28% Friday 166 Saturday 156Exercise 2. A beer industry association conducts a survey to determine the preference of beer drinkers for light, regular, and dark beers. A sample of 200 beer drinkers is taken with each person in the sample asked to indicate a preference for one of the three types of beers: light, regular, or dark. At the end of the survey questionnaire, the respondent is asked to provide information on a variety of demographics including gender: male or female. A research question of interest is whether preference for the three types of beer is independent of the gender of the beer drinker. If beer drinkers' preferences depend on their gender, then beer manufacturers could use this information to customize its promotions and advertising for the different target markets of beer drinkers. A. Construct a two-way contingency table (crosstabulation) with beer preferences (light, regular and dark) and gender (male and female) to summarize the data. B. Use the contingency table (crosstabulation) constructed in Part A, construct a bar graph that shows the relationship between beer preferences and gender. Discuss whether there is dependence exists between beer preferences and gender. C. Construct another two-way contingency table (crosstabulation) and find the expected frequency for each cell. D. Check whether each expected frequency is at least 5. E. State Ho and Ha. F. At the 5% significance level, perform a hypothesis test to determine whether beer drinkers' preferences depend on their gender