Fluent Essays

A DETAILED STEP BY STEP document is attached.Your goal for this Application is to analyze the frequency distributions of data provided as an SPSS data file. A worksheet is provided for this Application (attached), in the form of a Microsoft Word document. Download the Module 4 Application Assignment Worksheet and paste your output—the frequency distribution table—at the end of the document. Then, based on your output, answer the questions on the worksheet, typing your answers directly into the document.The Assignment:Run data distributions on the data file provided (attached). Complete the Module 4 Application Assignment Worksheet (attached), pasting the frequency distributions table at the end of the document. Be sure that your completed worksheet contains your responses to all questions and your SPSS output. assign_stepbystep_guide.pdf dataset.xlsx worksheet.docx Unformatted Attachment Preview PUBH6032 - Module 4 Application Step-By-Step Guide Step 1: Import the Microsoft Excel data file into SPSS 1. Save the Module 4 Application dataset (Excel file) to your computer. 2. Open SPSS, select “Open an existing data source,” highlight “More Files,” and click OK. 3. Look to the bottom of the Open Data dialog box and use the “Files of type” drop-down menu to select Excel file (instead of SPSS). Locate the folder where you saved the Module 4 Application dataset Excel file, highlight it, and click OK. 4. In the Opening Excel Data Source dialog box, make sure “Read variable names from the first row of data” is checked and click OK. 5. The data should now be imported into SPSS. Step 2: Create an ungrouped frequency distribution table for each of the following: AGE, SEX, GROUP, CHNG_CHOL, HDL, and GLYHB 1. Click Analyze > Descriptive Statistics > Frequencies. 2. Highlight AGE, SEX, GROUP, CHNG_CHOL,HDL, and GLYHB. Click on the arrow button to move them over to the “Variables” box. 3. Make sure the “Display Frequency Tables” box is checked. 4. Click OK. Step 3: Review your SPSS output and answer each of the following questions: 1. Types of variables – Click on Variable View and review the Measure column. Note that scale = quantitative and nominal = categorical. 2. How many? – Manually add up the frequency column. 3. What percent X years or younger? – Review the cumulative percent column. 4. What percent? – Review the valid percent column. Step 4: Paste each required frequency distribution table below. 1. 2. 3. 4. In the Viewer pane, select File > Export. Under “Objects to Export,” select All. From the “Type” drop-down list, select Word/RTF (*.doc). In “File Name,” give the output a unique name (e.g., OUTPUT_Module4). (Note the file folder where the Word document will be saved. The default is typically C:\Documents.) 5. Click OK to generate the Word file. *Now you can cut-and-paste the information from this Word file into the Module worksheet. You should also save the SPSS file you created for future assignments. © 2018 Laureate Education, Inc. ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 AGE 51 21 35 49 39 42 17 20 49 52 20 55 44 23 63 65 23 44 29 33 18 22 43 39 38 23 43 37 49 32 44 35 47 31 37 29 49 35 28 50 SEX 1 1 1 2 1 1 1 1 2 2 1 1 2 1 2 1 2 1 2 1 1 1 2 2 2 2 1 2 2 1 2 2 1 1 2 2 2 2 2 1 GROUP CHNG_CHOL 2 -2 2 2 1 -5 1 -1 1 -15 2 -1 1 1 1 -6 2 -2 1 -3 2 0 1 -9 2 0 2 0 1 -9 1 -10 2 1 1 -7 2 -1 1 -5 2 1 2 -2 1 -3 1 -8 2 -2 2 1 2 1 2 1 2 1 2 2 1 1 2 1 2 -1 -4 -2 -2 -1 0 0 -4 0 -1 -10 -8 2 -5 1 HDL 33 36 47 51 47 34 44 43 43 53 34 40 42 30 54 49 51 56 41 54 28 38 52 46 41 53 42 39 64 49 51 45 44 36 47 51 69 46 49 38 GLYHB 7.72 6.99 4.84 4.53 4.81 5.26 4.77 4.77 5.84 4.44 5.28 4.64 4.84 5.98 4.47 4.67 5.14 4.59 5.56 4.63 6.75 4.97 4.31 4.73 5.28 6.72 4.53 5.12 3.98 5.05 4.25 4.64 4.52 5.14 4.67 3.81 3.94 6.22 3.94 4.87 PUBH6032 - Module 4 Application Assignment Worksheet SPSS Frequencies Instructions For this assignment, you create and analyze frequency distributions of data provided as a Microsoft Excel file. Import the data into SPSS using the techniques described in Module 3, and then run frequency distribution tables, as instructed below, in SPSS. Note: It is recommended that you save the SPSS data file as you will use the same file for Modules 5 and 6 application assignments. Type your answers to all questions directly into the worksheet, and paste the required frequency distributions table at the end of this document. Submit this Application Assignment by Day 7 of Week 7. 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 six months while the control group (group 2) is given a placebo. After the six months, CHOL, HDL and GLYHB are again measured. The post-test data for each participant are provided in the Module 4 Application Assignment Data Set Excel file and can be found in the Module 4 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 pre-test to post-test HDL High density lipoprotein at post-test GLYHB Glycosylated hemoglobin at post-test --------------------------------------------------------------------------------------------------------------------Step 1: Import the Microsoft Excel data file into SPSS Step 2: Create an ungrouped frequency distribution table for each of the following: © 2018 Laureate Education, Inc. Page 1 of 2 AGE, SEX, GROUP, CHNG_CHOL, HDL, and GLYHB (be sure to save each output and paste into this worksheet document) Step 3: Review your SPSS output and answer each of the following questions: QUESTION Type answers below 1. What type of variable is AGE? ________________ 2. What type of variable is SEX? ________________ 3. What type of variable is GROUP? ________________ 4. What type of variable is CHNG_CHOL? ________________ 5. What type of variable is HDL? ________________ 6. How many participants were aged 20-29 years? ________________ 7. What percent of participants were 39 years old or younger? ________________ 8. How many participants had no change in their cholesterol value? ________________ 9. What percent of participants had HDL values of 46 mg/dL? ________________ 10. How many participants had GLYHB values of 4.52 or less? ________________ Step 4: Paste each required frequency distribution table below. © 2018 Laureate Education, Inc. Page 2 of 2 ... Purchase answer to see full attachment