HH/HLST 2300: Statistical Methods in Health Studies
Fall Assignment
A researcher has collected data for 7681 patients who had a procedure performed at Clinic ABC in 2009 that serves the Greater Toronto Area regions (Excel file: Fall Assignment Data.xls). The data includes the unique patient identifier, sex (male = 1; female = 2), age (years) and patient region (Durham = 1; Halton = 2; Peel = 3; York = 4). The researchers also collected some lifestyle data including smoking frequency (every day = 1; some days = 2; not at all = 3) and whether the patient eats herbal supplements (yes = 1; no = 2). The researcher also collected data on the number of times in a week the patient performs vigorous activity (where 99 is the user-defined missing value with the label ‘unable to do vigorous activity), the number of times in a week they perform moderate activity (where 99 is the user-defined missing value with the label ‘unable to do moderate activity), and the number of times in a week they perform strength activity (where 99 is the user-defined missing value with the label ‘unable to do strength activity). Note that for these three activity variables, there are also system-missing values in the dataset. Finally, we have the procedure order date/time, procedure completion date/time and the procedure score.
1. Generate Variable Information and Variable Values tables for the dataset. Copy and paste these generated SPSS tables. Note, while you already know how to generate these tables, you may want to hold off on this question until you learn more about missing values so that you don’t have to generate these tables twice.
2. Create a new variable, ‘Age_cat1’ that groups the variable ‘Age’ into two categories: <65yrs and ≥65 yrs. Copy and paste the screenshots of the SPSS window(s) used to show how you created the new variable. Remember to add labels to all values. Generate a pie chart of this new variable where the slices represent proportions belonging to each category. Show data labels to display the percentages in each slice (round to 2 decimal places and show the % symbol).
3. Create a new variable, ‘Smoking_binary’ that groups the variable ‘Smoking Frequency’ in two categories: yes (combines categories every day and some days) and no (category not at all). Copy and paste the screenshots of SPSS window(s) used to show how you created the new variable. Remember to add labels to all values. Generate a pivot table that includes the observed counts of ’Smoking_binary’ (placed as rows) by ‘Region’ (placed as columns), layered by ‘Sex’. Copy and paste the generated SPSS pivot table. Answer the following question: How many female Halton region residents smoke?
4. Create a new variable called ‘Age_cat2’ that groups the variable ‘Age’ into the following: 18-24 yrs, 25-44 yrs, 45-64 yrs, 65+ yrs. Generate a stacked bar graph such that each bar represents a different ‘Age_cat2’ category and the stacks represent the percentage of the various categories within the ‘Smoking Frequency’. Order the stacks such that the ‘every day’ category is the bottom or base stack and the ‘not at all’ category is the top stack. Add data labels (1 decimal place with % trailing character). Copy and paste the generated SPSS stacked bar graph.
5. Create a new variable ‘zProcedurescore’ that is the standardized variable of ‘Procedure Score’. But, before you generate the z-scores for ‘Procedure Score’, ensure that the variable is not markedly non-normal by copying and pasting the appropriate generated SPSS output table and showing your calculations to determine skewness. After you’ve created the new variable ‘zProcedurescore’, generate case summaries of the variables ‘Procedure Score’ and ‘zProcedurescore’ for the first 10 cases in your dataset. Copy and paste the generated SPSS table and answer the following question: Is case 1’s procedure score (.1578) above or below the mean procedure score? Justify your answer with the Case Summary table.
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
