you will compare the risk factors in men and women where you will use the following patient characteristics: age, systolic blood pressure, diastolic blood pressure, use of anti-hypertensive medication, current smoker, total serum cholesterol, mg/dL, body mass index (BMI), and diabetes, by determining the means for each risk factor . Create a table that summarizes your results.

H₀The risk factors for heart disease listed as patient characteristics are not related to if the patient is male or female in the Framingham Heart Study. (Null Hypothesis)

H₁The risk factors for heart disease listed as patient characteristics are related to if the patient is male or female in the Framingham Heart Study. (Alternative Hypothesis)

Steps of Excel Analysis

To conduct your analysis of the data sort the data by the Sex/Gender variable and sort by smallest to largest.

Compute the means and standard deviations for continuous variables using AVERAGE(range) and STDEV(range) functions - Compute n(%) for dichotomous variables using COUNT(range) and COUNTIF (range, criteria) functions modifying ranges accordingly.