1. Define the dependent and independent variables in this research question then use a bivariate linear probability model to test the effect of the treatment. Put the regression output in its own tab, and in that tab answer the next three questions.2. How much of the variation in drinks is explained by ‘pt02’?3. Is there a statistically significant relationship between ‘pt02’ and ‘drinks’? Assume alpha=.054. Interpret the coefficient estimate from #1 in a sentence.5. Now, run a multivariate regression including the other independent variables, and put that in its own tab, then answer the next two questions.6. Compare the coefficient estimate for ‘pt02’ in this new model to the estimate yielded by the bivariate model. Do your conclusions change?7. Is pt02 correlated with any of the other independent variables in the model? Is there a reason to think it should or should not be?Please answer these questions in the attached excel file itself. This is how the variables have been coded:Variable name labelFemale Identity as Female?(Yes=1/No=0)Gpa What's your GPA?-Round to the Nearest TenthAge How old are you?(In Years)Pt02 Assigned to the BrAC= .02 group in the alcohol testing questionDrink Reported Number of Drinks in the Alcohol Testing QuestionThanks :)

This week you will begin working on Phase 4 of your course project. For Phase 4 of your course project, you will want to review your instructor's feedback from your Phase 1, Phase 2, and Phase 3 submissions to make any necessary corrections. Remember if you have questions about the feedback to ask your instructor for assistance.Once you have made your corrections, you will compile your information from Phase 1, Phase 2, Phase 3 and your final conclusion into one submission and submit this as your rough draft for Phase 4 of the course project. Below is a summary of the expectations for Phase 4 of the course project:Introduce your scenario and data set.Provide a brief overview of the scenario you are given above and the data set that you will be analyzing. Classify the variables in your data set.Which variables are quantitative/qualitative? Which variables are discrete/continuous? Describe the level of measurement for each variable included in your data set. Discuss the importance of the Measures of Center and the Measures of Variation.What are the measures of center and why are they important? What are the measures of variation and why are they important? Calculate the measures of center and measures of variation. Interpret your results in context of the selected topic.Mean Median Mode Midrange Range Variance Standard Deviantion Discuss the importance of constructing confidence intervals for the population mean.What are confidence intervals? What is a point estimate? What is the best point estimate for the population mean? Explain. Why do we need confidence intervals? Based on your selected topic, evaluate the following:Find the best point estimate of the population mean. Construct a 95% confidence interval for the population mean. Assume that your data is normally distributed and σ is unknown.Please show your work for the construction of this confidence interval and be sure to use the Equation Editor to format your equations. Write a statement that correctly interprets the confidence interval in context of your selected topic. Based on your selected topic, evaluate the following:Find the best point estimate of the population mean. Construct a 99% confidence interval for the population mean. Assume that your data is normally distributed and σ is unknown.Please show your work for the construction of this confidence interval and be sure to use the Equation Editor to format your equations. Write a statement that correctly interprets the confidence interval in context of your selected topic. Compare and contrast your findings for the 95% and 99% confidence interval.Did you notice any changes in your interval estimate? Explain. What conclusion(s) can be drawn about your interval estimates when the confidence level is increased? Explain. Discuss the process for hypothesis testing.Discuss the 8 steps of hypothesis testing? When performing the 8 steps for hypothesis testing, which method do you prefer; P-Value method or Critical Value method? Why? Perform the hypothesis test. If you selected Option 1: Original Claim: The average salary for all jobs in Minnesota is less than $65,000. Test the claim using α = 0.05 and assume your data is normally distributed and σ is unknown. If you selected Option 2: Original Claim: The average age of all patients admitted to the hospital with infectious diseases is less than 65 years of age. Test the claim using α = 0.05 and assume your data is normally distributed and σ is unknown. Based on your selected topic, answer the following:Write the null and alternative hypothesis symbolically and identify which hypothesis is the claim. Is the test two-tailed, left-tailed, or right-tailed? Explain. Which test statistic will you use for your hypothesis test; z-test or t-test? Explain. What is the value of the test-statistic? What is the P-value? What is the critical value? 5.) What is your decision; reject the null or do not reject the null? Explain why you made your decision including the results for your p-value and the critical value. State the final conclusion in non-technical terms. ConclusionRecap your ideas by summarizing the information presented in context of your chosen scenario. Please be sure to show all of your work and use the Equation Editor to format your equations. This assignment should be formatted using APA guidelines and a minimum of 2 pages in length.