This is a group work project. Attached is the results from week 4 that will help answer the problems for this final piece of the project Instructions: Use the data you collected in Week 2. 1) Conduct a regression analysis to determine if age (independent variable) has any effect on the number of vitamins/supplements people take. State what you are testing and what the x (independent) and y (dependent) variables are. Test for correlation and explain the regression results, if necessary. 2) Conduct a regression analysis to determine if age (independent variable) has any effect on the number of alcoholic beverages someone consumes in one month. State what you are testing and what the x (independent) and y (dependent) variables are. Test for correlation and explain the regression results, if necessary. Respondent Sex Age Num. Vitamins /day Num. Carb. Sodas /day Num. Alc. Bev. /month Been to Disneyland 1 Male 22 1 0 1 Y 2 Male 24 3 2 3 Y 3 Male 45 2 4 5 Y 4 Male 19 2 3 3 N 5 Male 33 3 1 2 Y 6 Female 27 0 0 6 N 7 Female 21 4 5 2 Y 8 Female 25 2 3 5 Y 9 Female 30 1 2 2 Y 10 Female 50 2 4 4 N Conduct a hypothesis test analysis to determine if there is a statistical difference between the ages of the sexes in the group. State what you are testing. Write the hypotheses. Show the relevant numbers. Then explain your results. Use alpha = .05. From the data set, the sample statistics are: Sample mean: xm = 28.6, xf = 30.6 Sample standard deviation: sm = 10.55, sf = 11.33 Sample size: nm = 5, nf = 5 Where subscripts m stands for male and f stands for female The hypothesis is: Null hypothesis: Ho : xm = xf Alternative hypothesis: Ha : xm ≠ xf Independent two sample t-test at two sided 0.05 level of significance was carried out to test the hypothesis of difference between mean age of male and female respondents. Degree of freedom = nm + nf – 2 = 10-2 = 8 t = = -0.2889 t critical = 2.3060 As the critical value is greater than t test value, we accept the null hypothesis at 5% level of significance. There is not sufficient evidence at the 0.05 level of significance to support a claim that there is a statistical difference between the ages of the sexes in the group. . This week you will analyze if women drink more sodas than men. For the purposes of this DQ, assume that in the past there has been no difference. However, you have seen lots of women drinking sodas the past few months. You will perform a hypothesis test to determine if women now drink more sodas than men. State what you are testing. Write the hypotheses. Show the relevant numbers. Then explain your results. Use alpha = .05. From the data set, the sample statistics are: Sample mean: xm = 2, xf = 2.8 Sample standard deviation: sm = 1.58, sf = 1.92 Sample size: nm = 5, nf = 5 Where subscripts m stands for male and f stands for female The hypothesis is: Null hypothesis: Ho : xm = xf Alternative hypothesis: Ha : xf > xm Independent two sample t-test at one sided 0.05 level of significance was carried out to test the hypothesis of that females drink more sodas than males. Degree of freedom = nm + nf – 2 = 10-2 = 8 t = = -0.7184 t critical = 1.8595 As the critical value is greater than t test value, we accept the null hypothesis at 5% level of significance. There is not sufficient evidence at the 0.05 level of significance to support a claim that now females drink more sodas than males.