This is a test to see how accurate and creative you can be with a common dataset. Use the data set supplied (hypertension, diabetes, cholesterol in subjects, including medication, weight, age, etc) in Docsharing and using Excel, provide the following for the variable(s) of your choice: 1. Frequency distribution of a variable and bar graph of the same variable 2. Descriptive statistics of a continuous dataset: mean, median, mode, skewness, kurtosis, standard deviation 3. Cross tabulation of two variables
4. Comparison of the effect of three or more groups (single variable) on a single continuous variable 5. Scatterplot of two continuous variables
6. Correlation between the two continuous variables
HERE ARE MORE SPECIFIC DETAILS:
1. Frequency distribution bar graph (as in Week #1) – nominal or ordinal variables (Polit, p. 25) 2. Continuous variable descriptive stats: mean, median, mode, skewness, kurtosis, SD – (as in Week #1 Simple Descriptive Excel Worksheet) – requires a continuous variable, e.g., bp, wt, ht 3. Cross tabulation of two variables – requires making a table (as per Polit pp. 59-61) using nominal variables or groups, e.g., yes or no; on meds or not on meds; married or not married, etc. (Week #2) 4. Comparison of the effect of three or more groups (single variable) on a single continuous variable – this is a One-Way ANOVA with groups, e.g., ed status, medication status, etc. (see Polit pp. 142-146). (We did this in Week #2) 5. Scatterplot of two continuous variables (as Week #1) – We did this - need 2 continuous variables as IV (X) versus DV (Y); recall that the IV causes the outcome DV. 6. Correlation between the two continuous variables (from #5) – Pearson’s r, R2, and z –transform statistic Polit, Chpt. 4, pp. 71-72; Chpt. 9, pp. 197-205 – Week #4). ________________
Think carefully about what kind of variables to choose for the given tasks. A...