Manipulating SPSS Data and Running Descriptive Statistics Assignment

You may work with on this assignment with a group or alone. You must do this assignment on campus as this software is only available on RU computers.

The SPSS Introductory Handout and Intro to Data Analysis Handout will help you with this assignment (both are posted to the course web site). Use the Coffee Consumption Data (posted to the course web site) for this assignment. You can double-click on the file name to automatically open the file in SPSS or you can right click on the file name, choose Save Target As, save the file to your H drive, and then double-click it to open it in SPSS.

1. Susan is interested in how much coffee people drink at work. To answer this question, she has 10 individuals record the number of cups of coffee they drink daily at work for 4 days. She also collects an index of job stress and each person’s age. The data file contains the four variables concerning coffee drinking (day1 through day4), the job stress variable (jobstres), and the age variable (age).

A. Create a categorical age variable named agecat with three age categories, 24 and younger, 25-29, and 30 and older (hint – you should use the steps under Recode into a Different Variable from page 8 of the SPSS Introductory Handout). Be sure to assign the appropriate variable labels and value labels to this new field (hint – refer to the steps under Defining SPSS Variables Yourself, steps 4 and 5 on page 3 in the SPSS Introductory Handout). The variable agecat should not contain any decimal places.

B. Create a categorical job stress variable named jobcat with two categories, 1 (job stress score less than 20) and 2 (job stress score equal to or greater than 20). Hint – you should use the steps under Recode into a Different Variable from page 8 of the SPSS Introductory Handout. Be sure to define the appropriate variable and value labels for this new field (the value labels should be 1=low stress and 2 = high stress). Jobcat should contain no decimal places.

C. Create a new variable called drinktot (hint – you should use the steps under Computing Variables: o Compute Variables Using a Formula on page 5 of your SPSS Introductory Handout). This field should be the sum of 4 days coffee consumption. Don’t forget to assign a variable label to this field.

D. Run a frequency analysis for each of the three variables you created (agecat, jobcat and drinktot) – hint: you should use the steps under Running a Frequency in SPSS on page 10 of your SPSS Introductory handout. For each analysis, run the appropriate measure of central tendency and measure of dispersion (variation). (1) Which age category has the most respondents? (2) On average, are the employees experiencing low or high stress? (3) What percentage of respondents consume less than 10 cups of coffee?

E. Run descriptive statistics on the age (your original age variable not the new age variable you created) and drinktot fields - hint: you should use the steps under Running Descriptives in SPSS on page 11 of your SPSS Introductory handout. Include the following statistics: mean, minimum, maximum, range, standard deviation, mean, sum, skewness, and kurtosis. (1) Based on the output, do you feel more confident making judgments about age or coffee consumption? Why? (2) How many cups of coffee, in total, were consumed over the 4 days? (3) What can you say about drinktot based on the skewness and kurtosis statistics?

F. Run a crosstab where the stub (row) is jobcat and the banner (column) is agecat. Include the row, column, and total percentages - - hint: you should use the steps under Running Crosstabs in SPSS on page 12 of your SPSS Introductory handout. (1) Which age group is experiencing the most job stress? the least job stress? (2) What percentage of respondents experiencing high stress are 25 to 29? (3) What percentage of respondents are 25 to 29 and say they experience low job stress? (4) What percentage of those 25 to 29 say they are experiencing high job stress?

What You Need to Turn in for this Assignment

Print the results from D, E, and F. Be sure to write the answers to any questions asked directly on the appropriate print-out (and please staple or clip the pages together).