RES5115: RESEARCH PREPARATION: PRINCIPLES AND APPROACHES QUANTITATIVE ASSIGNMENT(SPSS)


RES5115: RESEARCH PREPARATION: PRINCIPLES AND APPROACHES QUANTITATIVE ASSIGNMENT(SPSS)
SCHOOL OF SCIENCE
_______________________________________________________________________________________________
RES5115: RESEARCH PREPARATION: PRINCIPLES AND APPROACHES
QUANTITATIVE ASSIGNMENT
DUE DATE: Friday 28th of October 2016 before midnight
For this assignment, you are expected to perform all analyses using either SPSS or Excel/Real Statistics. However prior to this, you will need to generate your own sub-sample (unique to your student ID) from a larger sample using the random number generator in Microsoft Excel. To do this, you must first activate the Analysis ToolPak in Excel by following steps below.
Step 1: Open a new Excel spreadsheet as shown below.
2
Step 2: Go to File → Options.
Step 3: Click on Add-ins and then click Go…
3
Step 4: Select Analysis ToolPak and click OK.
You can now use the Analysis ToolPak under the Data tab by clicking on Data Analysis.
Note that the above steps are for Microsoft Excel 2010 and may differ slightly if you are using the 2013 version.
4
QUESTION 1 [25 MARKS]
BACKGROUND
A study was conducted to investigate the effects of short-term treatments with growth hormone (GH) on biochemical markers of bone metabolism in men with idiopathic osteoporosis. Subjects ranged in age from 32 to 57 years. Among the data collected were serum concentrations of insulin-like growth factor binding protein-3 at 0 and 7 days after the first injection and 1, 4, 8 and 12 weeks after the last injection (i.e. post- treatment) with GH. The serum concentration data for 116 men are given in the Excel file “Serum.xlsx”.
TASK 1 – SELECTING A SUB-SAMPLE
Open the Serum.xlsx data file as shown.
Click on the “Data” tab and then run the “Data Analysis” tool pack.
5
Select Random Number Generation and click OK.
Select “Uniform” in the drop-down menu next to “Distribution”. Then fill out the other boxes as shown. In the box corresponding to “Random Seed”, make sure you type the last two digits of your student ID here. This will ensure the set of random numbers is unique to you (unless someone else shares the same two numbers).
You should now be able to see 116 random numbers in Column H. Take note that your numbers will be different to those shown here.
Last two digits only
6
Highlight all the data in from Columns A to H using the mouse/keyboard. Then click on   and select Custom Sort…
Now click on  next to ColumnSort by and select (Column H). Make sure that under Order, it is set to Smallest to Largest. Then click OK.
The data are now sorted according to Column H. Again, note that what is shown here is very likely to be different to what you will have. Now, select the first 60 observations (i.e. Rows 2 to 61) from Columns A to G and copy this sub-sample across to SPSS or another Excel spreasheet (e.g. Sheet 2). These observations form the dataset that you will be working with for this question.
7
TASK 2 – ANALYSING THE DATA
(i) Use SPSS or Excel/Real Statistics and generate the necessary summary statistics and figures to describe the serum concentrations 0 and 7 days after the first GH injection. Proper interpretation of these output in the context of the problem is expected. (ii) Use the appropriate test in SPSS or Excel/Real Statistics and determine whether the GH treatment had any significant impact on serum concentration 7 days after the 1st injection. You will need to comment on the nature and extent of these differences (if any). Hypothesis statements are not necessary.  (iii) Confidence intervals should be presented and interpreted whenever possible. (iv) All relevant assumptions associated with your chosen test must be verified. (v) Repeat steps (i) – (iv), but in this instance compare the serum concentrations 1, 4, 8 and 12 weeks after the last GH injection. If the initial analysis suggests a difference, you will then need to perform a post hoc test to determine where the difference(s) lie. Hypothesis statements are not necessary. (vi) Based on the outcomes of the two analyses, comment on the short-term and post-treatment effect of GH treatment on serum concentrations.

8
QUESTION 2 [25 MARKS]
BACKGROUND
Mental illness within the Australian population is becoming more apparent. A nationwide survey in 2007 on mental health and wellbeing conducted by the Australian Bureau of Statistics (ABS) found that an estimated 3.2 million Australian (20% of the population between the ages of 16 and 85) had a mental disorder in the twelve months prior to the survey, and the estimated economic impact of mental health problems is up to $20 billion each year.
The mental health of fly-in/fly-out (FIFO) workers in resources sector became a subject of interest in recent years. Although the financial reward is great, reports of FIFO practices negatively impacting the workers and their Australian families are not uncommon.
To determine the extent of the mental health problem in the resources industry, a health and well-being survey was carried at a particular mining company. In the survey are questions relating to the worker’s demographics, behaviour in the past twelve months, work/lifestyle/family-related issues and others.
Also included in the survey are the Kessler’s mental health questions which will allow one to clinically determine the severity of mental health problems for an individual. The Kessler questions were developed by Professor Kessler and Mroczek (1992) to assess the severity (“1 = None of the time”, “2 = A little of the time”, “3 = Some of the time”, “4 = Most of the time” or “5 = All of the time”) of anxiety and depression related symptoms experienced in the past month. Collectively, they are the Kessler 10 or K10 questions. A K10 score is calculated by summing the scores of the 10 questions. The minimum possible score is 10 (low distress) and the maximum being 50 (very high distress).
Suppose that you are interested in examining whether there is an association between worker’s behaviours and their distress levels in the past 12 months.  The items of interest are presented in Table 1 and the relevant survey data are given in the Excel file “Mental Health.xlsx”. Note that a blank entry represents a missing response.
Table 1   Items of interest in the Health and Well-Being questionnaire Over the past 12 month (1 = Daily; 2 = Weekly; 3 = Monthly; 4 = Once or Twice; 5 = Almost never) (1) How often have you felt worn out? (2) How often have you been emotionally drained? (3) How often have you been irritable? (4) How often have you had aches and pains? (5) How often have you argued with a work colleague? (6) How often have you felt anxious? (7) How often have you had no energy or enthusiasm? (8) How often have you had 6 or more standard drink in one session? (9) How often have you used prescription or non-prescription drugs? (10) How often have you missed a meal? (11) How often have you argued with friends or family? (12) How often have you had trouble sleeping? (13) How often have you exercised?
9
TASK 1 – SELECTING A SUB-SAMPLE
Open the Mental Health.xlsx data file as shown.
Click on the “Data” tab and then run the Analysis ToolPak by clicking on Data Analysis.
Select Random Number Generation and click OK.
10
Select “Uniform” in the drop-down menu next to “Distribution”. Then fill out the other boxes as shown. In the box corresponding to “Random Seed”, make sure you type the last two digits of your student ID here. This will ensure the set of random numbers is unique to you (unless someone else shares the same two numbers).
You should now be able to see 1269 random numbers in Column O. Take note that your numbers will be different to those shown here.
Last two digits only
11
Highlight all the data in from Columns A to O using the mouse/keyboard. Then click on   and select Custom Sort…
Now click on  next to Column → Sort by and select (Column O). Then click OK.
The data are now sorted according to Column O. Again, note that what is shown here (next page) is very likely to be different to what you will have.
12
Now, select the first 150 observations (i.e. Rows 1 to 151) from Columns A to N. Copy this sub-sample across to another spreadsheet (e.g. Sheet 2) in Excel. In the example below, Sheet 2 was renamed to Sub- sample.

13
TASK 2 – SELECTING ITEMS FROM THE QUESTIONNAIRE TO ANALYSE
Now that you have your sub-sample, here you will determine which THREE (3) of the 13 items to analyse. Again, go to the “Data” tab and then run the “Data Analysis” tool pack. Select “Random Number Generation” and click “OK”.
Now generate 13 random uniform numbers and store them in Column P of the sub-sample spreadsheet. In the “Random Seed” box, type the last two digits of your student ID again.
You should now be able to see 13 random numbers in Column P. Take note that your numbers will again be different to those shown here. Now, type the numbers 1 – 13 (to represent the items) in Column Q and right next to the random numbers that you have just generated.
Last two digits only
14
Now, highlight all the numbers in Columns P and Q using the mouse/keyboard. Then sort the numbers by
clicking  and then   Sort Smallest to Largest.
The first three numbers in Column Q refer to the items in Table 1 that you will need to analyse. In this example, these are items (1), (3) and (13). Copy the relevant data for the 3 items and the corresponding K10 scores across to SPSS or another Excel spreadsheet (e.g. Sheet 3). These observations form the dataset that you will be working with for this question.
TASK 3 – ANALYSING THE DATA
(i) Use SPSS or Excel/Real Statistics and generate all necessary summary statistics and figures to describe the relationship between the workers’ mental health (according to the K10 scores) and each of your selected items (make sure you consider each item separately from the others). Proper interpretation of these output in the context of the problem is expected. (ii) Use the appropriate test in SPSS or Excel/Real Statistics and determine whether there is a difference in distress levels across the response categories for these each of these items. If so, perform a post-hoc test to determine where the difference(s) lie. You will need to comment on the nature and extent of these differences (if any). Hypothesis statements are not necessary.  (iii) Confidence intervals should be presented and interpreted whenever possible. (iv) All relevant assumptions associated with your chosen test must be verified.  (v) Briefly comment on the practical implications of your findings and how they may be useful.
15
SUBMISSION GUIDELINES:
This assignment must be completed using either SPSS or Excel/Real Statistics. It is expected that your assignment solutions are presented in the context of the problem. Simply stating the numbers from the output table will not suffice. Examples of this are given on Blackboard in the Quantitative weekly folders corresponding to the workshop weeks. The write-up of your analyses must be presented in Microsoft Word in Times New Roman format with 11-pt font with single spacing and in grammatically correct English. The page margins must be 2 cm for all sides. Failure to do so will result in deduction of marks. Furthermore, no handwritten assignments will be accepted. Copy only the relevant outputs, tables and/or figures from SPSS or Excel across to the Word document. All tables and figures must be labelled appropriately. The write-up for each question (not each part) must not exceed THREE (3) pages (including all tables and figures). Any lines exceeding the three-page limit will not be considered or read. Your assignment submission will also need to include the dataset that is unique to your student ID, along with a cover page (see page 16).
You are reminded of the declaration
“I certify that the attached assignment is my own work and that any material drawn from other sources has been acknowledged”.
that you sign when you complete the coversheet. The assignment solutions must be your own work.
You must submit your completed assignment via Turnitin by Friday 28th of October 2016 before midnight. In the interests of fairness, submission extensions will be given only in exceptional circumstances, and then only in accordance with University rules (see page 17).
Note: If your datasets do not match the ones generated with your student ID (last two digits only), you will be awarded a mark of zero regardless of whether the analysis is correct.
SUBMISSION CHECKLIST:
Your submission will need to be a single document containing the following:
o Cover sheet (1 page) o Your solutions to Questions 1 and 2 (maximum of 3 pages per question). o Your datasets (No restriction)
MARKING GUIDELINES:
(1) Adherence to submission guidelines above (10%) (2) Correct selection and implementation of tests and with correct findings (30%) (3) Proper presentation and interpretation of results in the context of the study and objective(s) (30%) (4) Use of statistics to support and re-inforce findings and arguments (15%) (5) Spelling, grammar and overall narrative (15%)
The above marking guidelines are estimates and variations may occur. If a test is incorrectly chosen, then only a maximum of 10 marks is attainable.
16
ASSIGNMENT COVER SHEET Electronic or manual submission
Form:  SSC-115-06-08
UNIT CODE:        TITLE:
NAME OF STUDENT (PRINT CLEARLY)                          FAMILY NAME                                  FIRST NAME
STUDENT ID. NO.
NAME OF LECTURER (PRINT CLEARLY)

DUE DATE
Topic of assignment

Group or tutorial (if applicable)

Course

Campus

I certify that the attached assignment is my own work and that any material drawn from other sources has been acknowledged.   Copyright in assignments remains my property.  I grant permission to the University to make copies of assignments for assessment, review and/or record keeping purposes.  I note that the University reserves the right to check my assignment for plagiarism.  Should the reproduction of all or part of an assignment be required by the University for any purpose other than those mentioned above, appropriate authorisation will be sought from me on the relevant form.
OFFICE USE ONLY
If handing in an assignment in a paper or other physical form, sign here to indicate that you have read this form, filled it in completely and that you certify as above.
Signature Date
OR, if submitting this paper electronically as per instructions for the unit, place an ‘X’ in the box below to indicate that you have read this form and filled it in completely and that you certify as above.  Please include this page in/with your submission.   Any electronic responses to this submission will be sent to your ECU email address. Agreement                    Date
PROCEDURES AND PENALTIES ON LATE ASSIGNMENTS (University Rule 39)  A student who wishes to defer the submission of an assignment must apply to the lecturer in charge of the relevant unit or course for an extension of the time within which to submit the assignment. (39.1)  Where an extension is sought for the submission of an assignment the application must:  be in writing  –  preferably before the due date; and   set out the grounds on which deferral is sought. ( see 39.2)  Assignments submitted after the normal or extended date without approval shall incur a penalty of loss of marks. (see 39.5) ACADEMIC MISCONDUCT (University Rule 40) All forms of cheating, plagiarism or collusion are regarded seriously and could result in penalties including loss of marks, exclusion from the unit or cancellation of enrolment. – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – – –
ASSIGNMENT RECEIPT       To be completed by the student if the receipt is required
UNIT

NAME OF STUDENT

STUDENT ID. NO.

NAME OF LECTURER

RECEIVED BY
Topic of assignment

DATE RECEIVED
17
CONDITIONS FOR ASSIGNMENT EXTENSION
In accordance with ECU policy, extensions are given on the following grounds and must include all appropriate supporting documentation:
 Ill health or injury for an extended period of time – medical certificate is required;  Compassionate grounds – supporting documentation includes e.g. newspaper notice plus other evidence if not the same family name, e.g. marriage certificate;  Representation in sporting activities at a national or international level;  Representation in significant cultural activities;  Employment related intrastate, interstate and overseas travel – a letter from your employer, including your supervisors’ full contact details.
The following factors will NOT be considered as grounds for extension:
 Routine demands of employment;  Stress or anxiety normally associated with examinations, required assessments or any aspect of course work;  Routine financial support needs;  Lack of knowledge of the requirements of academic work;  Difficulties with English language;  Scheduled anticipated changes of address, moving home etc;  Demands of sport, clubs, social or extra-curricular activity other than those specified above;  Recreational travel (domestic or international);  Planned events such as weddings, birthday parties etc;  Misreading the deadline.
All extension requests will require students to complete the Assignment Extension Form (downloadable from the Quantitative Assignment folder on BB), along with appropriate documentation such as a medical certificate, letter from employer, etc. Original copies of these documents will then need to be provided. Scanned or photocopied documents are NOT acceptable. All documents must be provided no longer than ONE week after the assignment deadline.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: