Reference no: EM131347321
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.
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 data set "Module 4, 5, and 6 applic assign data_Cholesterol etc" 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:
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
What type of variable is AGE?
What type of variable is SEX?
What type of variable is GROUP?
What type of variable is CHNG_CHOL?
What type of variable is HDL?
How many participants were aged 30-39 years?
What percent of participants were 49 years old or younger?
How many participants had no change in their cholesterol value?
What percent of participants had HDL values of 43 mg/dL?
How many participants had GLYHB values of 4.67 or less?
Step 4: Paste each required frequency distribution table.
Attachment:- module4_application_data_set_excel__doc.rar
Explain why the curve has this shape
: Now draw a long-run aggregate supply curve that intersects a short-run AS curve. What is the rel tionship between short-run AS and long-run AS?
|
What is aftertax cash flow from the sale of this asset
: Consider an asset that costs $246,400 and is depreciated straight-line to zero over its 8-year tax life. The asset is to be used in a 3-year project; at the end of the project, the asset can be sold for $30,800. Required : If the relevant tax rate is..
|
Payback period-npv and profitability index
: The firm requires its projects to recover the initial investment within 3 years. Payback period, NPV, Profitability index, Internal rate of return, Should the firm invest in this project? Why or why not? You must give specific reasons based on all o..
|
Discuss the financial position of trap adventures inc
: What is the largest percentage? What is the smallest percentage? Discuss the financial position of Trap Adventures, Inc using the following ratios: Current ratio and Return on equity.
|
Create an ungrouped frequency distribution table
: 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 ..
|
Firm has common stock with market price
: A firm has common stock with a market price of $100 per share and an expected dividend of $5.61 per share at the end of the coming year. A new issue of stock is expected to be sold for $98, with $2 per share representing the underpricing necessary in..
|
What is the growth rate for an economy
: What is the growth rate for an economy in which TFP grows at a rate of 3 percent per year, the size of the labor force is unchanged, the capital stock grows at a rate of 2 percent per year, and labor and capital each account for 50 percent of outp..
|
Under federal bankruptcy court protection
: The Pen Central Railroad has not paid local taxes since 1969, under federal bankruptcy court protection. Some years later the court required Pen Central to offer municipalities a choice of two payment options to clear this liability. Which alternativ..
|
How much must the government borrow
: If the government budget deficit equals $220 billion, and the money supply increases by $100 billion, how much must the government borrow?
|