Follow the instructions step by step to complete it. This is an overall assignment, but you need to complete the first one before completing the other part. We can negotiate at any time regarding the completion time of the assignment. Don't forget one important thing, "notes" in the code. Please comment as much as possible on the steps you think are critical or where there may be doubts for new students.

Context - A Real Court CaseIn the early 1970s, a young man challenged an Oklahoma state law that prohibited the sale of 3.2% beer to males under age 21 but allowed its sale to females in the same age group. The case (Craig v. Boren, 429 U.S. 190, 1976) was ultimately heard by the U.S. Supreme Court. The state of Oklahoma argued that the law improved traffic safety. One of the three main pieces of data presented to the court was the result of a “random roadside survey.” This survey gathered information on gender and whether or not the driver had been drinking alcohol in the previous 2 hours. A total of 619 drivers under 21 years of age were included in the survey.PromptA test of independence may be appropriate if we are examining the relationship between two categorical variables in one population. For this situation what is the population? What is the explanatory variable? What is the response variable?What are the hypotheses for the Test of Independence? State hypotheses with reference to the context of the scenario.The spreadsheet of the data looked like this: Roadside survey dataDriverGenderAlcohol in lasttwo hours?Driver 1MYesDriver 2FNoDriver 3FYes.........Driver 619MNo We will not use the raw data. Instead we will use the summarized data shown in the table below. Roadside survey summaryDrank alcohol in last 2 hours?YesNoTotals Male77404481 Female16122138 Totals93526619Use StatCrunch to find expected counts, the Chi-square test statistic and the P-value. (directions) Copy and paste your StatCrunch table into your post. How many males in the sample are expected to answer yes to question about alcohol consumption in the last two hours? Show how to calculate this expected count and explain what it means relative to the hypotheses.Explain how we know that this data meets the conditions for use of a chi-square distribution.State a conclusion at a 5% level of significance. Do you think that the data supports the Oklahoma law that forbids sale of 3.2% beer to males and permits it to females?

After working for 18 months in your analyst position at G&B Consulting, you are now being considered for a project manager position that would put you in charge of several team members. As part of the interview process, you have been asked to make a presentation to highlight what you think are the most compelling reasons you should get the position. You are to put together a PowerPoint presentation that explains all of the key components that you feel will factor into why you should get the position. What to Submit To complete this assignment, you must first download the word document. Use the questions on the worksheet as your guide for the contents of your presentation. Your step-by-step breakdown of the problems, including explanations and all work shown, should be present within the PowerPoint you create. If you use Excel for any of your calculations that file must also be included in the drop box. Do not submit the Word document with instructions.