Part B: Cholesterol Level A physician conducts a study to determine the proportion of adults with desirable cholesterol level. A random sample of cholesterol level measurements for adults listed in the Excel sheet \"Assignment 3 Body Data\" in the \"Written Assignment 3" folder on Sakai. A cholesterol level of 60 mgl'dL or above for an adult is considered to be desirable. 3. (Submit a screenshot of your written or typed answer.) This question will test the claim that the proportion of female adults with a desirable cholesterol level is higher than the proportion of male adults with a desirable cholesterol level. a. Use Excel to first lter the data so that you can separate the data into two groups by (biological) gender. Copy the HDL measurements for male adults in a new sheet. Copy the HDL measurements for female adults in another new sheet. (There is nothing to submit for this part.) b. Summarize the sample data in a contingency table. Use Excel to sort or lter the data so that you can get a count for each category. A cell in the table has already been lled out for you as a hint. For this part. submit only the completed table. Female With desirable cholesterol level (HDL above or equal to 60 mew.) Not with desirable cholesterol level (HDL below to so midi.) c. Use the sample data to nd a point estimate for the population proportion of female adults with desirable cholesterol level. 151. and the point estimate for the population proportion of male adults with desirable cholesterol level. :02. Express your answers with three decimal places. d. Test the claim, at the 5% significance level, that the proportion of female adults with desirable cholesterol level is greater than the proportion of male adults with desirable cholesterol level. Use the Brock Excel calculator for all calculations ande. Test the claim from part cl. by writing all ve steps of the hypothesis test. Use the critical value method and refer to the values calculated from Excel. From the sample data, can you conclude that the proportion of female adults with desirable cholesterol level is greater than the proportion of male adults with desirable cholesterol level