CHNG_CH 1 50 1 2 -2 33 7.72 2 21 1 2 2 35 6.99 3 35 1 1 -5 47 4.84 4 49 2 1 -1 51 4.33 5 38 1 1 -16 47 4.81 6 42 1 2 -1 34 5.26 7 17 1 1 1 43 4.77 8 20 1 1 -6 43 4.77 9 49 2 2 -2 43 4.84 10 41 2 1 -4 53 4.44 11 20 1 2 0 34 5.28 12 55 1 1 -9 39 4.64 13 44 2 2 0 42 4.84 14 23 1 2 0 30 5.78 15 64 2 1 -10 54 4.47 16 65 1 1 -10 49 4.67 17 23 2 2 1 50 5.14 18 44 1 1 -7 56 4.59 19 29 2 2 -1 41 5.26 20 32 1 1 -4 54 4.63 21 18 1 2 1 28 6.75 22 22 1 2 -3 37 4.97 23 43 2 1 -3 52 4.31 24 39 2 1 -8 46 4.33 25 38 2 2 -2 41 5.28 26 22 2 2 -1 53 6.72 27 43 1 1 -3 41 4.53 28 37 2 2 -2 39 5.12 29 49 2 1 -2 64 3.98 30 32 1 2 -1 49 5 31 43 2 1 0 51 4.25 32 35 2 2 0 44 4.64 33 47 1 1 -4 44 4.52 34 31 1 2 0 36 5.14 35 37 2 2 -1 47 4.67 36 28 2 1 -10 51 3.41 37 49 2 1 -7 69 3.94 38 35 2 2 2 46 6.22 39 28 2 1 -5 49 3.94 40 50 1 2 1 38 4.87 Module 6 Application Assignment Worksheet SPSS Hypothesis Testing Instructions For this assignment, you perform a two-sample independent t-test, an ANOVA, and a correlation analysis related to the data set that has been utilized in the previous two modules. Import the data into SPSS or, if you correctly saved the data file from the Module 4 and 5 Assignments, you may open and use that saved file to complete this Assignment. Type your answers to all questions directly into the worksheet, and paste the required output at the end of this document. Submit this Application Assignment by Day 7 of Week 11. Research Scenario A researcher is interested in the effect of a new medication on serum cholesterol, HDL cholesterol, and glycosylated hemoglobin of adults. The researcher randomly selects a sample of 40 (20 male and 20 female) participants who have been diagnosed with high cholesterol. Assuring equal distribution of males and females, the participants are randomly assigned to one of two conditions (or groups): Following pretest measures of serum cholesterol (chol), high-density lipoprotein cholesterol (HDL), and glycosylated hemoglobin (glyhb), the experimental group (Group 1) is given the medication for a period of 6 months while the control group (Group 2) is given a placebo. After the 6 months, chol, HDL, and glyhb are again measured. The posttest data for each participant are provided in the Module 4 Application Assignment Data Set Excel file and can be found in the Module 6 Learning Resources. The codebook for the data provided is as follows: AGE Age in years SEX 1 = male, 2 = female GROUP 1 = medication, 2 = placebo CHNG_CHOL change in cholesterol from pretest to posttest HDL High-density lipoprotein at posttest GLYHB Glycosylated hemoglobin at posttest --------------------------------------------------------------------------------------------------------------------Step 1: Import the Microsoft Excel data file into SPSS or use the correct saved SPSS data file as noted in the instructions above. Step 2: Conduct an independent samples t-test to determine if there is a difference between Group 1 (medication) and Group 2 (placebo) in terms of changes in cholesterol values. Note that the independent variable is GROUP, and the dependent variable is 2014 Laureate Education, Inc. Page 1 of 3 CHNG_CHOL. For this analysis, choose a two-tailed test of significance. (Be sure to save your output.) Step 3: Conduct a between-subjects ANOVA to determine if there is a difference between sex (males vs. females) and HDL. Note that the independent variable is SEX, and the dependent variable is HDL. For this analysis, choose a two-tailed test of significance. (Be sure to save your output.) Step 4: Conduct a Pearson correlation to determine if there is a relationship between HDL and GLYHB. For this analysis, choose a two-tailed test of significance. (Be sure to save your output.) Step 5: Review your SPSS output and answer each of the following questions: From the independent samples t-test output: A. What is the mean CHNG_CHOL for Group 1? _____________ B. What is the CHNG_CHOL standard deviation for Group 1? _____________ C. What is the mean CHNG_CHOL for Group 2? _____________ D. What is the CHNG_CHOL standard deviation for Group 2? _____________ E. What is the calculated t-score (equal variances assumed)? _____________ F. What is the probability that the obtained t-score was simply due to chance as opposed to actual gender differences [see \"Sig (two-tailed)\" on output]? _____________ G. If the probability associated with the obtained t-score is <0.05, we assume the results (difference in mean CHNG_CHOL between groups) are much more likely due to the effects of the medication than to chance. In other words, we would say the results are statistically significant. Are the results statistically significant (yes or no)? ________ From the ANOVA output: H. What is the mean HDL for group males? _____________ I.What is the HDL standard deviation for males? _____________ J. What is the mean HDL for group females? _____________ 2014 Laureate Education, Inc. Page 2 of 3 K. What is the HDL standard deviation for females? _____________ L. What is the calculated F-value? _____________ M. What is the probability (noted as \"Sig\" on output) that the obtained F-value was simply due to chance as opposed to actual gender differences? _____________ From the correlation output: N. What is the Pearson correlation score for HDL and GLYHB? __________ O. What is the direction of the correlation value and what does this mean? ______________________________________________________ ______________________________________________________ P. What is the probability for the obtained Pearson correlation score [see \"Sig (twotailed)\" on output]? _____________ Q. If the probability associated with the Pearson correlation is <0.05, we assume a significant relationship. Is there a significant relationship between HDL and GLYHB? __________ Step 6: Paste all required SPSS output below. 2014 Laureate Education, Inc. Page 3 of 3