What percent of participants were 39 years old or younger?

Application Step-By-Step GuideStep1: Import the Microsoft Excel data file into SPSS1. 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-downmenu to select Excel file (instead of SPSS). Locate the folder where you saved theModule 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 thefirst 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 GLYHB1. Click Analyze > Descriptive Statistics > Frequencies.2. Highlight AGE, SEX, GROUP, CHNG_CHOL,HDL, and GLYHB. Click on the arrow button tomove 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 thatscale = 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. In the Viewer pane, select File > Export.2. Under “Objects to Export,” select All.3. From the “Type” drop-down list, select Word/RTF (*.doc).4. In “File Name,” give the output a unique name (e.g., OUTPUT_Module4). (Note the filefolder 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.
For this assignment,you create and analyze frequency distributions of data provided as a MicrosoftExcel file. Import the data into SPSS using the techniques described in Module3, and then run frequency distribution tables, as instructed below, in SPSS. Note: It is recommended that you savethe SPSS data file as you will use the same file for Modules 5 and 6application assignments. Type your answers to all questions directly into theworksheet, and paste the required frequency distributions table at the end ofthis document.
Submit thisApplication Assignment by Day 7 of Week 7.
Research Scenario
Aresearcher 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 of40 (20 male and 20 female) participants who have been diagnosed with highcholesterol. Assuring equal distribution of males and females, the participantsare randomly assigned to one of two conditions (or groups): Following pretest measures of serumcholesterol (CHOL), High density lipoprotein cholesterol (HDL), andglycosylated hemoglobin (GLYHB), the experimental group (group 1) is given the medicationfor a period of six months while the control group (group 2) is given aplacebo. After the six months, CHOL, HDLand GLYHB are again measured.
Thepost-test data for each participant are provided in the Module 4 ApplicationAssignment 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 yearsSEX 1 =male, 2=femaleGROUP 1 =medication, 2=placeboCHNG_CHOL change in cholesterol from pre-testto post-testHDL High density lipoprotein atpost-testGLYHB Glycosylated hemoglobin atpost-test———————————————————————————————————————
Step 1: Import the Microsoft Excel data file into SPSS
Step 2: Create an ungrouped frequency distribution table for each of thefollowing:
AGE, SEX, GROUP, CHNG_CHOL, HDL, and GLYHB (be sure to save each output and paste intothis worksheet document)
Step 3: Review your SPSS output and answer each of the following questions:
QUESTION
Type answers below
1. What type of variableis AGE?
________________
2. What type of variableis SEX?
________________
3. What type of variableis GROUP?
________________
4. What type of variableis CHNG_CHOL?
________________
5. What type of variableis HDL?
________________
6. How many participantswere aged 20-29 years?
________________
7. What percent ofparticipants were 39 years old or younger?
________________
8. How many participantshad no change in their cholesterol value?
________________
9. What percent ofparticipants had HDL values of 46 mg/dL?
________________
10. How many participantshad GLYHB values of 4.52 or less?
________________
Step 4: Paste each required frequency distribution table below.