A physician conducts a study to determine the proportion of adults with desirable cholesterol level. A cholesterol level of 60 mg/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.

b. Summarize the sample data in a contingency table. Use Excel to sort or filter the data so that you can get a count for each category. A cell in the table has already been filled out for you as a hint. For this part, submit only the completed table. Male Female With desirable cholesterol level (HDL above or equal to 60 mg/dL) 64 Not with desirable cholesterol level (HDL below to 60 mg/dL)