HOLMES INSTITUTE
FACULTY OF HIGHER EDUCATION
HI6007 SPSS Assignment 02
Due Friday 4pm week 11
WORTH 30%
The data set you need to do the assignment can be found on
Blackboard in the folder “Assignments and due dates” and in the spreadsheet
“Data for Assignment 2”.
This is a group assignment and you can submit the work in groups
of up to 4 students.
You will need to complete the following tasks in SPSS and then
submit the following files online under “Assignment 2 final submission”. You
will also need to print them out and submit them as well as a hard copy:
Activity 01:
Enter all data from the spreadsheet “Data for Assignment 2”into
SPSS. You will need to set up the variable view with the following 11 variables
and then enter the data in data view:
- Student_ID,
- Year_Enrolled,
- HI001_Final_Exam,
- HI001_Assignment_01,
- HI001_Assignment_02,
- HI002_Final_Exam,
- HI002_Assignment_01,
- HI002_Assignment_02,
- HI003_Final_Exam,
- HI003_Assignment_01,
-
Activity 02:
- Do a frequency table,
histogram, normal Q – Q and the de-trended normal Q–Q for each one of the
11 variables.
- Do descriptive statistics
(mean, standard deviation, minimum, maximum) for each one of the 11
variables.
Activity 03:
- Do at least 10 different
correlations between the any pairs of variables: For example:
1.
HI001_Final_Exam and HI002_Final_Exam
2.
HI001_Assignment_01 and HI001_Assignment_02
- For each correlation discuss
the results:
1.
Are they are positive/negatively correlated?
2.
Are they weak or strong correlations?
3.
What is the significance value?
4.
What does the significance value reveal about the data we have used?
Activity 04:
2.
Do a Cronbach’s alpha reliability test on the following 9
variables: HI001_Final_Exam, HI001_Assignment_01, HI001_Assignment_02,
HI002_Final_Exam, HI002_Assignment_01, HI002_Assignment_02, HI003_Final_Exam,
HI003_Assignment_01, HI003_Assignment_02.
- Discuss the results.
- What item/s can be deleted to
improve reliability?
- What items should never be
deleted to maintain reliability of data?
- How many items need to be
deleted to achieve maximum reliability?
Activity 05:
- Copy –paste the data view and
the variable view from your SPSS file to a Word document.
- Copy-paste ALL the output from
all the activities requested in Activity 01 to 04 in SPSS and put the
answers in the same Word document.
- Answer all discussion questions
requested in Activity 01 to 04 and put the answers in the same Word
document.
- Submit a hard copy of
Assignment 02 Word document to Holmes.
- Submit a soft copy of the SPSS
files used in SPSS and the Assignment 02 Word document online under
Assignment 02 final submission.