Part B Cholesterol Level A Physician Conducts A Study To Determine The Proportion Of Adults With Desirable Cholesterol 1 (73.99 KiB) Viewed 84 times
Part B Cholesterol Level A Physician Conducts A Study To Determine The Proportion Of Adults With Desirable Cholesterol 2 (79.14 KiB) Viewed 84 times
Part B Cholesterol Level A Physician Conducts A Study To Determine The Proportion Of Adults With Desirable Cholesterol 3 (23.03 KiB) Viewed 84 times
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 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. a. Use Excel to first filter 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 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) c. Use the sample data to find a point estimate for the population proportion of female adults with desirable cholesterol level, P2, and the point estimate for the population proportion of male adults with desirable cholesterol level, P. 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 and 2
(HDL below to 60 mg/dL) c. Use the sample data to find a point estimate for the population proportion of female adults with desirable cholesterol level, P2, and the point estimate for the population proportion of male adults with desirable cholesterol level, Pz. 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 and 2 + submit a screenshot of that sheet, including all input values and output results. For this part, submit only the screenshot. e. Test the claim from part d. by writing all five 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?
#3 With desirable cholesterol level (HDL above or equal to com/dl) Male 29 Female 64 124 83 Not with desirable Charestere level (HDL below forg/dl)
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!