Dataset
The following dataset represents study hours, test scores, and assignments submitted by
students.
ID Study_Hours Test_Score Assignments
1 2 45 5
2 3 50 6
3 4 55 6
4 5 60 7
5 6 65 8
6 7 70 8
7 8 72 9
8 9 75 9
9 10 78 10
10 11 82 10
11 12 85 11
12 13 88 12
13 14 90 12
14 15 92 13
15 16 95 14
Question
Using SPSS, analyze the above dataset and perform the following tasks:
1. Construct frequency tables for Study_Hours and Test_Score.
2. Compute the partition values (Quartiles and Percentiles) for Test_Score.
3. Calculate the Geometric Mean (GM) and Harmonic Mean (HM) for Study_Hours.
4. Compute the Quartile Deviation (QD) for Test_Score.
5. Draw a Scatter Plot between Study_Hours and Test_Score.
6. Calculate the Pearson Correlation coefficient between Study_Hours and Test_Score.
7. Obtain the Lines of Regression of:
a) Test_Score on Study_Hours
b) Study_Hours on Test_Score
Interpret the results obtained from the SPSS output.