please solve this

A physician conducts a study to determine the proportion of adults with risk for heart disease and stroke. One factor for heart disease and stroke is diastolic blood pressu random sample of diastolic blood pressure measurements for adults listed in the Excel sheet "Assignment 3 - Body Data" in the "Written Assignment 3" folder on Sakai. A diastolic blood pressure over 80 mm Hg is considered to be at risk. This question will test the claim that the proportion of adults under 65 with diastolic blood pressure above 80 mm Hg is less than the proportion of adults 65 and over. a. (Nothing to submit.) Use Excel to filter the data so that you can separate the data into two groups: 1) adults under 65, and 2) adults 65 and over. Copy the diastolic blood pressure for adults under 65 in a new sheet. Copy the diastolic blood pressure for adults 65 and over in another new sheet. b. (Submit a screenshot of your written or typed table.) 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. Under 65 65 and over No risk (diastolic blood pressure less than or equal to 80 mm Hg) At Risk (diastolic blood pressure more than 50 mm Hg) c. (Submit a screenshot of your written or typed answer.) Use the sample data to find a point estimate for the population proportion of adults under 65 at risk, pi, and the point estimate for the population proportion of adults 65 and over at risk, Pz. d. (Submit a screenshot of Excel.) Test the claim, at the 19% significance level, that the proportion of adults under 65 at risk is less than the proportion of adults 65 and over at risk. Use the Brock Excel calculator for all calculations and submit a screenshot of that sheet, including all input values and output results. e. (Submit a screenshot of your written or typed answer.) 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 adults under 65 at risk is less than the proportion of adults 65 and over at risk