Conduct a test to determine if the proportion of males that responded true to the statement in the survey that, "Whole foods (i.e. raw vegetables and meats) contain sodium," is different from the proportion of females that responded true to this statement. Use a significance level of 0.05. a. State hypotheses (null, alternative) and the data analysis method you would use, and way. b. Taste your hypotheses by hand calculation first. (Write a very detailed answer including the formulas needed if use them, all the steps to reach your final answer must be included).c. Test your hypotheses using excel to make sure your answer is right, and provide computer output. (please send the Excel file associated with the answers) d. Provide relevant calculations, and make a concluding statement regarding your findings. e. Describe the assumptions necessary for conducting this test.