Question

Statistically analyzing the difference between two or more means is important for Psychological research

Statistical Analysis Assignment # 1

Upload the Excel Data Analysis Program onto your computer. For the data set below, please calculate:

• the mean and standard deviation for the number of hours studied and
• the mean and the standard deviation for test score.
• the correlation between the number of hours studied and the obtained test score.

What conclusion can you draw from these results?

Test Score          Hours Studied

1. 100                4

2.   90                4

3.   20                1

4.   52                2

5.   83                3

6.   76                2

7.   55                1

8.   98                4

9.   89                4

10. 70               2

Answer 1

(a)

Hours studied (x):

n = 10

= 27/10 = 2.7

s_x = 1.2517

(b)

Test score:

n = 10

= 733/10 = 73.3

s_y= 24.9222

(c)

From the data, the following Table is calculated:

X	Y	XY	X2	Y2
4	100	400	16	10000
4	90	360	16	8100
1	20	20	1	400
2	52	104	4	2704
3	83	249	9	6889
2	76	152	4	5776
1	55	55	1	3025
4	98	392	16	9604
4	89	356	16	7921
2	70	140	4	4900
Total = 27	733	2228	87	59319

Correlation Coefficient (r) is given by:

So,

Correlation Coefficient between number of hours studied and the obtained test scores is :

0.8866

(d)

Since the Correlation Coefficient between number of hours studied and the obtained test scores is strong and direct, we conclude that if a student studies more number of hours, he will obtain high test scores. if a student studies less number of hours, he will obtain less test scores