Assignment 1: Working with Data in SPSS

(PSY206) Data Management and Analysis

Author
Affiliation

Md. Rasel Biswas

IASDS, University of Dhaka

Instructions

You are provided with the dataset:
study_habits_data.xlsx (Click to download)

Download the dataset and complete all tasks using SPSS. Submit both of the following files in the designated classroom post:

  • The SPSS data file (.sav)
  • The SPSS output file (.spv)

Your output file should contain all requested tables and charts in the order presented in this assignment.

Data Overview

The dataset contains information collected from 50 undergraduate students during a classroom survey on study habits, digital-device use, sleep and class participation.

The survey includes:

  • Basic demographic information, including age, gender and department
  • Current place of residence
  • Average daily sleeping, studying and recreational screen time
  • Percentage of classes attended
  • Self-reported alertness during morning classes
  • Whether internet connectivity causes difficulty in completing academic activities

All identifying information has been removed. Categorical responses are recorded using numeric codes.

Data Head

student_id age gender department residence sleep_hours study_hours screen_time attendance_pct morning_alert internet_issue
S001 20 1 1 1 7.5 3.0 3.2 92 1 2
S002 21 2 2 2 6.0 2.0 5.5 78 2 3
S003 19 2 3 1 8.0 4.0 2.5 95 1 2
S004 22 1 4 2 5.5 1.5 6.8 68 2 1
S005 20 1 5 1 6.5 2.5 4.0 85 1 3
S006 21 2 1 2 7.0 3.5 3.6 90 1 2

Variable Coding Instructions

Variable Codes and value labels
gender 1 = Male, 2 = Female
department 1 = Statistics, 2 = Economics, 3 = Computer Science, 4 = Psychology, 5 = Mathematics
residence 1 = University hall, 2 = Off-campus
morning_alert 1 = Yes, 2 = No
internet_issue 1 = Yes, 2 = No, 3 = Sometimes

The remaining variables are recorded numerically in their original units.

Question 1 — Data Import and Setup

  1. Import study_habits_data.xlsx into SPSS.

  2. In Variable View, appropriately define:

    • Variable labels
    • Value labels for all categorical variables
    • Measurement level: nominal, ordinal or scale
    • Number of decimal places
    • Any other relevant variable properties

  3. Save the SPSS data file as study_habits_data.sav.

Question 2 — Data Exploration

Generate the following outputs in SPSS.

  1. Produce frequency tables for:

    • Gender
    • Residence
    • Morning alertness
    • Internet connectivity problem

  2. Create a bar chart showing the distribution of morning alertness.

  3. Calculate the mean, standard deviation, minimum and maximum for:

    • Age
    • Daily sleeping time
    • Daily studying time
    • Daily recreational screen time
    • Class attendance percentage

Question 3 — Data Management

Perform the following transformations and analyses.

1. Compute a screen–study ratio

Create a new variable named screen_study_ratio:

\[ \text{Screen–study ratio} = \frac{\text{Daily recreational screen time}} {\text{Daily studying time}} \]

Display descriptive statistics for the newly computed variable.

2. Categorize the screen–study ratio

Create a new categorical variable named screen_ratio_group using the following categories:

Category Definition
Low Ratio \(\leq 1.00\)
Moderate \(1.00 <\) ratio \(\leq 2.00\)
High Ratio \(> 2.00\)

Assign suitable numeric codes and value labels to these categories.

Produce a frequency table for screen_ratio_group.

3. Recode internet connectivity problems

Recode internet_issue into a new binary variable named any_internet_issue:

New category Original response
No internet issue No
Has internet issue Yes or Sometimes

Do not overwrite the original variable.

Create a bar chart showing the distribution of the recoded variable.

4. Sort cases

Sort the dataset:

  1. By attendance_pct in descending order
  2. Then by sleep_hours in descending order

5. Split-file analysis

Split the file by residence and produce a frequency table of morning_alert.

Turn off the split-file option after completing the analysis.

6. Select cases

Temporarily select students whose attendance is at least 80%.

For the selected students, calculate the mean and standard deviation of:

  • Daily sleeping time
  • Daily studying time
  • Daily recreational screen time

After producing the requested output, restore all cases.

Submission Checklist

Before submission, confirm that:

  • All variables have appropriate labels and measurement levels
  • Categorical variables have correctly assigned value labels
  • The original variables were retained during recoding
  • All requested tables and charts appear in the .spv file
  • Split File and Select Cases are turned off
  • The .sav file contains the newly created variables
  • Both required files have been submitted