There are two goals of this assignment: (1) To get more familiar with data entry and basic statistical operations by repeating the tasks that you performed for the SPSS assignment #1; (2) To learn new data/statistical functions (calculating the mean of several variables for EACH case; z scores; etc.).

Data

A professor recorded three statistics exam scores and other variables for 20 students in her statistics course. There are seven variables in this data set: (1) ID number, (2) Sex, (3) Study Place, and (4) Hours of Work, (5) Exam 1 score, (6) Exam 2 score, and (7) Exam 3 score.

• Sex (1 = Males, 2 = Females)
• Study_Place (Where do you study the most frequently for this class?

1 = My room, 2 = Library, 3 = Coffee shops, 4 = others)

• Work_Hour (On average, how many hours do you spend for job-related tasks?)

Problem #1 (3 points): Data preparation using SPSS (Statistical Package for the Social Sciences). Create a SPSS data file and enter all information.

1. Define (name) the variables (7 variables; Id Exam3). Make sure to add initials of your nameto each variable.
2. Enter your data. Either you enter each value or you can copy and paste the values into SPSS data set.
3. Label the VALUES: Sex (1 = Males, 2 = Females); Study_Place (1 = My room, 2 = Library, 3 = Coffee shops, 4 = others).

Problem #2 (2 points): Calculate the average (mean) of three exam scores.

Problem #3 (5 points): Calculate the z score of the average exam score for each case.

1. (2 points) Show me the scores on all9variables (the original 7 variables, the mean exam score, and its z score) for the first 5cases.
2. (1.5 points) What is the z score of mean exam for ID #1? Interpret his z score?
3. (1.5 points) Get the mean and SD of the z scores. Review the output; can you locate the mean and SD of the z score distribution? What are the values?

Problem #4 (5 points)

1. (1.5 points) Calculate the mean and standard deviation (SD) of the mean exam score separatelyby study place.
2. (2 points) Construct a bar-graph for study place. The X-axis represents Study Place and the Y-axis represents MEAN exam score.
3. (1.5 point) Review the output from 4-a and 4-b. What conclusion can you draw from them? (for example, Would the location of study be related to average exam score?)

ID SEXSTUDY PLACE WORK HOUR EXAM1 EXAM2 EXAM3 80 72 90 94 100 70 62 60 52 91 94 100 63 2 20 95 0 10 4 10 60 92 95 82 81 90 82 98 94 65 80 84 78 70 82 80 59 90 92 2 80 80 56 13 2 30 92 83 60 100 90 90 83 50 17 18 2 2 20 0 95 ID SEXSTUDY PLACE WORK HOUR EXAM1 EXAM2 EXAM3 80 72 90 94 100 70 62 60 52 91 94 100 63 2 20 95 0 10 4 10 60 92 95 82 81 90 82 98 94 65 80 84 78 70 82 80 59 90 92 2 80 80 56 13 2 30 92 83 60 100 90 90 83 50 17 18 2 2 20 0 95